• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Sitebuilder and Sqlite 3?

N

Netcontac

Basic Pleskian
SQLite 2.x on CentOS 4.2

Hi,

Today my ISP told me that SQLite 2.x is not compatible with my system, that installing it will cause conflicts, but version 3.x is fine and working.

I am not sure what could happen if I install it, I am ruining CentOS 4.2 (2.6.9-023stab044.4-enterprise) with Virtuozzo and Plesk 8.2.0.

Any way, I had to admit that it did sound weird from the beginning that the new SB does not use the newest components from the time it was released, this is against the software development paradigm, also that SW-soft would not make the proper adjustments after so much complains about SQLite 2.x deployments since SB 3.0.

So weird that I will appreciate your comments to confirm or not what I had just realized.

Greetings,

PD In case that my ISP is right, please let me know bout other better Web site builders.
 
Sitebuilder requires SQlite 2.x for publishing sites, so SQlite v.2.x and SQlite 2.x extension for PHP should be installed on the server where published sites will be stored. Basically, as I know sqlite 2.x and sqlite 3.x can be both installed on the server and there should not be conflicts. Unfortunately, sqlite 3.x does not supported by Sitebuilder right now.
Indeed, sqlite 2.x enabling procedure is not difficult one in most cases. For some of the PHP versions there are compiled packages exists which should be just installed on the server and that's all. Which version of PHP do you have on published side server?
 
Originally posted by Dmitry Frantsev
Indeed, sqlite 2.x enabling procedure is not difficult one in most cases. For some of the PHP versions there are compiled packages exists which should be just installed on the server and that's all. Which version of PHP do you have on published side server? [/B]
Click to expand...

PHP Version=5.1.6

I would appreciate you let me know about such procedures. I found something about recompile.

Considering I am using SWsoft products: Virtuozzo 3.0.0-144 and psa v8.2.0_build82070706.15 os_CentOS 4.2, it is possible to make an standard procedure that may be useful by others like me.
 
In this case, sqlite.so extensions should be compiled on the server directly. Or you can try to find already compiled php-sqlite package for v.5.1.6. Unfortunately, I was not able to find it. I think information from this thread can be helpful: http://forum.swsoft.com/showthread.php?threadid=42782&highlight=SQLite1.0.3
You can use the same procedure for compiling sqlite.so extension for your PHP 5.1.6.
Also, this link should be useful also:
http://fedoraforum.org/forum/showthread.php?t=59802&highlight=php+sqlite
 
I reviewed both procedures and I got a few questions:

1. What must be done with /usr/lib/php/modules/pdo_sqlite.so file?

2. Is necessary the step from the second procedure made after a first compilation:

edit sqlite.c, comment out the following line:
/* static unsigned char arg3_force_ref[] = {3, BYREF_NONE, BYREF_NONE, BYREF_FORCE }; */

And then 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)
Click to expand...

3. What happened with the SQLite 3 preinstalled in the system? What programs must be modified to avoid conflicts? There is no other application in the server than the SWsoft mentioned above.

Thank you
 
1. After sqlite.so file will be compiled you can exclude pdo_sqlite.so extension from PHP configuration and include sqlite.so file.

2. This procedure should be done if you met an error related to 'undefined BYREF_NONE' parameters.

3. As far as I know sqlite and sqlite3 could be installed on the same server and it should not cause any issues.

Originally posted by Netcontac

1. What must be done with /usr/lib/php/modules/pdo_sqlite.so file?

2. Is necessary the step from the second procedure made after a first compilation:

3. What happened with the SQLite 3 preinstalled in the system? What programs must be modified to avoid conflicts? There is no other application in the server than the SWsoft mentioned above.
Click to expand...
 
Dmitry,

Thank you very much.

I installed it. check.php gets a valid output now.

Now I hope not to deal with all those "problems" my ISP said.

Kind regards
 
Here I am again.

Until now the server works fine but SiteBuilder does not publish:

