No subject


Thu Oct 26 19:20:09 CEST 2017 

Nigel


> Message date : Jan 11 2005, 06:02 PM
> From : "John G. Ruff" 
> To : gambas-user at lists.sourceforge.net
> Copy to : 
> Subject : Re: [Gambas-user] MySQL Connect
> 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
> 
> 
> -------------------------------------------------------
> 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
> 

-- 

Whatever you Wanadoo:
http://www.wanadoo.co.uk/time/

This email has been checked for most known viruses - find out more at: http://www.wanadoo.co.uk/help/id/7098.htm
------=_Part_57158_21626056.1105518154657
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

<P>John,</P>
<P>I'm jumping in late on this one and may have missed something already me=
ntioned: I believe the message relates to different the gambas client for M=
ySQL using or being compiled against an older client than the 4.1 tree.&nbs=
p; 4.1 introduces a new password encryption routine etc. which is not backw=
ard compatible.</P>
<P>From you information it appears that you have the correct client stuff (=
development files etc.), but I do not know if you have had an older version=
 of MySQL on your box in the past.  Since your latest updates etc. hav=
e you rerun configure and recompiled gambas so that it done against the new=
 MySQL version.<BR><BR><BR>Nigel<BR><BR></P>
<BLOCKQUOTE style=3D"PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #ff0=
000 2px solid">> Message date : Jan 11 2005, 06:02 PM<BR>> From : "Jo=
hn G. Ruff" <JRUFF at ...791...><BR>> To : gambas-user at ...625...=
t<BR>> Copy to : <BR>> Subject : Re: [Gambas-user] MySQL Connect<BR>&=
gt; Benoit,<BR>> <BR>> Thanks for your help. The other packages on my=
 system match<BR>> yours, and I installed:<BR>> libmysql14-4.1.8-1mdk=
<BR>> libmysql14-devel-4.1.8-1mdk<BR>> <BR>> And the result is the=
 same. Also installed is:<BR>> libmysql12-4.0.20-3.1.101mdk<BR>> <BR>=
> When I try to uninstall it, it also wants to uninstall:<BR>> gambas=
-gb-db-mysql-1.0.1-1rk<BR>> gambas-ide-1.0.1-1rk<BR>> <BR>> I'm in=
 over my head here, but is it possible that the problem is<BR>> related =
to Gambas (db-mysql) being dependant upon an older<BR>> version of the M=
ySQL components and they in turn are not<BR>> compatible with the curren=
t MySQL version?<BR>> <BR>> jr<BR>> <BR>> <BR>> Benoit Minis=
ini wrote:<BR>> > <BR>> > On Saturday 08 January 2005 23:37, Jo=
hn G. Ruff wrote:<BR>> > > When I run the Database example program=
, I still get the same<BR>> > > error:<BR>> > ><BR>> &=
gt; > Cannot open database: Client does not support authentication<BR>&g=
t; > > protocol requested by server; consider<BR>> > > upgra=
ding MySQL client<BR>> > ><BR>> > > I did a fresh install=
 of Mandrake 10.1 Official (32 bit) on a<BR>> > > different hard d=
rive. I'm using Gambas 1.0.1. I downloaded &<BR>> > > installe=
d MySQL-Client 4.1.8a from MySQL.com.<BR>> > ><BR>> > > T=
he server is running Mandrake 10.1 Official (32 bit) in runlevel<BR>> &g=
t; > 3 (text multi-user mode) and MySQL Server 4.1.8a.<BR>> > >=
<BR>> > > I am able to connect to, access and update this same ser=
ver from<BR>> > > my Visual Basic 6 / SP6 programs, so the credent=
ials, etc.,<BR>> > > should be OK.<BR>> > ><BR>> > =
> Any ideas what is wrong? I am at a loss for what to try next. I<BR>&gt=
; > > am just trying out Gambas, I really want to turn off my remaini=
ng<BR>> > > Windows stuff and move entirely to Linux. Is it possib=
le that the<BR>> > > MySQL server is sending a request for somethi=
ng that Gambas does<BR>> > > not / cannot respond to? Is anyone el=
se successfully running<BR>> > > anything similar to this?<BR>>=
 > ><BR>> > > Thanks in advance for any help.<BR>> > &=
gt;<BR>> > > jr<BR>> > ><BR>> > > -=3D-=3D-=3D-=
=3D-=3D-=3D-=3D-=3D-=3D-=3D-<BR>> > > John G. Ruff<BR>> > &g=
t; Wayzata, MN USA<BR>> > > -=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=
=3D-<BR>> > ><BR>> > <BR>> > Mmm... I have installed o=
n my Mandrake 10.1 the following MySQL related<BR>> > packages:<BR>&g=
t; > - MySQL41-4.1.5-0.1mdk<BR>> > - MySQL41-client-4.1.5-0.1mdk<B=
R>> > - MySQL41-common-4.1.5-0.1mdk<BR>> > - libmysql14-devel-4=
.1.5-0.1mdk<BR>> > - libmysql14-4.1.5-0.1mdk<BR>> > <BR>> &g=
t; The MySQL server is running as it is configured by default on Mandrake, =
and I<BR>> > can connect to it with the user 'root' without any passw=
ord.<BR>> > <BR>> > The Gambas mysql driver just takes the valu=
es of of the Connection object<BR>> > properties and pass them to the=
 mysql function mysql_real_connect().<BR>> > <BR>> > Can you co=
mpare your mysql server configuration files with the original files<BR>>=
 > installed on the Mandrake 10.1 ? Can you do the same thing with the c=
ontents<BR>> > of the 'user' table in the system database 'mysql' ?<B=
R>> > <BR>> > Regards,<BR>> > <BR>> > --<BR>> &g=
t; Benoit Minisini<BR>> > mailto:gambas at ...1...<BR>> > <BR>>=
 > -------------------------------------------------------<BR>> > =
The SF.Net email is sponsored by: Beat the post-holiday blues<BR>> > =
Get a FREE limited edition SourceForge.net t-shirt from ThinkGeek.<BR>> =
> It's fun and FREE -- well, almost....http://www.thinkgeek.com/sfshirt<=
BR>> > _______________________________________________<BR>> > G=
ambas-user mailing list<BR>> > Gambas-user at lists.sourceforge.net<BR>&=
gt; > https://lists.sourceforge.net/lists/listinfo/gambas-user<BR>> <=
BR>> <BR>> -------------------------------------------------------<BR=
>> The SF.Net email is sponsored by: Beat the post-holiday blues<BR>>=
 Get a FREE limited edition SourceForge.net t-shirt from ThinkGeek.<BR>>=
 It's fun and FREE -- well, almost....http://www.thinkgeek.com/sfshirt<BR>&=
gt; _______________________________________________<BR>> Gambas-user mai=
ling list<BR>> Gambas-user at lists.sourceforge.net<BR>> https://lists.s=
ourceforge.net/lists/listinfo/gambas-user<BR>> </BLOCKQUOTE><BR><BR><hr =
size=3D"1">Whatever you <a href=3D"http://www.wanadoo.co.uk/time/" target=
=3D"_blank">Wanadoo</a><br><br>This email has been checked for most known v=
iruses - find out more <a href=3D"http://www.wanadoo.co.uk/help/id/7098.htm=
" target=3D"_blank">here</a>=

------=_Part_57158_21626056.1105518154657--

More information about the User mailing list