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?
Go to bottomPage: 12
TOPIC: Two different MySQL Hosts
#5514
Two different MySQL Hosts 14 Years, 2 Months ago Karma: 0
I have two different databases on two different MySQL hosts. Is there a way I can set it up so that the master and slave sites use the different databases on different MySQL hosts?

I've tried it, but when I do, I get lots of error messages, such as this:

Error(1) [1142] query [CREATE OR REPLACE VIEW kos_users AS SELECT * FROM `db333623867`.`jos_users`]. DB Error: ANY command denied to user 'dbo333622596'@'%' for table 'jos_users' SQL=CREATE OR REPLACE VIEW kos_users AS SELECT * FROM `db333623867`.`jos_users`
Create User error [1142]: Query = [GRANT ALL PRIVILEGES ON `db333623867`.`jos_users` TO `dbo333622596`@`74.208.232.213` IDENTIFIED BY 'mypassword' WITH GRANT OPTION;], DB Message = [GRANT command denied to user 'dbo333623867'@'74.208.180.109' for table 'jos_users' SQL=GRANT ALL PRIVILEGES ON `db333623867`.`jos_users` TO `dbo333622596`@`74.208.232.213` IDENTIFIED BY 'mypassword' WITH GRANT OPTION;]
Error [1142] retrying query [CREATE OR REPLACE VIEW kos_users AS SELECT * FROM `db333623867`.`jos_users`]. DB Error: ANY command denied to user 'dbo333622596'@'%' for table 'jos_users' SQL=CREATE OR REPLACE VIEW kos_users AS SELECT * FROM `db333623867`.`jos_users`

It should be said that each database has a different name, on a different host, with a different user. As well, I can't change the permissions for any of the users.
NicholasJohn16
Junior Boarder
Posts: 24
graphgraph
User Offline Click here to see the profile of this user
Last Edit: 2010/10/16 21:21 By NicholasJohn16.
The administrator has disabled public write access.
 
#5518
Re: Two different MySQL Hosts 14 Years, 2 Months ago Karma: 54
The error message is clear and documented plenty of times in the forum
"command denied to user"
This mean that your MySQL user does not have enought privileges to perform the operation.

So you need to increas the MySQL user privileges and also give the access on the different DB located on the different servers.
To do that, you need the MySQL root login.
If you don't have such privileges, contact your hosting provider or the administrator of the serverS to increase your MySQL user privileges.
edwin2win
Moderator
Posts: 5370
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#5527
Re: Two different MySQL Hosts 14 Years, 2 Months ago Karma: 0
Does it not matter that these two databases are on two different hosts?
NicholasJohn16
Junior Boarder
Posts: 24
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#5530
Re: Two different MySQL Hosts 14 Years, 2 Months ago Karma: 54
NO as long as you have the permission and that your PHP server and MySQL server can connect on the other MySQL server.

Remember that when you configure a joomla installation, it ask you provide a DB host name.
So you can have any host name as long as you have access on it.

If the DB are provided by the same hosting company, in general this does not cause any problem to connect on different DB host.

If you don't have access yourself to the MySQL privileges, contact your hosting company to ask him change the MySQL privileges to give you the autorisation to do it.
edwin2win
Moderator
Posts: 5370
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#5534
Re: Two different MySQL Hosts 14 Years, 2 Months ago Karma: 0
I've tried contacting my host to change the MySQL privileges and they won't do it. They're a great host, accept for this one part.

Is there a way to force the component to only use one username when working with one of the databases and a different username when working with the other?
NicholasJohn16
Junior Boarder
Posts: 24
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#5538
Re: Two different MySQL Hosts 14 Years, 2 Months ago Karma: 54
NO it is not possible to provide you a work arround to bypass your MySQL user privileges.

The problem is that you are trying to share something between DB located on different host and this is only possible when modifying the MySQL user privileges.

If your hosting company reject to provide you the permission, perhaps you could try purchase a dedicated server to have the MySQL root login or change of hosting company.
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: 12
get the latest posts directly to your desktop
2Win, Multisite(s) are trademarks of Edwin2Win.
Joomla