Centova Technologies Forum
Centova Cast v2 => General discussion => Topic started by: elofty on September 27, 2012, 06:56:19 am
-
Hi, I'm trying to install Centovacast on a vps with the sql running on another box. I've done this before and have a current setup working great. However now when I try it, It keeps trying to connect to localhost. For example:
Error 1045: Access denied for user 'dbstream_europe1'@'europe1.manevis.it' (using password: YES)
Using host db.streaminguy.co.uk with username dbstream_europe1
The config file just has the "db.streaminguy.co.uk" as the host and the username is just dbstream_euorpe1, I cant find anywhere in the config file that even mentions europe1.manevis.it (the hostname of the server) any idea where to check/what to change?
Cheers
Matt
-
Matt,
Is your host allowed access to from the vps to the SQL server?
-
Hey,
Its a Dedi box running a fresh build of centos 6.4
the remote sql server is allowed for the centovacast server.
the yum commands worked fine so it must be able to see the web etc. Its stumped me a bit. only differnece I can think of is the centos version as I'm sure my other installation is 5.x something.
Any ideas?
Cheers
Matt
-
Have you added a mysql host europe1.manevis.it to the username dbstream_europe1 on the db server?
-
Hi,
Yep its added to remotely access the sql db server
-
I see your using cpanel on the db server you are sure you went into remote access hosts and added europe1.manevis.it to it ?? This is a mysql issue .. Im pretty sure it has nothing to do with centovacast
-
Hey, Thank for the pointer, The issue was with the provider. although the remote ip was in the mysql allow list. The provider had a seperate firewall which needed a whitelist. Thanks for your help
Matt