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?

database errors on creating new slave site
(1 viewing) (1) Guest
Go to bottomPage: 1234
TOPIC: database errors on creating new slave site
#5039
Re: database errors on creating new slave site 13 Years, 10 Months ago Karma: 1
you can ask your hosting provider to increase your permission.
ryscript
Junior Boarder
Posts: 30
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#5464
Re:database errors on creating new slave site 13 Years, 8 Months ago Karma: 1
Hi edwin

now I created slave site and I get this error
"Create DB error [1044]: Query = [CREATE DATABASE `TEST_DB` CHARACTER SET `utf8`],DB
Message = [Access denied for user 'TEST_USER'@'localhost' to database'TEST_DB'
SQL=CREATE DATABASE `TEST_DB` CHARACTER SET `utf8`]"

I already set my user permissions to GRANT in WHM.

when I created slave site I use this parameters:
Site ID: domain.com => Addon Domain
List of domain names (*): domain.com
Diploy Directory is: /home/USER/public_html

Thanks
Ryan
ryscript
Junior Boarder
Posts: 30
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#5465
Re:database errors on creating new slave site 13 Years, 8 Months ago Karma: 54
The error message is clear
"Access denied for user"

that mean that you don't have increase the MySQL user with correct privileges.

Use for example the MySQL root login that has all privileges and that will help you identify which privileges you have to increase to your user "TEST_USER"
edwin2win
Moderator
Posts: 5370
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#5467
Re:database errors on creating new slave site 13 Years, 8 Months ago Karma: 1
Updated: Hi edwin thanks for your quick reply.
I do what you say and not working I change the user permissions and same error happened.
by the way this error happened after we move to a new VPS server.
ryscript
Junior Boarder
Posts: 30
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#5471
Re:database errors on creating new slave site 13 Years, 8 Months ago Karma: 54
If you moved of server, check also the MySQL host parameter that might be sometimes wrong.
You can force the value in the multisites.cfg.php file.
edwin2win
Moderator
Posts: 5370
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#5498
Re:database errors on creating new slave site 13 Years, 8 Months ago Karma: 1
thanks the problem were solve.

but after I created slave site using the Addon domain I created then I type domain.com I can't see the slave site I create. and if I type the full path master.com/slave.com/ and it shows.
do I need to redirect the slave site/Addon domain or what? please help me.


Thanks
Ryan
ryscript
Junior Boarder
Posts: 30
graphgraph
User Offline Click here to see the profile of this user
Last Edit: 2010/10/14 11:24 By ryscript.
The administrator has disabled public write access.
 
Go to topPage: 1234
get the latest posts directly to your desktop
2Win, Multisite(s) are trademarks of Edwin2Win.
Joomla