Trying FTP and XCopy I get:
Error: The site cannot be published to the specified location.
An error has occurred during publishing via XCopy. Please contact the server administrator.
Click to expand...
Logs:
System 9/6/2007 3:47:41 PM admin 189.146.242.31 Can't put content into file 'a2420c1cc3bd5ee52ff9378e03d19f50.php'...
Details
Creation date 9/6/2007 3:47:41 PM
Level Error
Source System
User name admin
IP address 189.146.242.31
Requested URL /Admin/Site/Publish
Referrer URL http://sitebuilder.domain.tld/Admin/Site/List
User agent Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.8.1.6) Gecko/20070725 Firefox/2.0.0.6
Message Can't put content into file 'a2420c1cc3bd5ee52ff9378e03d19f50.php'
Site name: user
Site owner: admin
Publication settings target: /var/www/vhosts/domain.tld/httpdocs
Publication settings url: http://domain.tld/


System 9/6/2007 3:47:41 PM admin 189.146.242.31 Action status: 2; Target: /Admin/Site/List; Messages: The site cannot be published to the specified location.
Details
Creation date 9/6/2007 3:47:41 PM
Level Error
Source System
User name admin
IP address 189.146.242.31
Requested URL /Admin/Site/Publish
Referrer URL http://sitebuilder.domain.tld/Admin/Site/List
User agent Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.8.1.6) Gecko/20070725 Firefox/2.0.0.6
Message Action status: 2; Target: /Admin/Site/List; Messages: The site cannot be published to the specified location.
Click to expand...

I had reviewed the installed components but there are not visible problems, I neither find such errors documentad.

It seems XCopy the better way to publish because everything is in the same server but I do not know what is made by the installation tool in case that further permission settings would be required, I hope not for each domain.

Kind Regards
 
Please check that /var/www/vhosts/domain.tld/httpdocs folder does not contain files owned by 'root'. Sometimes people put there check.php file under 'root' account which prevents Sitebuilder to publish because of insufficient permissions.
As I understand you have Plesk on the same server, in this case it is better to use FTP publishing process, as XCopy not secure enough. For XCope publishing process apache user must have write permissions to destination folder. So try to use FTP publishing method and let me know how everything goes.
 
I deleted root owned files.

XCopy gived the same error.

FTP shows this:
Error: The site cannot be published to the specified location.
An error has occurred during publishing via FTP. Please contact the server administrator.
Click to expand...

Logs:
System 9/7/2007 7:44:54 AM admin 189.146.241.31 Action status: 2; Target: /Admin/Site/Edit; Messages: The site cannot be published to the specified location.

Details
Creation date 9/7/2007 7:44:54 AM
Level Error
Source System
User name admin
IP address 189.146.241.31
Requested URL /Admin/Site/CheckTargetForEdit
Referrer URL http://sitebuilder.domain.tld/Admin/Site/Edit?siteId=33e4a8c0321ab58a40cab8134e3afe39
User agent Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.8.1.6) Gecko/20070725 Firefox/2.0.0.6
Message Action status: 2; Target: /Admin/Site/Edit; Messages: The site cannot be published to the specified location.


System 9/7/2007 7:44:54 AM admin 189.146.241.72 Cannot read source from '/usr/local/sitebuilder/resources/publish/check.php' via FTP...

Details
Creation date 9/7/2007 7:44:54 AM
Level Error
Source System
User name admin
IP address 189.146.241.31
Requested URL /Admin/Site/CheckTargetForEdit
Referrer URL http://sitebuilder.domain.tld/Admin/Site/Edit?siteId=33e4a8c0321ab58a40cab8134e3afe39
User agent Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.8.1.6) Gecko/20070725 Firefox/2.0.0.6
Message Cannot read source from '/usr/local/sitebuilder/resources/publish/check.php' via FTP
Site name: ftpuser
Site owner: admin
Publication settings target: ftp://[email protected]/httpdocs
Publication settings url: http://domain.tld/
Click to expand...

I have doubts about FTP, because the users belongs to VHosts, that means that their username is linked to the VHosts, but in SiteBuilder it is to the Host (64.131.68.94) in this case.
 
Originally posted by SibProgrammer
Try to check the file and permissions on it:
/usr/local/sitebuilder/resources/publish/check.php
Click to expand...

What permissions? Those related to the file system are 644 (rw,r,r)
 
Hm, haven't any more ideas. This need investigations on your server, so try to contact support.

