Click here to get back home

pure-perl access to mySQL
 Home | NewsGroups | Search | About
Login Password
Register Now!
 comp.lang.perl.modules    Post an article   get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content
Subject Author Date
pure-perl access to mySQL klicker-mail 06-14-2005
Get Chitika Premium
Posted by klicker-mail on June 14, 2005, 8:38 am
Please log in for more thread options

Hi!

Since mySQL 3.2x there have been a lot of changes. But one was the most
significant to me: the new login process. This thing made Net::MySQL
unusable for mySQL 4.x.
Before I used Net::MySQL I tried DBI + DBD::mysql, but that was much
slower. So I appreciate the pure-perl-solution. I tried to adjust the
last version of Net::MySQL to work with the new login process, but the
new password algorithm is not documented anywhere and the source code
of mySQL does not push me further.

So, does anyone know another module for a pure-perl access to mySQL or
is there someone who already modified the old module?

Thanks for every hint!

C u
Mario Fischer



Posted by brian jackson on June 15, 2005, 10:25 am
Please log in for more thread options

klicker-mail@gmx.net wrote:

> Hi!
>
> Since mySQL 3.2x there have been a lot of changes. But one was the most
> significant to me: the new login process. This thing made Net::MySQL
> unusable for mySQL 4.x.
> Before I used Net::MySQL I tried DBI + DBD::mysql, but that was much
> slower. So I appreciate the pure-perl-solution. I tried to adjust the
> last version of Net::MySQL to work with the new login process, but the
> new password algorithm is not documented anywhere and the source code
> of mySQL does not push me further.
>
> So, does anyone know another module for a pure-perl access to mySQL or
> is there someone who already modified the old module?

Hi Mario-

While I don't have an answer to your direct question, you might be able to
'trick' the perl module to work with the new mysql version.

You can run the following from a mysql prompt to convert the passwds back to
the old style:

update user set password = old_password([put your passwd here]) where user
='[username]';

Give that a try and see if the perl mod works then.

good luck,
brian


Posted by klicker-mail on June 18, 2005, 9:34 am
Please log in for more thread options


Hi Brian,

I know, this 'trick' works. But my scripts + the module are often used
on shared servers, so the passwords cannot be changed.

Does no one know another solution?

C u
Mario



Posted by Sherm Pendley on June 18, 2005, 1:31 pm
Please log in for more thread options


klicker-mail@gmx.net writes:

> I know, this 'trick' works. But my scripts + the module are often used
> on shared servers, so the passwords cannot be changed.
>
> Does no one know another solution?

What trick? What solution?

Please quote enough of the message you're replying to to provide some
context.

sherm--


Posted by klicker-mail on June 21, 2005, 5:29 am
Please log in for more thread options


> [...] you might be able to
> 'trick' the perl module to work with the new mysql version.

> You can run the following from a mysql prompt to convert the passwds back to
> the old style:

> update user set password = old_password([put your passwd here]) where > user
> ='[username]';

This is the 'trick' I was talking about. And I'm still looking for a
pure-perl solution like a simple module to communicate with mySQL.

C u
Mario Fischer



Similar ThreadsPosted
Perl under MS IIS with access to MySQL June 19, 2005, 11:24 pm
[RESOLVED] DBD::mysql unresolved symbol _intel_fast_memcpy & mysql-standard-5.0.22-linux-i686-icc-glibc23 August 29, 2006, 6:33 pm
MySQL 5.0 and Perl DBD-MySQL December 3, 2005, 1:10 am
Embedded mysql with DBD::mysql July 30, 2008, 10:15 am
DBD:mysql doesn't read mysql option file /etc/my.cnf file January 27, 2005, 11:19 pm
new module Logfile::Access October 23, 2004, 8:30 pm
Access a c++ module from Perl October 24, 2005, 6:21 pm
Microsoft Access & Win32::Ole October 28, 2005, 4:03 pm
Access DOM using JavaScript::SpiderMonkey January 16, 2006, 12:37 pm
compiling/add modules when no root access March 22, 2006, 4:21 pm

Our other projects:

Art Dolls, Fairies and Mermaids - Sunnyfaces.net

Roy's Linux, Programming and Search Engines messages

1-Script XML SitemapXML Sitemap