Posted by Robin S. on 01/10/08 18:59

On Jan 10, 1:14 pm, Anonymous <anonym...@nowhere.invalid> wrote:
> "Robin S." wrote:
>
> > I've used phpinfo() to confirm settings for mySQL on our host server,
> > and it's not returning accurate info.
>
> > phpinfo() returns a mySQL client API version of 3.23.54 (uselss for
> > me), where as a SELECT VERSION() query on the mySQL database returns
> > version 5.0.27 (exactly what we need). I think there's something wrong
> > with the mySQL library in PHP.
>
> Does your provider still use PHP4? Then this API version should be
> expected. IIRC that version was statically linked into PHP. At least in
> the windows version of PHP, I don't know about Linux/Unix versions.

Currently, the WebsiteOS program (on the website host server) lists
PHP5 as being used. PHP4 is an option, but it's not currently used (I
tried to switch it about two hours ago. Same errors, but slightly
different error messages, but no further ahead. The shopping cart
should be compatible with PHP4 anyway, but I guess that's not too
important right now).

>
> But that shouldn't be a big problem, even this stoneage API is still
> compatible with the latest MySQL. You just have to remember to use the
> old-passwords option on the server or you will get the 'Client does not
> support authentication protocol' error when connecting to the database,
> but that doesn't seem to be your problem.

Actually, the first error listed in my origianl message is generated
on a password line of a mysql_pconnect in the session.inc script. See
code:

*************************
$mysql_connect = mysql_pconnect ($this->hostName,
$this->userName,
$this->password);
$mysql_db = mysql_select_db ($this->database);
**************************
*btw - the original programmer explicidly states that a mysql_pconnect
is required, just just mysql_connect...

The first error I listed is generated on the third line down:

($this->password);

and the second error is generated on the following line:

$mysql_db = mysql_select_db ($this->database);


>
> It looks to me like a configuration problem on your hosts side.

Any thoughts spcifically? I'm sure there are a couple dozen things
that could be wrong, but if I can lead the tech support guys in the
right direction, perhaps they can solve it...

We started with one host who couldn't figure out the issue (they
basically insisted it was the shopping cart). We've just switched to a
new host, but they seem to be using a *very* similar configuration.

Both use sql****.megasqlservers.com for mysql, as well as an identical
site management software "websiteOS", and an identical host directory
structure). Just did a tracert - the old domain/host has a completely
different IP than the new host/domain (we're keeping the old host
until we can find a new one that works. We have our main domain name
pointing to the old host, and we used an outdated domain name we still
own to try out the new host).

>
> P.S.: You can connect to the MySQL server of your host from your local
> computer? That's a security nightmare! You should consider switching
> hosts in any case.

Well, Apache/PHP installed on my computer seems to be able to perform
queries on the remove SQL server, although it requires the appropriate
user/pass. This shouldn't be the case?

Sorry, I'm not an admin. This cart software should have installed and
run without any admin/programming knoweldge on my part.. I'm just
trying to diagnose the problem.

Thanks for the assistance guys. Anything further would be most
appriciated. Tech support at the new host seems to be better than the
old, but I'd like to be able to guide them to fixing my problem if I
can.

Regards,

Robin

[Back to original message]