Or try to write simple test.php script:
<?php
error_reporting(E_ALL);
var_dump(is_file('/usr/local/sitebuilder/resources/publish/check.php'));
?>
Put it inside /usr/local/sitebuilder/htdocs/ and look at the output at http://<your-sb-domain>/test.php
The output must be "bool(true)"
 
Originally posted by SibProgrammer

Put it inside /usr/local/sitebuilder/htdocs/ and look at the output at http://<your-sb-domain>/test.php
The output must be "bool(true)"
Click to expand...

The output is bool(false)

Today I neither find such file, instead there is /usr/local/sitebuilder/resources/publish/checkHtaccessOptions.php

I also tried http://sitebuilder.domain.tld/check.php with everything OK.

However, I do not see why the FTP is not working, SB must work as a simple FTP client trying to deploy some files as currently do others, unless SB does not detect the data connection type or something like that.
 
You must have '/usr/local/sitebuilder/resources/publish/check.php file. Have you manually removed this file? If so, you must repair you installation (get this file from distribution package). This file isn't the same as located at /usr/local/sitebuilder/htdocs/check.php (and you check it by the URL - http://sitebuilder.domain.tld/check.php)
 
How can I get the file?

I installed SB using psa_installer_v3.2.0 and it apparentely does not allow reinstallations.
 
Finally FTP works!

I do not know how a file as important as that got lost. I hope no others were to.

The XCopy functionality does not work yet, it is not so important for been an insecure method. I just hope it is not because other missed file.

Now it is time to make test with end users to see how it works.

In case that a clean re installation would be required, Does the yum procedure removes all the files including the language and other modules or it is necessary to first remove SB, then such modules?

Thank you very much.
 
I've upgraded to CentOS5 64bit and I have sqlite-3.3.6 installed, but Sitebuilder doesn't seem to like this and tells me that I need sqlite 2.x. I tried forcing an uninstall of sqlite 3, but then both rpm and yum stopped working so I was never able to install sqlite2.

Any idea how to solve this? Which packages can I install to fix this, and where can I find them?
 
I'm running CentOS5 64bit, and have been able to compile the sqlite.so as specified. Sitebuilder now says that publishing is available, but some sites still don't work. This is probably because I'm running SQlite 3.3.6 while SB need SQlite 2.

One error I get a lot is:
PHP Fatal error: Call to undefined function sqlite_escape_string() in /var/www/vhosts/domain.tld/httpdocs/include/SB/Modules/Storage/Db/Adapter/Sqlite.php on line 790

I've tried installing a SQlite 2 rpm, but then I get the error:

error: Failed dependencies:
libsqlite3.so.0()(64bit) is needed by (installed) apr-util-1.2.7-6.x86_64
libsqlite3.so.0()(64bit) is needed by (installed) python-sqlite-1.1.7-1.2.1.x86_64
libsqlite3.so.0()(64bit) is needed by (installed) yum-metadata-parser-1.0-8.fc6.x86_64
libsqlite3.so.0()(64bit) is needed by (installed) rpm-4.4.2-47.el5.x86_64
libsqlite3.so.0()(64bit) is needed by (installed) rpm-libs-4.4.2-47.el5.x86_64
libsqlite3.so.0()(64bit) is needed by (installed) php-pdo-5.2.5-2.el5.art.x86_64
libsqlite3.so.0()(64bit) is needed by (installed) rpm-build-4.4.2-47.el5.x86_64

Any ideas on how I can install SQlite 2 along with the existing SQlite 3?
 
You must log in or register to reply here.

Similar threads

hardbrasil
Contribution Clamav on Plesk 12.5 - Centos 6
Replies
6
Views
4K
lvalics
lvalics
T
Internal error: filemng failed, permission denied
Replies
1
Views
2K
IgorG
IgorG
V
Sitebuilder 4.2 and the PHP 5.2.6 with SQLite 3.x
Replies
1
Views
2K
Dmitry Frantsev
D
E
Sqlite 2.x in Sqlite 3.x world on Sitebuilder 4
Replies
3
Views
3K
etoh1973
E
R
sitebuilder does not work/
Replies
18
Views
11K
ewhitecap
E
Back
Top