mariovaldez.net

MV.net forums
It is currently 14 Jul 2016, 00:49

All times are UTC - 7 hours




Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 3 posts ] 
Author Message
PostPosted: 17 Jan 2007, 03:33 
Hi,

I connect to the mysql server using SSH. PhpMyadmin says I'm running MySQL Server version: 5.0.24

The "Test Connection" button opens a command window and connects to the server without problems. I can even start mysql from this command window and execute sql commands so all usernames and passwords seem to be working.

But when I try to connect using OCSPM1 "Connect" button I get the following error:

Error while connecting to the database (dbname @ 127.0.0.1).
SQL Error: Lost Connection to server during MySQL Query

Could this be a sql problem? Something to do with MySQL version 5 and it's stricter SQL implimentation?

If anyone has any ideas please respond... it's so nasty to be stopped at the last hurdle like this!

Thanks,
Dags.


Report this post
Top
  
Reply with quote  
PostPosted: 30 Jan 2007, 17:27 
User avatar

Joined: 06 Mar 2003, 03:21
Posts: 447
Location: Monterrey, NL, Mexico
Dags:

> I connect to the mysql server using SSH. PhpMyadmin says
> I'm running MySQL Server version: 5.0.24 The "Test Connection"
> button opens a command window and connects to the server
> without problems. I can even start mysql from this command
> window and execute sql commands so all usernames and
> passwords seem to be working. But when I try to connect using
> OCSPM1 "Connect" button I get the following error:
> Error while connecting to the database (dbname @ 127.0.0.1).
> SQL Error: Lost Connection to server during MySQL Query
> Could this be a sql problem? Something to do with MySQL version
> 5 and it's stricter SQL implimentation?


Hi. Please upgrade to the latest beta version (soon to be released as stable unchanged):

http://www.mariovaldez.net/software/osc ... _setup.exe

This new version does not use a direct MySQL connection, but uses a PHP-script SQL gateway. Just install and upgrade the server-side script.

This version does not use SSH, we are dropping the SSH support. Please note that you password is never sent in clear text in the new HTTP-based protocol. However, if you want to encrypt all the traffic between your computer and the server, you can install the SSL-support module (available from the Download page).


Regards,

Mario A. Valdez-Ramirez.


Report this post
Top
 Profile  
Reply with quote  
 Post subject: This works!
PostPosted: 09 Feb 2007, 04:57 
This worked perfectly,
Thank you.
:D


Report this post
Top
  
Reply with quote  
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 3 posts ] 

All times are UTC - 7 hours


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group