English (United Kingdom)
Jms Multi Site, formerly joomla multisite.
Create, share multiple joomla sites in few clicks !
Message
  • EU e-Privacy Directive

    This website uses cookies to manage authentication, navigation, and other functions. By using our website, you agree that we can place these types of cookies on your device.

    View e-Privacy Directive Documents

Welcome, Guest
Please Login or Register.    Lost Password?

Use Template to create new DB? on latest version..
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: Use Template to create new DB? on latest version..
#1958
Use Template to create new DB? on latest version.. 15 Years, 3 Months ago Karma: 0
Hi there,

Can we use now the tempate to create new DB? on latest version of jms?

i am using this version: "com_multisites_V1.2.4.zip" its seem not create new DB using the template but there is information of db inside the manage site tabs, look like this:

DB host name: localhost
DB: austrian_test5
DB prefix: sbh_
DB user: test5_jms
DB password: CUbPbNmsTEhKWALh

but no DB was create on phpmyadmin

Thanks,

Jeff
jsohler
Junior Boarder
Posts: 33
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#1959
Re:Use Template to create new DB? on latest version.. 15 Years, 3 Months ago Karma: 54
YES JMS can create DB and also create users when you provide to it a MySQL root login and password in the "multisites.cfg.php" files as explained in user manual.

So the key element is to provide a MySQL user that has the permission to create such dynamic DB.
When the login and password you provide does not allow such permission, JMS try to use the alternative MySQL root login and password you have provided in the configuration file.

So in your case, if you have not configured the JMS configuration file with such MySQL root login and password, it uses the test5_jms and its password to try create the DB.
If this "test5_jms" has no MySQL permission to create the DB, the operation will fail.
edwin2win
Moderator
Posts: 5370
graph
User Offline Click here to see the profile of this user
Last Edit: 2009/09/28 17:14 By edwin2win.
The administrator has disabled public write access.
 
#1964
Re:Use Template to create new DB? on latest version.. 15 Years, 2 Months ago Karma: 0
Im still not create new DB using Template, even if i put now the MySQL root username and root password.

Is there a related on phpMyAdmin and MySQL version? so that JMS cant create new DB

Here my version:

php - 5.2.6
MySQL client version: 4.1.22
Server version: 5.0.81-community
phpMyAdmin - 2.11.9.5

I also use "localhost" as a DB host name, both on template and multisite.cfg.php.

Thanks,
jsohler
Junior Boarder
Posts: 33
graphgraph
User Offline Click here to see the profile of this user
Last Edit: 2009/09/29 10:38 By jsohler.
The administrator has disabled public write access.
 
#1965
Re:Use Template to create new DB? on latest version.. 15 Years, 2 Months ago Karma: 54
No this is not related to PYPMyAdmin or whatever.
JMS uses the MySQL login and password to perform the operation.
If the permission does not allow the user to create such DB and/or users, the creation may fail.

If the error message does not provide you a clear reason, the only solution is to debug the db creation on your system.
If you want that we debug your system, this is possible with our billable support that you can order on www.jms2win.com/download?page=shop.produ...35&category_id=1
edwin2win
Moderator
Posts: 5370
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
Go to topPage: 1
get the latest posts directly to your desktop
2Win, Multisite(s) are trademarks of Edwin2Win.
Joomla