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]

Reply via email to