Page 1 of 1

Can not install database (please help)

Posted: Thu Nov 12, 2009 10:41 pm
by jan5522
Hi there,

i can't install the database through the install script. It says Unsuccesfull for each table creation.

It's definitely not a privilege problem. I granted all privileges to cms_user and I also tried it as root. Well, as the install script didn't work for me I wanted to install the DB manually, but only found two sql files which do not contain the CREATE TABLE commands. So I checked the install script. Maybe there are PHP 5 commands in it, so that it doesn't work with my PHP 4.3 installation. Please someone send me a DB-Export of a standard installation. I would be very, very grateful if someone could post the file in this forum or send it to me (jan5522[at]gmx.de). Thank You!!

Re: Can not install database (please help)

Posted: Fri Nov 13, 2009 1:53 am
by Somebody_1
Hi

Attached is an export of my cmsms 1.6.6 base install DB

database name: empty
user: empty
pass: empty

CMSMS Admin
user: admin
pass: empty

With reference to empty i mean the word not leave it empty!

Rename attachment to .sql

Re: Can not install database (please help)

Posted: Fri Nov 13, 2009 4:47 am
by replytomk3
Did checksum passed? What did you specify as the name of the database during installation?

Re: Can not install database (please help)

Posted: Fri Nov 13, 2009 8:12 am
by Peciura
...cms_user and I also tried it as root...
You don't need to create special shell user for CMSms site. You should allow user ("httpd", "www-data", "apache",...)  representing Apache server to access MySQL server (usually it is already done for us).
In config.php file there is login data to access data base only, usually they are not useful  to log in to Linux machine.

CMSms 2.0 installation  require
... PHP 5.2+, and forever breaking PHP4 support.
I had serious trouble with PHP4 a year ago.