[Gambas-user] MySQL Connect

[John G. Ruff]

Benoit,

Thanks for your help. The other packages on my system match
yours, and I installed:
  libmysql14-4.1.8-1mdk
  libmysql14-devel-4.1.8-1mdk

And the result is the same. Also installed is:
  libmysql12-4.0.20-3.1.101mdk

When I try to uninstall it, it also wants to uninstall:
  gambas-gb-db-mysql-1.0.1-1rk
  gambas-ide-1.0.1-1rk

I'm in over my head here, but is it possible that the problem is
related to Gambas (db-mysql) being dependant upon an older
version of the MySQL components and they in turn are not
compatible with the current MySQL version?

jr


Benoit Minisini wrote:
> 
> On Saturday 08 January 2005 23:37, John G. Ruff wrote:
> > When I run the Database example program, I still get the same
> > error:
> >
> >   Cannot open database: Client does not support authentication
> >                         protocol requested by server; consider
> >                         upgrading MySQL client
> >
> > I did a fresh install of Mandrake 10.1 Official (32 bit) on a
> > different hard drive. I'm using Gambas 1.0.1. I downloaded &
> > installed MySQL-Client 4.1.8a from MySQL.com.
> >
> > The server is running Mandrake 10.1 Official (32 bit) in runlevel
> > 3 (text multi-user mode) and MySQL Server 4.1.8a.
> >
> > I am able to connect to, access and update this same server from
> > my Visual Basic 6 / SP6 programs, so the credentials, etc.,
> > should be OK.
> >
> > Any ideas what is wrong? I am at a loss for what to try next. I
> > am just trying out Gambas, I really want to turn off my remaining
> > Windows stuff and move entirely to Linux. Is it possible that the
> > MySQL server is sending a request for something that Gambas does
> > not / cannot respond to? Is anyone else successfully running
> > anything similar to this?
> >
> > Thanks in advance for any help.
> >
> > jr
> >
> > -=-=-=-=-=-=-=-=-=-=-
> >   John G. Ruff
> >   Wayzata, MN USA
> > -=-=-=-=-=-=-=-=-=-=-
> >
> 
> Mmm... I have installed on my Mandrake 10.1 the following MySQL related
> packages:
> - MySQL41-4.1.5-0.1mdk
> - MySQL41-client-4.1.5-0.1mdk
> - MySQL41-common-4.1.5-0.1mdk
> - libmysql14-devel-4.1.5-0.1mdk
> - libmysql14-4.1.5-0.1mdk
> 
> The MySQL server is running as it is configured by default on Mandrake, and I
> can connect to it with the user 'root' without any password.
> 
> The Gambas mysql driver just takes the values of of the Connection object
> properties and pass them to the mysql function mysql_real_connect().
> 
> Can you compare your mysql server configuration files with the original files
> installed on the Mandrake 10.1 ? Can you do the same thing with the contents
> of the 'user' table in the system database 'mysql' ?
> 
> Regards,
> 
> --
> Benoit Minisini
> mailto:gambas at ...1...
> 
> -------------------------------------------------------
> The SF.Net email is sponsored by: Beat the post-holiday blues
> Get a FREE limited edition SourceForge.net t-shirt from ThinkGeek.
> It's fun and FREE -- well, almost....http://www.thinkgeek.com/sfshirt
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user