Updated:
I have run into a wall with the creatiSchema.sh script. I am running CentOS 5 with all the required versions of Apache, PHP and MySQL. I have confirmed that I have inserted the correct admin user and password in the calem.custom.php script. I fixed the URI paths in the calem.custom.php script. I get the following when I run the script (from log4php):
2007-08-21 11:18:04,631 INFO MysqlHandler - db admin connection: user=root, password=***, , connection=mysql:host=localhost
2007-08-21 11:18:04,631 DEBUG CalemPdo - query() time:0.0006, sql=show databases
2007-08-21 11:18:04,631 DEBUG MysqlHandler - database: array (
'Database' => 'information_schema',
0 => 'information_schema',)
2007-08-21 11:18:04,631 DEBUG MysqlHandler - database: array (
'Database' => 'mysql',
0 => 'mysql',)
2007-08-21 11:18:04,631 DEBUG MysqlHandler - database: array (
'Database' => 'test',
0 => 'test',)
2007-08-21 11:18:04,631 ERROR CalemDbSetup - SQLSTATE[HY000]: General error: 2030 This command is not supported in the prepared statement protocol yet, executing sql=CREATE DATABASE IF NOT EXISTS calemeam CHARACTER SET utf8 COLLATE utf8_general_ci
2007-08-21 11:18:04,631 ERROR CalemDbSetup - SQLSTATE[HY000]: General error: 2030 This command is not supported in the prepared statement protocol yet, executing sql=CREATE USER 'calemeam'@'localhost' IDENTIFIED BY 'calemeam'
2007-08-21 11:18:04,631 ERROR CalemDbSetup - SQLSTATE[HY000]: General error: 2030 This command is not supported in the prepared statement protocol yet, executing sql=GRANT SELECT, UPDATE, INSERT, DELETE, CREATE, ALTER, INDEX ON `calemeam`.* TO 'calemeam'@'localhost'
2007-08-21 11:18:04,631 INFO MysqlHandler - calem db connection: user=calemeam, password=***, , connection=mysql:host=localhost;dbname=calemeam, persistent connection=Array
2007-08-21 11:18:04,631 ERROR SetupCalemDatabase - Error in setting up db, error=SQLSTATE[28000] [1045] Access denied for user 'calemeam'@'localhost' (using password: YES)
2007-08-21 11:18:04,631 INFO MysqlHandler - calem db connection: user=calemeam, password=***, , connection=mysql:host=localhost;dbname=calemeam, persistent connection=Array
It seems as though the MySQL Admin user is not being used. Any ideas.
