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

Sqlite 2.x in Sqlite 3.x world on Sitebuilder 4

Discussion in 'Sitebuilder 4.0 for Linux' started by etoh1973, Sep 4, 2007.

  1. etoh1973

    etoh1973 Guest

    0
     
    I'm using Fedora 6 and Plesk 8.2
    Version : 2.6.20-1.2962.fc6

    When I attempt to publish using FTP; error message is that it can not publish because SQLite 2.x is not installed or found. However, SQlite 3. and pdo_sqlite extensions are found on my server. -- Surprisingly, Sitebuilder 4.0 only supports SQlite 2.x -- and I can not for the life of my find SQlite 2.x source code to recompile.
    OK : extension sqlite in state on found ----> what is found?
    OK : supported SQLite version 2.x found----------------------> its found? but......................

    XCopy gives an error message that it does not have permissions to write, but I can not find documentation to premit XCopy to write to directory for /var/www/vhosts/xxxxxx.com/httpdocs

    The other option, I do not have installed on my server using the VIP id.
    Any suggestions would be awesome to get this resolved.
    check.php -- gives the following results:
    OK : supported version of PHP found (5.1.X or newer - 5.2.1)
    OK : extension sitebuilder3 in state on found
    OK : extension pdo in state on found
    OK : extension pdo_mysql in state on found
    OK : extension sqlite in state on found ----> what is found?
    OK : extension dom in state on found
    OK : extension libxml in state on found
    OK : extension xml in state on found
    OK : extension xsl in state on found
    OK : extension spl in state on found
    OK : extension pcre in state on found
    OK : extension session in state on found
    OK : extension simplexml in state on found
    OK : extension ftp in state on found
    OK : extension openssl in state on found
    OK : extension mbstring in state on found
    OK : extension soap in state on found
    OK : extension gd in state on found
    OK : extension ctype in state on found
    OK : extension zlib in state on found
    OK : extension iconv in state on found
    OK : extension posix in state on found
    OK : extension curl in state on found
    OK : extension mysql in state on found
    OK : setting magic_quotes_gpc in state off found
    OK : setting magic_quotes_runtime in state off found
    OK : setting open_basedir in state off found
    OK : setting safe_mode in state off found
    OK : setting zend.ze1_compatibility_mode in state off found
    OK : setting mbstring.internal_encoding in state UTF-8 found
    OK : supported SQLite version 2.x found----------------------> its found? but......................
    OK : SQLite UTF-8 encoding found
    OK : GD library PNG support found
    OK : GD library GIF support found
    OK : GD library JPG support found
    OK : GD library WBMP support found
    OK : supported GD library version 2.0.1 (or newer) found
     
  2. etoh1973

    etoh1973 Guest

    0
     
    ?

    Anyone experience the same issue I'm having with publish from previous thread? Any sight to this issue would be most helpfull.
    Thanks,
     
  3. Dmitry Frantsev

    Dmitry Frantsev Golden Pleskian

    28
    57%
    Joined:
    Sep 19, 2005
    Messages:
    1,911
    Likes Received:
    0
    Sitebuilder requires SQLite 2.x installed on publishing server with UTF-8 encoding support. Unfortunately, SQLite 3.x does not supported by Sitebuilder. The thing is that SQlite required for Sitebuilder itself and for publishing host also. As I can see from the output which you posted SQLite support included for Sitebuilder as Sitebuilder itself goes wtih compiled PHP 5.2.1 where SQLite extensions already included. But SQLite also required to be installed on the publishing host where sites will be published to. I can suggest you to check this article for more details: http://kb.swsoft.com/en/1812
    Moreover there were a lot of posts on this forum related to SQLite support. Try to check them.

    As for Xcopy publishing method and permissions to /var/www/vhosts/xxxxxx.com/httpdocs folder everything is correct here. As I understand this is Plesk server and folder /var/www/vhosts/xxxxxx.com/httpdocs is owned by FTP user. Xcopy method uses xcopy function to copy files from one location to another. As all this made through WEB service apache user should have enought permissions to write into destination folder. This method not secure one and it is suggested to use in only locally on your server without Internet access. In this situation it is better to use FTP publishing method. Try to use it and let me know about the results, but before make sure that SQLite is enabled for client's PHP.
     
  4. etoh1973

    etoh1973 Guest

    0
     
    check.php

    I've check the check.php which I'm using on the site that has been configured a sitebuilder server. But, when I copy that check.php to the domain name that I want to publish to it comes up as a blank page.
    However, PHP does response and I'm able to pull php pages that were published.


    PHP 5.2.3 (cli) (built: Aug 27 2007 09:24:59)
    Copyright (c) 1997-2007 The PHP Group
    Zend Engine v2.2.0, Copyright (c) 1998-2007 Zend Technologies
    with the ionCube PHP Loader v3.1.32, Copyright (c) 2002-2007, by ionCube Ltd., and with Zend Extension Manager v1.2.2, Copyright (c) 2003-2007, by Zend Technol
    ogieswith Zend Optimizer v3.3.0, Copyright (c) 1998-2007, by Zend Technologies

    error mesage:
    PHP Warning: main(init.php): failed to open stream: Operation not permitted in
    /var/www/vhosts/kypctech.com/httpdocs/check.php on line 12
    PHP Fatal error: main(): Failed opening required 'init.php' (include_path='.:')
    in /var/www/vhosts/kypctech.com/httpdocs/check.php on line 12

    Is there a configuration issue on mine end?

    Thanks,
     
Loading...