Re: mysql.pm on Apache/mod_perl/perl win98
There is a DBD::mysql available from ActiveState. You can install it with ppm. ppm install DBD-mysql Thanks, Tim Tompkins -- Programmer / IS Technician http://www.arttoday.com/ - Original Message - From: dave_dunstan [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, January 10, 2000 10:27 AM Subject: mysql.pm on Apache/mod_perl/perl win98 Hi - I'm another *lost* soul trying to get their Apache 1.3.9, latest mysql, mod_perl working on Win98. I got a binary of Apache+Perl+mod_perl and it seems to work ok - my mod_perl is working ok, my Authz module is -sort of- working, but I'm getting hits in my apache error log from mysql.pm, a la: [Sun Jan 09 22:13:40 2000] [error] install_driver(mysql) failed: Can't locate loadable object for module DBD::mysql in @INC (@INC contains: C:/Perl/5.00503/lib/MSWin32-x86 C:/Perl/5.00503/lib C:/Perl/site/5.00503/lib/MSWin32-x86 C:/Perl/site/5.00503/lib . /apache/ /apache/lib/perl) at (eval 19) line 3 Perhaps a module that DBD::mysql requires hasn't been fully installed at C:/Perl/site/5.00503/lib/Apache/DBILogger.pm line 53 Perhaps! I'm also getting this: Had to create DBD::mysql::dr::imp_data_size unexpectedly at C:/Perl/site/5.00503/lib/DBI.pm line 657. Had to create DBD::mysql::db::imp_data_size unexpectedly at C:/Perl/site/5.00503/lib/DBI.pm line 657. [Sun Jan 09 22:13:44 2000] [error] Undefined subroutine DBD::mysql::db::_login called at C:/Perl/site/5.00503/lib/DBD/mysql.pm line 130. This kind of figures ... I'm certain I'm missing a supporting file for mysql.pm but after eyeballing the filesystem on my Win98 laptop and on my (working) linux installation, I'm out of gas. Help! Do I really have to compile my own mysql.pm to get this to work? I don't have VC++! I guess I could get it ... Does anyone know any secret that can get me around this? Dave Dunstan Mission Control Consulting LLC
RE: mysql.pm on Apache/mod_perl/perl win98
Thanks for all the info. I'm multitasking a little too much right now so I haven't been able to give any feedback on -your- feedback yet! dd -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Tim Tompkins Sent: Monday, January 10, 2000 10:58 AM To: dave_dunstan; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: mysql.pm on Apache/mod_perl/perl win98 There is a DBD::mysql available from ActiveState. You can install it with ppm. ppm install DBD-mysql Thanks, Tim Tompkins -- Programmer / IS Technician http://www.arttoday.com/ - Original Message - From: dave_dunstan [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, January 10, 2000 10:27 AM Subject: mysql.pm on Apache/mod_perl/perl win98 Hi - I'm another *lost* soul trying to get their Apache 1.3.9, latest mysql, mod_perl working on Win98. I got a binary of Apache+Perl+mod_perl and it seems to work ok - my mod_perl is working ok, my Authz module is -sort of- working, but I'm getting hits in my apache error log from mysql.pm, a la: [Sun Jan 09 22:13:40 2000] [error] install_driver(mysql) failed: Can't locate loadable object for module DBD::mysql in @INC (@INC contains: C:/Perl/5.00503/lib/MSWin32-x86 C:/Perl/5.00503/lib C:/Perl/site/5.00503/lib/MSWin32-x86 C:/Perl/site/5.00503/lib . /apache/ /apache/lib/perl) at (eval 19) line 3 Perhaps a module that DBD::mysql requires hasn't been fully installed at C:/Perl/site/5.00503/lib/Apache/DBILogger.pm line 53 Perhaps! I'm also getting this: Had to create DBD::mysql::dr::imp_data_size unexpectedly at C:/Perl/site/5.00503/lib/DBI.pm line 657. Had to create DBD::mysql::db::imp_data_size unexpectedly at C:/Perl/site/5.00503/lib/DBI.pm line 657. [Sun Jan 09 22:13:44 2000] [error] Undefined subroutine DBD::mysql::db::_login called at C:/Perl/site/5.00503/lib/DBD/mysql.pm line 130. This kind of figures ... I'm certain I'm missing a supporting file for mysql.pm but after eyeballing the filesystem on my Win98 laptop and on my (working) linux installation, I'm out of gas. Help! Do I really have to compile my own mysql.pm to get this to work? I don't have VC++! I guess I could get it ... Does anyone know any secret that can get me around this? Dave Dunstan Mission Control Consulting LLC
Re: mysql.pm on Apache/mod_perl/perl win98
dave_dunstan wrote: Do I really have to compile my own mysql.pm to get this to work? I don't have VC++! I guess I could get it ... The DBD::mysql driver (like most other database drivers) consists of two parts: A Perl part and a C part. If you aren't using ActivePerl (which isn't working with mod_perl, AFAIK), you either need a precompiled binary of DBD::mysql or you must compile your own - and hence you need a C compiler. (The DBD::mysql docs tell you what to do.) The C compiler must be the same that was used for compiling Perl. VC++ is not a must: You can compile Perl with egcs. The WIN32-README of the Perl source distribution contains more details. A precompiled binary of Perl 5.00502, including DBD::mysql, is available at www.mysql.com. Bye, Jochen -- Jochen Wiedmann [EMAIL PROTECTED] Life has brown and green eyes. :-) +49 711 7168586
mysql.pm on Apache/mod_perl/perl win98
Hi - I'm another *lost* soul trying to get their Apache 1.3.9, latest mysql, mod_perl working on Win98. I got a binary of Apache+Perl+mod_perl and it seems to work ok - my mod_perl is working ok, my Authz module is -sort of- working, but I'm getting hits in my apache error log from mysql.pm, a la: [Sun Jan 09 22:13:40 2000] [error] install_driver(mysql) failed: Can't locate loadable object for module DBD::mysql in @INC (@INC contains: C:/Perl/5.00503/lib/MSWin32-x86 C:/Perl/5.00503/lib C:/Perl/site/5.00503/lib/MSWin32-x86 C:/Perl/site/5.00503/lib . /apache/ /apache/lib/perl) at (eval 19) line 3 Perhaps a module that DBD::mysql requires hasn't been fully installed at C:/Perl/site/5.00503/lib/Apache/DBILogger.pm line 53 Perhaps! I'm also getting this: Had to create DBD::mysql::dr::imp_data_size unexpectedly at C:/Perl/site/5.00503/lib/DBI.pm line 657. Had to create DBD::mysql::db::imp_data_size unexpectedly at C:/Perl/site/5.00503/lib/DBI.pm line 657. [Sun Jan 09 22:13:44 2000] [error] Undefined subroutine DBD::mysql::db::_login called at C:/Perl/site/5.00503/lib/DBD/mysql.pm line 130. This kind of figures ... I'm certain I'm missing a supporting file for mysql.pm but after eyeballing the filesystem on my Win98 laptop and on my (working) linux installation, I'm out of gas. Help! Do I really have to compile my own mysql.pm to get this to work? I don't have VC++! I guess I could get it ... Does anyone know any secret that can get me around this? Dave Dunstan Mission Control Consulting LLC
Re: mysql.pm on Apache/mod_perl/perl win98
Hi Dave, I only do *nix, but I think that you should not need mysql.pm if you are using DBI/DBD. Jochen is quite helpful on the MySQL modules list. subscription info availble at www.mysql.com. Good Luck, Ed
Re: mysql.pm on Apache/mod_perl/perl win98
On Mon, 10 Jan 2000, Tim Tompkins wrote: There is a DBD::mysql available from ActiveState. You can install it with ppm. ppm install DBD-mysql Hi, This would normally work, but the perl binary being used most probably isn't ActiveState's, because as of yet mod_perl doesn't work with ActiveState's perl. So there would most likely be a binary incompatibitly using this perl binary with ActiveState's DBD::mysql. I'm currently testing out an apache/mod_perl/perl Win32 binary that will have DBD::mysql and DBD::msql support, as well as mod_ssl. As a new mod_perl version is in the works, I'll probably wait until that is released. best regards, Randy Kobes
Re: mysql.pm on Apache/mod_perl/perl win98
[cc list trimmed; this is more a mod_perl issue than a mysql one.] Thanks a bunch for your efforts here. I understand that earlier such bundles were built with VC6, eh? Will you have the opportunity/ability/tuits to distribute one built with Cygwin, so that the resultant installation can freely install new/updated modules from CPAN, including those that need a C compiler? I wouldn't suggest to bundle Cygwin, but to work with its standard install location, at any rate. The reason I ask is that I'd like to have a distribution available that includes HTML::Mason, and which is open for folks to add the precise modules that they need. Combined with SSH and CVS, this becomes a pretty decent development environment even for a web developer with only a Windows box. Perhaps it's more reasonable to request that you add HTML::Mason into the existing bundle, but that will have its own share of difficulties, considering the other unspecified modules that people would still be without. A cygwin-based distribution perhaps could simply ship with Perl's base install - let the user install their packages through CPAN. I've looked at getting apache/perl/mod_perl to build wtih cygwin, but I lacked the knowledge to understand the build hints for Perl, speak nothing of the rest. By the way, HTML::Mason may still have a problem here or there on Windows, which we folks on the Mason list will be glad to help get ironed out, I believe. At least, I'd be willing to help. Randy On Mon, Jan 10, 2000 at 04:10:08PM -0600, Randy Kobes wrote: On Mon, 10 Jan 2000, Tim Tompkins wrote: There is a DBD::mysql available from ActiveState. You can install it with ppm. ppm install DBD-mysql Hi, This would normally work, but the perl binary being used most probably isn't ActiveState's, because as of yet mod_perl doesn't work with ActiveState's perl. So there would most likely be a binary incompatibitly using this perl binary with ActiveState's DBD::mysql. I'm currently testing out an apache/mod_perl/perl Win32 binary that will have DBD::mysql and DBD::msql support, as well as mod_ssl. As a new mod_perl version is in the works, I'll probably wait until that is released. best regards, Randy Kobes