The Forum has been Updated
The code has been upgraded to the latest .NET core version. Please check instructions in the Community Announcements about migrating your account.
Hi Guys,
This isn't a Snitz problem but one to do with installing another software - OpenX
A bit of history... I've been using OpenX (ad serving software) for about 2 years with no problems but recently it was hacked and as a result I decided to upgrade it with the latest version and start off with a new MySql database as the connection to the existing one also failed.
It appears that the connection problem might not have been a problem relating from the hack but possibly server side as when trying to run the install file for OpenX I now get the following error:
I've tried several ways and using 127.0.0.1 instead of localhost, plus another host name I thought should work, but the same error results. The username, password, etc are correct though as I can access the MySql database through phpMyAdmin remotely.
Is this a DNS issue?
I have other MySql databases with this host and do not have any problems, it just appears to be the previous OpenX database and this new one. Coincidently the connection problems arose with the original database when I deleted the user and password and created a new one (the cofig file was changed accordingly) so I'm thinking that it might be something server side but my hosts are not being too helpful (once again)
Thanks
This isn't a Snitz problem but one to do with installing another software - OpenX
A bit of history... I've been using OpenX (ad serving software) for about 2 years with no problems but recently it was hacked and as a result I decided to upgrade it with the latest version and start off with a new MySql database as the connection to the existing one also failed.
It appears that the connection problem might not have been a problem relating from the hack but possibly server side as when trying to run the install file for OpenX I now get the following error:
MDB2 Error: connect failed
connect: [Error message: Access denied for user 'username'@'localhost' (using password: YES)] [Native code: 1045] [Native message: Access denied for user 'username'@'localhost' (using password: YES)]
Installation failed to create the database dbname
I've tried several ways and using 127.0.0.1 instead of localhost, plus another host name I thought should work, but the same error results. The username, password, etc are correct though as I can access the MySql database through phpMyAdmin remotely.
Is this a DNS issue?
I have other MySql databases with this host and do not have any problems, it just appears to be the previous OpenX database and this new one. Coincidently the connection problems arose with the original database when I deleted the user and password and created a new one (the cofig file was changed accordingly) so I'm thinking that it might be something server side but my hosts are not being too helpful (once again)
Thanks
Posted
the error would indicate to me that either your username/password is wrong or you don't have permission to do what you are trying, it is not a connection/dns issue
Posted
Thanks for the exceedingly fast reply Huw, I wish my hosts were as quick lol :)
I've got another call with them today so will see what comes of that
I've got another call with them today so will see what comes of that
Posted
In a round about way Huw, thanks, you've helped sort the problem 
I took my head out of the sand a minute and delved deeper into my hosting control panel and found that external access to the database was disabled by default. Enabling it has now resulted in being able to run the installation script
Regards,
Dave
I took my head out of the sand a minute and delved deeper into my hosting control panel and found that external access to the database was disabled by default. Enabling it has now resulted in being able to run the installation script
Regards,
Dave
Posted
glad I could help