Joomla Version : 1.7
Multisite Version : 1.2.64
Patch Intalled: All ok

Good day,

I have a problem about JMS. I keep getting "MakeDB - DB Connection error. WARNNOTCONNECTDB" error when i tried to create a clone site. I had edited multisites.cfg.php with the user that had that Grant.

define( 'MULTISITES_DB_GRANT_HOST', 'localhost');
define( 'MULTISITES_DB_ROOT_USER', '*****');
define( 'MULTISITES_DB_ROOT_PSW', '*****');

But still does not work.

Your response is highly appreciated.
Thanks..

By the way, we are using this php and mysql version.

PHP version 5.2.17
MySQL version 5.1.56

Just wondering if this version is compatible to your component. If php and mysql version matters.

thanks,

I suppose that you are trying to create DB dynamically and that you have provided the correct MySQL root login and password that has all the priviliges including the permission to create DBs.

If this is not the case, try create your DB manually with PHPMyAdmin or other tool to ensure that you can create the slave site.

We will try reproducing the case of dynamic DB creation with root login.

The parameter that you highlighted are used when none of the login and password of the website to replicate or new DB login and pssword provided in JMS can not be use to replicate the DB.
When none of them are working, JMS use the alternative MULTISITES_DB_ROOT_xxxx parameter to try using it.
If it also fail then it finally report the error message "MakeDB - DB Connection error ..."

Is there anywhere in the documentation or on this site that explains how to create the user with the required permissions for creation of databases and their associated users in MySQL?

The "To DB user" and "To DB psw" is automatically created when they seems not ok to create the new DB and when the MULTISITES_DB_ROOT_xxxx are present.

So if you setup a JMS Template rule where you define the new DB user and potential a new DB random password (see keywords in the yellow light), they may be created dynamically.

Hi Edwin, i had create a new fresh joomla 1.7 and installed multisite 1.2.64. I done all configuration patches, registration, use a database user that had a grant and everthing is fine. I also had create a template similar to our current working multisite template which is on Joomla 1.5. Also, i had set the global configuration on Joomla Database Type on Mysql. Everything is fine and everything is set, then i tried to create a clone but i still got this error.

JDatabase::getInstance: Could not connect to database
joomla.library:2 - Could not connect to MySQL host=[localhost] with user=[user_****]

And when i press back. I get this red error on Joomla saying :

MakeDB - DB Connection error. WARNNOTCONNECTDB

It just frustrate me that i still got this error. It suppose to work. I'm sure there is no conflict or something cause i am using a fresh joomla 1.7. I'm wondering that there is something wrong multisite on Joomla 1.7 and that is my conclusion for now. Also, i'm wondering if multisite on Joomla 1.7 is stable.

Any idea about this? thanks..