MODX could not create your database

87 Posts

Gibbs Reply #1, 11 years, 9 months ago

I've had this a few times and I can't remember how I resolved it previously. The database details are correct in the setup but something funky is happening. This is the response from the connector:

{  
   "message":"MODX could not create your database. Please manually create your database and then try again.",
   "fields":[  

   ],
   "type":"error",
   "object":[  
      "[2014-12-19 05:34:20] (ERROR in xPDOConnection::connect @ \/home\/wiki\/goldcoastmedia.ltd.uk\/wiki\/modx\/core\/xpdo\/xpdo.class.php : 3043) SQLSTATE[28000] [1045] Access denied for user 'wiki'@'localhost' (using password: NO)\n",
      "[2014-12-19 05:34:20] (ERROR @ \/wiki\/setup\/processors\/connector.php) Could not connect to database server: SQLSTATE[28000] [1045] Access denied for user 'wiki'@'localhost' (using password: NO)\n"
   ],
   "success":false
}

Nowhere have I set the database user as 'wiki'. Neither the database name or the user is called that. That is the user the PHP process is running. Besides the database already exists.

- 289 Posts
ReSpawN Reply #2, 11 years, 9 months ago

Gibbs (you wouldn't by any chance be called Leroy or Jethro right? ),

Obviously your error originates in the lack of configuration or default connections. Your user in DA/Plesk or what ever, as I understand it, is 'wiki'. Now that, by default, is always the connecting user.

You'd want to check your MODX configuration in core/config/config.inc.php and check up on the variables defined in $database_user, $database_password, $dbase and $database_dsn. Make sure all those variables check out.
The next I am wondering if why you're running a connection from a connector - is your MODX even installed (does the manager work, does the frontend)? That's be your first couple of steps in figuring this out.

Don't worry, we'll get this sorted.
@MarkGHErnst

Developer at Adwise Internetmarketing, the Netherlands.