Ok, final post to explain the result. We added the mysql to an existing hosting package, which is incapable of connecting to it from that server.
So we were given a new hosting package, but were not told of this critical fact. So all going now, but took 4 working days to discover this vital piece of information. Cheers Dave T From: [email protected] [mailto:[email protected]] Sent: Wednesday, 18 November 2009 6:04 p.m. To: [email protected] Subject: RE: [phpug] Re: Mysql connection string for Orcon Hi Dave If you are getting localhost then i dont see how host is an issue. The next problem might be your usernames / privileges. I notice that you wrote the errors as Warning: mysql_connect(): Access denied for user: 'usern...@localhost' (Using password: YES) in /home/users/username/domain.co.nz/testsite/test.php on line 5 Could not connect: Access denied for user: 'usrn...@localhost' (Using password: YES) Is that spelling right? How about removing passes and see if it gets access to the server, and then see if it can progress to a database. My 5c keith localhost connects OK. But then your usernames play up. On Wed, 18 Nov 2009 12:33:05 +1300, David Turton <[email protected]> wrote: Thanks Chris. I suspect either the second one below, or the permission is not set correctly as per hostname. But hard to tell from here. I'd like to be patient and polite, but the site is scheduled to go live tonight, and currently doesn't work - which means no testing on live system yet. Potentially live to a blank screen..... Dave T From: chris burgess [mailto:[email protected]] Sent: Wednesday, 18 November 2009 9:34 a.m. To: [email protected] Subject: Re: [phpug] Re: Mysql connection string for Orcon * There's a MySQL server running on localhost, but that doesn't mean that its the machine with YOUR database on it. Your DB might be on another machine entirely. * The webserver with your files may be missing a DNS or entry /etc/hosts entry for hostingdatabases.orcon.net.nz<http://hostingdatabases.orcon.net.nz> which would cause connection failures. (Is the error message slower in that case?) * You could upload a minimal test PHP file which you know works, and then ask Orcon to fix it to demonstrate the correct settings. Just do SELECT 'that worked' FROM users LIMIT 1 ... looks like you may have done this already? * Drupal uses both mysqli and mysql connection strings, to support both PHP MySQL types. Doesn't look like that's your problem (but it can catch people out, so I'll mention it). If anyone knows how to get the top result from this search<http://www.google.com/search?q=hostingdatabases.orcon.net.nz+orcon+knowledge+base> out of Google Cache, that may be handy reading for you too. Ultimately, it's probably up to Orcon to furnish you with the correct details though. Their support staff can be frustratingly inefficient, but somewhere deep in the organisation you'll find a knowledgeable person, if you can stay calm and polite long enough to get passed up their food chain. Presumably, a help page with the correct details would save them a lot of calls (ten in your case?). The fact that it doesn't exist yet makes me wonder if they host any significant number of sites using DBs ... Best I could find is What are the webhosting settings<http://www.orcon.net.nz/support/page/what_are_the_webhosting_settings>. HTH! -- NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [email protected] ________________________________ Warning: This email contains information which is CONFIDENTIAL and may also be LEGALLY PRIVILEGED. If you are not the intended recipient you must not peruse, use, disseminate, distribute or copy this email or attachments. If you have received this in error, please notify us immediately by return email and delete this email. Thank you. ________________________________ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal ________________________________ -- NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [email protected] -- NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [email protected] ________________________________ Warning: This email contains information which is CONFIDENTIAL and may also be LEGALLY PRIVILEGED. If you are not the intended recipient you must not peruse, use, disseminate, distribute or copy this email or attachments. If you have received this in error, please notify us immediately by return email and delete this email. Thank you. ##################################################################################### This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal ##################################################################################### -- NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [email protected]
