Can't connect to my own MySQL server

akusto · 10-8-04, 04:45 PM

Right after the load balancing started, I started to have errors on my page. I cannot access my private MySQL-database anymore.

I get continuosly this error: Host 'www15.powweb.com' is not allowed to connect to this MySQL server

The number 15 above has been something random between 11-18

One of these hosts still allows me to connect. This happens once in a minute or something like that... I guess it's www12.powweb.com where my site is hosted on.

Just check it out yourself: http://www.ainiarecords.com/index.php?page=sale_test

Can I do something about it on php.ini or is this a problem at powwebs end?

Pig · 10-8-04, 05:37 PM

The load balanced servers seem to be having an issue that affects the global php.ini, and staff are aware of it. I would try manually placing a copy of the global php.ini in all the affected directories, and see if that makes a difference.

akusto · 10-8-04, 09:27 PM

Tried, but did not make any difference...

It seems that www12.powweb.com allows me to connect to my own MySQL-server and the rest not.

I think I will mirror my own database to powwebs MySQL-server. That would be faster access for the servers anyway.

I simply don't have time to play with this now.

akusto · 10-8-04, 10:54 PM

Mirroring was a good idea. I manually copied the databases from my private system to powweb's database. And it really became faster, but now it seems that I cannot connect mysql07.powweb.com from my private system... I want to update the databases remotely.

My system's giving me this error: "Can't connect to MySQL server on 'mysql07.powweb.com' (115)" - maybe because powweb is blocking the foreign ip or something like that, I guess...

Are there limitations from where one can access the powweb's MySQL?

tbonekkt · 10-8-04, 10:55 PM

Quote:

Originally Posted by akusto

Are there limitations from where one can access the powweb's MySQL?

Yes - we do not allow remote MySQL connections.

akusto · 10-8-04, 11:07 PM

Thinking once again.. that can be problem at my end..

I need to check the mysql permissions...

akusto · 10-9-04, 06:33 AM

Now I got it. My private system allowed only www12.powweb.com and blocked the rest.

When I changed the MySQL privileges to www%.powweb.com at my own system it started accepting all the load balanced servers.

I still prefer mirroring the database, since it seems to be much faster to browse. I guess I need to do a php-script that syncs the databases from the powweb as I can now access my system from powweb but not vice versa.

10-8-04, 04:45 PM	#1
akusto Join Date: Aug 2002 Location: Finland Posts: 75 Reputation: 5	Can't connect to my own MySQL server Right after the load balancing started, I started to have errors on my page. I cannot access my private MySQL-database anymore. I get continuosly this error: Host 'www15.powweb.com' is not allowed to connect to this MySQL server The number 15 above has been something random between 11-18 One of these hosts still allows me to connect. This happens once in a minute or something like that... I guess it's www12.powweb.com where my site is hosted on. Just check it out yourself: http://www.ainiarecords.com/index.php?page=sale_test Can I do something about it on php.ini or is this a problem at powwebs end? __________________ Errare humanum est == Human was a mistake Last edited by akusto : 10-8-04 at 05:25 PM.

10-8-04, 05:37 PM	#2
Pig foo Join Date: Jan 2003 Location: Seattle-ish Posts: 2,597 Reputation: 106	The load balanced servers seem to be having an issue that affects the global php.ini, and staff are aware of it. I would try manually placing a copy of the global php.ini in all the affected directories, and see if that makes a difference. __________________ webhead.cc

10-8-04, 09:27 PM	#3
akusto Join Date: Aug 2002 Location: Finland Posts: 75 Reputation: 5	Tried, but did not make any difference... It seems that www12.powweb.com allows me to connect to my own MySQL-server and the rest not. I think I will mirror my own database to powwebs MySQL-server. That would be faster access for the servers anyway. I simply don't have time to play with this now. __________________ Errare humanum est == Human was a mistake

10-8-04, 10:54 PM	#4
akusto Join Date: Aug 2002 Location: Finland Posts: 75 Reputation: 5	Mirroring was a good idea. I manually copied the databases from my private system to powweb's database. And it really became faster, but now it seems that I cannot connect mysql07.powweb.com from my private system... I want to update the databases remotely. My system's giving me this error: "Can't connect to MySQL server on 'mysql07.powweb.com' (115)" - maybe because powweb is blocking the foreign ip or something like that, I guess... Are there limitations from where one can access the powweb's MySQL? __________________ Errare humanum est == Human was a mistake

10-8-04, 11:07 PM	#6
akusto Join Date: Aug 2002 Location: Finland Posts: 75 Reputation: 5	Thinking once again.. that can be problem at my end.. I need to check the mysql permissions... __________________ Errare humanum est == Human was a mistake

10-9-04, 06:33 AM	#7
akusto Join Date: Aug 2002 Location: Finland Posts: 75 Reputation: 5	Now I got it. My private system allowed only www12.powweb.com and blocked the rest. When I changed the MySQL privileges to www%.powweb.com at my own system it started accepting all the load balanced servers. I still prefer mirroring the database, since it seems to be much faster to browse. I guess I need to do a php-script that syncs the databases from the powweb as I can now access my system from powweb but not vice versa. __________________ Errare humanum est == Human was a mistake

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search