Author Topic: createSchema.sh problem  (Read 1934 times)

fred

  • Newbie
  • *
  • Posts: 8
createSchema.sh problem
« on: August 26, 2007, 10:19:55 pm »
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.

calemadmin

  • Administrator
  • Calem Hero
  • *****
  • Posts: 300
    • http://www.calemeam.com
createSchema.sh problem
« Reply #1 on: August 28, 2007, 10:43:18 pm »
Looked like this issue was fixed in mySQL 5.1.x. See post:
http://forums.mysql.com/read.php?52,117710

Check out if you're using an early version of mySQL.
Calem Community Forum Admin

fred

  • Newbie
  • *
  • Posts: 8
createSchema.sh problem
« Reply #2 on: September 01, 2007, 09:09:19 am »
Quote from: "calemadmin"
Looked like this issue was fixed in mySQL 5.1.x. See post:
http://forums.mysql.com/read.php?52,117710

Check out if you're using an early version of mySQL.


MySQL 5.1 is in beta at the moment. I have a couple of other applications that use it and I am hesitant to move from stable to beta for this server to protect those applications. I suspect that quite a few other would be in the same situation and that is unfortunate.