sitebuilder cannot connect to the database

[jamalalame]

Upon initiation of the install.php page, we are having problems populating the database, we cannot get past the first step on this page.
http://sitebuilder.designlet.com/install/install.php
OR
http://216.69.172.26/install/install.php
Entering the MySQL database information, we get this error.

Process of installation has come to the end with failure. Database tables have not been created...
Please, check it...
Details see in /usr/local/sitebuilder/log/install.log file.

and the error log as follows.

[10-June-2005 23:14:24] Log of installation process
[10-June-2005 23:14:24] Create dirs...........
[10-June-2005 23:14:24] The dir "temp" is created ...Ok
[10-June-2005 23:14:24] The dir "users" is created ...Ok
[10-June-2005 23:14:24] Create config file..........
[10-June-2005 23:14:24] Unlink file "/usr/local/sitebuilder/include/config.php"
..... Ok
[10-June-2005 23:14:24] Process sql-query: USE sitebuilder
[10-June-2005 23:14:24] Result:...... Error: (code=)
[10-June-2005 23:14:24] Error on query >> USE sitebuilder
[10-June-2005 23:14:24] Process sql-query: CREATE DATABASE sitebuilder
[10-June-2005 23:14:24] Result:...... Error: (code=)
[10-June-2005 23:14:24] Error on query >> CREATE DATABASE sitebuilder
[10-June-2005 23:14:24] Create DataBase "sitebuilder"..... fail
[10-June-2005 23:14:24] Create tables...........
[10-June-2005 23:14:24] Process of installation has come to the end with failure
. Database tables have not been created... Please, check it...

The database information is correct, I can successfully login to the mysql server/database using shell access. I'm not understanding the error code. What does this mean?
[10-June-2005 23:14:24] Process sql-query: USE sitebuilder
[10-June-2005 23:14:24] Result:...... Error: (code=)

 

[eric hrf]

Originally posted by jamalalame
Upon initiation of the install.php page, we are having problems populating the database, we cannot get past the first step on this page.
http://sitebuilder.designlet.com/install/install.php
OR
http://216.69.172.26/install/install.php
Entering the MySQL database information, we get this error.

Process of installation has come to the end with failure. Database tables have not been created...
Please, check it...
Details see in /usr/local/sitebuilder/log/install.log file.

and the error log as follows.

[10-June-2005 23:14:24] Log of installation process
[10-June-2005 23:14:24] Create dirs...........
[10-June-2005 23:14:24] The dir "temp" is created ...Ok
[10-June-2005 23:14:24] The dir "users" is created ...Ok
[10-June-2005 23:14:24] Create config file..........
[10-June-2005 23:14:24] Unlink file "/usr/local/sitebuilder/include/config.php"
..... Ok
[10-June-2005 23:14:24] Process sql-query: USE sitebuilder
[10-June-2005 23:14:24] Result:...... Error: (code=)
[10-June-2005 23:14:24] Error on query >> USE sitebuilder
[10-June-2005 23:14:24] Process sql-query: CREATE DATABASE sitebuilder
[10-June-2005 23:14:24] Result:...... Error: (code=)
[10-June-2005 23:14:24] Error on query >> CREATE DATABASE sitebuilder
[10-June-2005 23:14:24] Create DataBase "sitebuilder"..... fail
[10-June-2005 23:14:24] Create tables...........
[10-June-2005 23:14:24] Process of installation has come to the end with failure
. Database tables have not been created... Please, check it...

The database information is correct, I can successfully login to the mysql server/database using shell access. I'm not understanding the error code. What does this mean?
[10-June-2005 23:14:24] Process sql-query: USE sitebuilder
[10-June-2005 23:14:24] Result:...... Error: (code=)

I'm getting the same exactly error. Are you still having this same problem? Can anyone at least supply us with table definitions if anything?

 

[jamalalame]

Cannot find index.php for admin directory

most likely you are trying to install sitebuilder with mysql user that has no permissions to create databases or users. The best solution is to use "admin" login and password; it worked with us. However, now we are stuck elsewhere,..lol.

If anyhow can help, once we login to http://sitebuilder.designlet.com/admin/index.php we get that the index.php page cannot be found.

 

[caneja]

if you are running plesk on the box then do what jamalalame says and replace ROOT for admin as the login.

Do not create a db called 'sitebuilder' and then have the app use that db. The app will want to create a new db.

-Carlos

 

[omansur]

I'm having the same problem. I used the server admin and password and that works as well as sb_user. I tried to uninstall and it does not allow me to, so to reinstall I --forced it.