1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Plesk and Centos 5.x 64 Bits - Everything OK?

Discussion in 'Plesk for Linux - 8.x and Older' started by zooming, Nov 3, 2008.

  1. zooming

    zooming Regular Pleskian

    25
    57%
    Joined:
    Jul 12, 2006
    Messages:
    112
    Likes Received:
    0
    Hello,

    Anyone knows if Plesk and Centos 5.x 64 bits is a good combination for shared hosting?

    Are there any issues with common hosting applications because of the 64 bits Centos?

    I'm planning to get a new server with 4 GB RAM, and I'm not sure if I'll be able to use all this memory with the 32 bits Centos version (at least in Windows I can use only 3 GB and after some system initialization hacks).

    Thank you.
    Alexandre
     
  2. atomicturtle

    atomicturtle Golden Pleskian

    29
     
    Joined:
    Nov 20, 2002
    Messages:
    2,110
    Likes Received:
    7
    Location:
    Washington, DC
    yup, works just fine
     
  3. zooming

    zooming Regular Pleskian

    25
    57%
    Joined:
    Jul 12, 2006
    Messages:
    112
    Likes Received:
    0
    Hello,

    Do you have a Atomic install guide for Plesk? :)
    I'm moving to a bigger server, and I'll probably use this chance to upgrade Plesk (8.3->8.6), SB (4.2->4.5), etc.
    This time I'll try to use your repos, but I have looked at your site, and I have noticed that there are many RPMs for various softwares.
    I also have a ASL subscription. Will I have trouble to migrate this subscription to the new server?
    Any tip will be welcome.

    Thank you.
    Alexandre
     
  4. atomicturtle

    atomicturtle Golden Pleskian

    29
     
    Joined:
    Nov 20, 2002
    Messages:
    2,110
    Likes Received:
    7
    Location:
    Washington, DC
    No but thats a great idea, maybe add that into the atomicorp wiki or something. You shouldn't have any trouble migrating ASL to it, just run the installer again like you did on the current box.
     
  5. zooming

    zooming Regular Pleskian

    25
    57%
    Joined:
    Jul 12, 2006
    Messages:
    112
    Likes Received:
    0
    Problems with Centos 5.2 64 Bits, SiteBuilder 4.5 and SQLite 2

    Well, not everything OK.

    I'm having a serious problem with SiteBuilder 4.5 and SQLite 2.
    SiteBuilder requires SQLite 2 with UTF8 support, but apparently it is not available for Centos 5.2 64 bits.
    And it looks like SiteBuilder does not work with SQLite 3 yet.

    Yum shows this package:

    yum search sqlite2
    ...
    php-sqlite2.x86_64 : PHP5 bindings to SQLite, a file-based SQL engine

    But I can't install it:

    yum install php-sqlite2
    ...
    Package php-pdo - 5.2.6-1.el5.art.x86_64 already installed and latest version
    Nothing to do

    I have tried to compile and install SQLite 2, but it's not working, SiteBuilder is showing some error 500 messagens and the sites are not working.

    wget http://pecl.php.net/get/SQLite-1.0.3.tgz
    tar zxvf SQLite-1.0.3.tgz
    cd SQLite-1.0.3

    vi libsqlite/src/main.c

    #ifdef SQLITE_UTF8
    const char sqlite_encoding[] = "UTF-8";
    #else
    const char sqlite_encoding[] = "UTF-8";
    /* const char sqlite_encoding[] = "iso8859"; */
    #endif

    vi sqlite.c

    Comment the line bellow:
    /* static unsigned char arg3_force_ref[] = {3, BYREF_NONE, BYREF_NONE, BYREF_FORCE }; */

    Change these lines:

    function_entry sqlite_functions[] = {
    PHP_FE(sqlite_open, arg3_force_ref)
    PHP_FE(sqlite_popen, arg3_force_ref)

    To:

    function_entry sqlite_functions[] = {
    PHP_FE(sqlite_open, third_arg_force_ref)
    PHP_FE(sqlite_popen, third_arg_force_ref)

    phpize

    ./configure --with-sqlite --with-php-config=/usr/bin/php-config
    make

    cp modules/sqlite.so /usr/lib64/php/modules

    vi /etc/php.d/sqlite.ini

    ; Enable sqlite extension module
    extension=sqlite.so

    php -v
    apachectl -t
    apachectl restart

    Everything looks OK, but it's not working.

    SiteBuilder's log shows messages like this:

    Invalid server response: http/1.0 500 internal server error ...
    Cannot update modules data....

    Can anyone help me?

    Thank you.
    Alexandre
     
  6. zooming

    zooming Regular Pleskian

    25
    57%
    Joined:
    Jul 12, 2006
    Messages:
    112
    Likes Received:
    0
    Hello,

    I'm trying to recompile PHP 5.2.6 too, to remove the "--without-sqlite" configure option, according to instructions in this page:

    http://download1.swsoft.com/SiteBui.../known_issues_with_third_party_components.htm

    wget http://3es.atomicrocketturtle.com/packages/php/php-5.2.6-2.art.src.rpm
    rpm -hUv php-5.2.6-2.art.src.rpm
    cd /usr/src/redhat/SPECS
    vi php-art.spec

    (I'm not sure if it will work anyway, there are several comments about sqlite2 in the spec file...)

    Remove "--without-sqlite" and add "--enable-sqlite-utf8" around line 505.

    rpmbuild -bb php-art.spec

    But I receive several error messages:

    cat: /usr/include/httpd/.mmn: No such file or directory
    error: Failed build dependencies:
    bzip2-devel is needed by php-5.2.6-2.art.x86_64
    curl-devel >= 7.9 is needed by php-5.2.6-2.art.x86_64
    ...

    I have tried to install all these "devel" packages:

    yum install bzip2-devel curl-devel db4-devel expat-devel gmp-devel aspell-devel httpd-devel libjpeg-devel libpng-devel pam-devel openssl-devel sqlite-devel pcre-devel readline-devel gcc-c++ krb5-devel libc-client-devel cyrus-sasl-devel openldap-devel freetds-devel postgresql-devel unixODBC-devel libxml2-devel net-snmp-devel libxslt-devel libxml2-devel ncurses-devel gd-devel freetype-devel libmcrypt-devel mhash-devel libtidy-devel

    yum install mysql-devel-5.0.58

    Try to rebuild again:

    rpmbuild -bb php-art.spec

    ...
    configure: error: There is something wrong. Please check config.log for more information.
    error: Bad exit status from /var/tmp/rpm-tmp.56781 (%build)


    RPM build errors:
    Bad exit status from /var/tmp/rpm-tmp.56781 (%build)

    There are two "config.log" files:

    /usr/src/redhat/BUILD/php-5.2.6/build-cgi/config.log
    /usr/src/redhat/BUILD/php-5.2.6/build-cgi/libevent/config.log

    But I could not figure out what is wrong.

    Atomicturtle, can you lead me to the light? :)

    Thank you.
    Alexandre
     
  7. atomicturtle

    atomicturtle Golden Pleskian

    29
     
    Joined:
    Nov 20, 2002
    Messages:
    2,110
    Likes Received:
    7
    Location:
    Washington, DC
    What are you trying to do? Sqlite is enabled in the package already, so Im not really clear on what youre trying to accomplish
     
  8. zooming

    zooming Regular Pleskian

    25
    57%
    Joined:
    Jul 12, 2006
    Messages:
    112
    Likes Received:
    0
    Yes it is, but version 3, or am I missing something?
    My problem is that SiteBuilder and the published sites are not working properly.
    SiteBuilder claims that the target server (which is the same where SB is installed) does not have the proper sqlite version while I'm publishing a site.
    They need sqlite version 2.x with UTF8 support, they don't work with version 3.
    So I'm trying to install/enable sqlite 2 with PHP 5.2.6
     
  9. zooming

    zooming Regular Pleskian

    25
    57%
    Joined:
    Jul 12, 2006
    Messages:
    112
    Likes Received:
    0
    I'm considering to downgrade PHP to version 5.1.6
    Is it a good ideia?
     
  10. zooming

    zooming Regular Pleskian

    25
    57%
    Joined:
    Jul 12, 2006
    Messages:
    112
    Likes Received:
    0
    It's weird... Sitebuilder's check.php page shows that everything is OK, including sqlite 2.x and UTF8.

    But Sitebuilder cannot publish the sites, and the already published are not working (blank pages in pages where sqlite is used).

    The error_log of one of these sites shows messages like this:

    PHP Fatal error: Call to undefined function sqlite_escape_string() in /var/www/vhosts/xxxx.org.br/httpdocs/include/SB/Modules/Storage/Db/Adapter/Sqlite.php on line 764
     
  11. zooming

    zooming Regular Pleskian

    25
    57%
    Joined:
    Jul 12, 2006
    Messages:
    112
    Likes Received:
    0
    It looks like there is a problem with sqlite.so in a x86_64 server.
    The site's error_log file shows some problems with memory allocation.
    There is a KB at Parallels about this issue, asking to compile SQLite version 2.8.17, getting the sources from svn.
    The problem is that this version does not compile, there are several error messages after the "make" command.
     
  12. zooming

    zooming Regular Pleskian

    25
    57%
    Joined:
    Jul 12, 2006
    Messages:
    112
    Likes Received:
    0
    The compiled sqlite.so provided by Dmitry did the job.
    Everything OK now.
     
Loading...