RE: Mysql Perl DBI DBD Version Compatability for MAC OS 10.6
MySQL Server can be 32 or 64 bit and it shouldn't make a difference to PERL. However, if you can run 64 bit, you should. PERL and it's modules all need to be the same architecture. It doesn't matter if they're 32 bit or 64 bit, as long as it's consistent with itself. I see no reason why those versions should have a problem interacting; what are you trying, and what is the error you get? Regards Gavin Towey -Original Message- From: Hagen [mailto:finha...@comcast.net] Sent: Monday, October 05, 2009 11:58 AM To: mysql@lists.mysql.com Cc: finha...@comcast.net Subject: Mysql Perl DBI DBD Version Compatability for MAC OS 10.6 After installing Apple's MAC Snow Leopard OS 10.6 I haven't been able to get my DBD:mysql module to work. I am kind of beyond trying to fix that issue directly so I am requesting assistance defining a compatible version set which is known to work. Between various releases and 32/64 bit options I have to confess there are too many choices and not enough information on how to choose for me to trust my own judgment anymore. Currently, I am running: 1. mysql Server Version 5.4.1-beta MySQL Community Server 2. perl version 5.8.9 built for Darwin 2level 3. perl DBI version 1.609 4. perl DBD:mysql 4.012 I am not positive which of the above are 32 or 64 bit but help discerning which 32/64 versions are required would also be appreciated. I am happy ;-( to uninstall and reinstall any of the above to get to a working configuration. Thanks in advance. Hagen Finley Boulder, CO -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=gto...@ffn.com The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message.
Re: Mysql Perl DBI DBD Version Compatability for MAC OS 10.6
Here is the error I am receiving ( I posted this issue in the recent past): dyld: lazy symbol binding failed: Symbol not found: _mysql_init Referenced from: /Library/Perl/5.10.0/darwin-thread-multi-2level/auto/DBD/mysql/mysql.bundle Expected in: flat namespace dyld: Symbol not found: _mysql_init Referenced from: /Library/Perl/5.10.0/darwin-thread-multi-2level/auto/DBD/mysql/mysql.bundle Expected in: flat namespace Trace/BPT trap Could you send me the versions of Perl, DBD DBI you are using? Hagen On 10/5/09 1:16 PM, Gavin Towey gto...@ffn.com wrote: MySQL Server can be 32 or 64 bit and it shouldn't make a difference to PERL. However, if you can run 64 bit, you should. PERL and it's modules all need to be the same architecture. It doesn't matter if they're 32 bit or 64 bit, as long as it's consistent with itself. I see no reason why those versions should have a problem interacting; what are you trying, and what is the error you get? Regards Gavin Towey -Original Message- From: Hagen [mailto:finha...@comcast.net] Sent: Monday, October 05, 2009 11:58 AM To: mysql@lists.mysql.com Cc: finha...@comcast.net Subject: Mysql Perl DBI DBD Version Compatability for MAC OS 10.6 After installing Apple's MAC Snow Leopard OS 10.6 I haven't been able to get my DBD:mysql module to work. I am kind of beyond trying to fix that issue directly so I am requesting assistance defining a compatible version set which is known to work. Between various releases and 32/64 bit options I have to confess there are too many choices and not enough information on how to choose for me to trust my own judgment anymore. Currently, I am running: 1. mysql Server Version 5.4.1-beta MySQL Community Server 2. perl version 5.8.9 built for Darwin 2level 3. perl DBI version 1.609 4. perl DBD:mysql 4.012 I am not positive which of the above are 32 or 64 bit but help discerning which 32/64 versions are required would also be appreciated. I am happy ;-( to uninstall and reinstall any of the above to get to a working configuration. Thanks in advance. Hagen Finley Boulder, CO -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=gto...@ffn.com The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Mysql Perl DBI DBD Version Compatability for MAC OS 10.6
I'm using: DBD::mysql 3.007 DBI 1.52 Perl 5.8.8 That output looks like missing shared library dependencies to me, but maybe someone else has a better idea. Try: Ldconfig -p | grep mysql And see if you see something like: libmysqlclient.so (libc6,x86-64) = /usr/lib64/libmysqlclient.so in the output. If not you may have to find it and make sure ldconfig knows about it. You should also be able to use ldd to check shared lib dependencies. Regards, Gavin Towey -Original Message- From: Hagen Finley [mailto:finha...@comcast.net] Sent: Monday, October 05, 2009 1:30 PM To: Gavin Towey Cc: mysql@lists.mysql.com Subject: Re: Mysql Perl DBI DBD Version Compatability for MAC OS 10.6 Here is the error I am receiving ( I posted this issue in the recent past): dyld: lazy symbol binding failed: Symbol not found: _mysql_init Referenced from: /Library/Perl/5.10.0/darwin-thread-multi-2level/auto/DBD/mysql/mysql.bundle Expected in: flat namespace dyld: Symbol not found: _mysql_init Referenced from: /Library/Perl/5.10.0/darwin-thread-multi-2level/auto/DBD/mysql/mysql.bundle Expected in: flat namespace Trace/BPT trap Could you send me the versions of Perl, DBD DBI you are using? Hagen On 10/5/09 1:16 PM, Gavin Towey gto...@ffn.com wrote: MySQL Server can be 32 or 64 bit and it shouldn't make a difference to PERL. However, if you can run 64 bit, you should. PERL and it's modules all need to be the same architecture. It doesn't matter if they're 32 bit or 64 bit, as long as it's consistent with itself. I see no reason why those versions should have a problem interacting; what are you trying, and what is the error you get? Regards Gavin Towey -Original Message- From: Hagen [mailto:finha...@comcast.net] Sent: Monday, October 05, 2009 11:58 AM To: mysql@lists.mysql.com Cc: finha...@comcast.net Subject: Mysql Perl DBI DBD Version Compatability for MAC OS 10.6 After installing Apple's MAC Snow Leopard OS 10.6 I haven't been able to get my DBD:mysql module to work. I am kind of beyond trying to fix that issue directly so I am requesting assistance defining a compatible version set which is known to work. Between various releases and 32/64 bit options I have to confess there are too many choices and not enough information on how to choose for me to trust my own judgment anymore. Currently, I am running: 1. mysql Server Version 5.4.1-beta MySQL Community Server 2. perl version 5.8.9 built for Darwin 2level 3. perl DBI version 1.609 4. perl DBD:mysql 4.012 I am not positive which of the above are 32 or 64 bit but help discerning which 32/64 versions are required would also be appreciated. I am happy ;-( to uninstall and reinstall any of the above to get to a working configuration. Thanks in advance. Hagen Finley Boulder, CO -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=gto...@ffn.com The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MySQL, perl, last_insert_id() question
Hi,
On Jan 28, 2008 3:29 PM, Dean Karres [EMAIL PROTECTED] wrote:
Hi,
I know that someone is going to say, go ask the perl module guys and
I will but they are likely to say, go ask the MySQL guys. I'll be
asking in both groups.
I am installing a script on a brand new RedHat, Fedora Core 7 (x86_64)
box that is running MySQL 5.0.45 (rpm install). I also have a mix
of other rpm MySQL installs on older Redhat boxes that are also a
mix of 32 and 64 bit machines.
The script works fine on the older installs. For example another 64
bit machine has a MySQL rpm rev of 5.0.27
I have a valid DB handle and after an insert I try to get the ID of
that inserted row, a la:
my $id = $DBH-last_insert_id();
This has been working everywhere until I tried installing the exact
same script on this newest machine. When the script runs now I get:
DBI last_insert_id: invalid number of arguments: got handle + 0, expected
handle + between 4 and 5
Usage: $h-last_insert_id($catalog, $schema, $table_name,
$field_name [, \%attr ]) at /usr/local/bin/myScript line 454.
Ok, I know the DBI Docs say that some versions of the drivers may
demand an argument list for last_insert_id() but since I have not seen
this behavior in the earlier versions is this new or is there a
problem?
If you don't need your script to work on other databases, you should
use $dbh-{mysql_insert_id} instead. This accesses the API function
of the same name, instead of going through DBD's wrapper. It doesn't
have to send another query to the server.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL, perl, last_insert_id() question
Do you have the latest version of DBI and DBD::mysql installed? First try: $ cpan cpan install DBI cpan install DBD::mysql You can also do: my $sth = $dbh-prepare(select last_insert_id()); $sth-execute(); my ($last_insert_id) = $sth-fetchrow_array(); Octavian - Original Message - From: Dean Karres [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Monday, January 28, 2008 10:29 PM Subject: MySQL, perl, last_insert_id() question Hi, I know that someone is going to say, go ask the perl module guys and I will but they are likely to say, go ask the MySQL guys. I'll be asking in both groups. I am installing a script on a brand new RedHat, Fedora Core 7 (x86_64) box that is running MySQL 5.0.45 (rpm install). I also have a mix of other rpm MySQL installs on older Redhat boxes that are also a mix of 32 and 64 bit machines. The script works fine on the older installs. For example another 64 bit machine has a MySQL rpm rev of 5.0.27 I have a valid DB handle and after an insert I try to get the ID of that inserted row, a la: my $id = $DBH-last_insert_id(); This has been working everywhere until I tried installing the exact same script on this newest machine. When the script runs now I get: DBI last_insert_id: invalid number of arguments: got handle + 0, expected handle + between 4 and 5 Usage: $h-last_insert_id($catalog, $schema, $table_name, $field_name [, \%attr ]) at /usr/local/bin/myScript line 454. Ok, I know the DBI Docs say that some versions of the drivers may demand an argument list for last_insert_id() but since I have not seen this behavior in the earlier versions is this new or is there a problem? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL Perl
Hi! I am totally lost here and I know this is a no brinier. I do not know what I am doing wrong: I can access from the command line by mysql -u gjw -p then use club and I can do anything I want. I am trying to access by Perl: # line 6 following my $dbh=DBI-connect( 'DBI:mysql:gjw:club', 'gjw', 'password' ) or die $DBI::errstr\n; I get the following error: DBI connect'gjw:club','gjw'... failed: Unknown MySQL server Host 'club' 11001 at line 6; How do I find out my server HOST name is? What else is wrong? I have done this many times working with Oracle and never had this problem! Thanks, Jerry -Original Message- From: Gerald Preston [mailto:[EMAIL PROTECTED] Sent: Friday, January 14, 2005 12:56 AM To: mysql@lists.mysql.com Subject: MySQL Perl I am trying to get Perl to talk to MySQL that I have setup. According to WinMySQLAdmin1.4 Local Host Name = GJW Local User name = Jerry Databases: GJW Club bar mysql test I am using the following code: #!/perl use warnings; use strict; use DBI; my $dbh=DBI-connect( 'DBI:mysql:GJW:club:bar', 'gjw', 'password' ) or die Cannot connect - gjw!!br$DBI::errstr; What am I missing? Thanks, Jerry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL Perl
At 13:28 -0800 1/22/05, Gerald Preston wrote: Hi! I am totally lost here and I know this is a no brinier. I do not know what I am doing wrong: I can access from the command line by mysql -u gjw -p then use club and I can do anything I want. I am trying to access by Perl: # line 6 following my $dbh=DBI-connect( 'DBI:mysql:gjw:club', 'gjw', 'password' ) or die $DBI::errstr\n; For MySQL, the format for the DSN is: DBI:mysql:db_name:host_name Looks like you have a username (gjw) for db_name, and a database name (club) for host_name? Perhaps you want: DBI:mysql:club:localhost I get the following error: DBI connect'gjw:club','gjw'... failed: Unknown MySQL server Host 'club' 11001 at line 6; How do I find out my server HOST name is? What else is wrong? I have done this many times working with Oracle and never had this problem! Thanks, Jerry -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Perl
Hi Gerald
Looks like you need a username Jerry not gjw, here is the format I use
to connect. Mike
$dsn = DBI:mysql:host=$host_name;database=$db_name
return (DBI-connect ($dsn, $username,$password,
{PrintError = 0, RaiseError = 1}));
- Original Message -
From: Gerald Preston [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: January 14, 2005 3:55 AM
Subject: MySQL Perl
I am trying to get Perl to talk to MySQL that I have setup. According to
WinMySQLAdmin1.4
Local Host Name = GJW
Local User name = Jerry
Databases:
GJW
Club
bar
mysql
test
I am using the following code:
#!/perl
use warnings;
use strict;
use DBI;
my $dbh=DBI-connect( 'DBI:mysql:GJW:club:bar', 'gjw', 'password' ) or
die
Cannot connect - gjw!!br$DBI::errstr;
What am I missing?
Thanks,
Jerry
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.6.10 - Release Date: 2005-01-10
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.6.10 - Release Date: 2005-01-10
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Perl
Gerald, Your connect string needs to be DBI:mysql:dbname:hostvar. PB - Gerald Preston wrote: I am trying to get Perl to talk to MySQL that I have setup. According to WinMySQLAdmin1.4 Local Host Name = GJW Local User name = Jerry Databases: GJW Club bar mysql test I am using the following code: #!/perl use warnings; use strict; use DBI; my $dbh=DBI-connect( 'DBI:mysql:GJW:club:bar', 'gjw', 'password' ) or die Cannot connect - gjw!!br$DBI::errstr; What am I missing? Thanks, Jerry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL, Perl 5.8 vs Perl 5.6
Were you able to install the module DBD::mysql with perl 5.8??? Have you used ppm? I was fighting a lot to install the DBD::mysql with perl 5.8 but it told me that a PPD file for this package could not be found. I found another module named DBD::mysqlPP for pure perl and it works in the same way. You just need to modify the name DBD::mysql with DBD::mysqlPP in your Perl programs. I've read in the POD documentation that some features are missing from this module, comparing it with DBD::mysql. Teddy, Teddy's Center: http://teddy.fcc.ro/ Email: [EMAIL PROTECTED] - Original Message - From: Robert W. Kramer III [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, November 17, 2002 1:03 AM Subject: MySQL, Perl 5.8 vs Perl 5.6 I just downloaded and installed MySQL 3.23.53-win. The installation required DBI and DBD-mysql which I installed using PPM. I'd like to test mysql, but everything I run is looking for perl56.dll and fails to load. DBI and DBD-mysql appear to be compiled/linked using Perl 5.6. All of my efforts are intended to be used with Apache 2.0.43 with PHP4, Perl 5.8, mod_perl-2, Apache::ASP and, for Win32, these all seem to install best with Perl 5.8 So far I've managed not to have to compile anything but mysql looks like it's going to be different. Can anyone tell me how to eliminate the need for perl56.dll and have mysql, dbi and dbd-mysql all use Perl 5.8? I'm seeing errors like these when I try to run mysql test files (I also get a popup dialog box in Win32 that indicates perl56.dll can't be found): C:\MySQL\benchperl run-all-tests --log --comment 2x Pentium II 400mz, 256M, un der vmware Can't load 'C:/Perl/site/lib/auto/DBI/DBI.dll' for module DBI: load_file:The spe cified module could not be found at C:/Perl/lib/DynaLoader.pm line 229. at C:/Perl/site/lib/DBI.pm line 236 BEGIN failed--compilation aborted at C:/Perl/site/lib/DBI.pm line 236. Compilation failed in require at run-all-tests line 36. BEGIN failed--compilation aborted at run-all-tests line 36. C:\MySQL\benchdel limits\mysql-org.cfg Could Not Find C:\MySQL\bench\limits\mysql-org.cfg C:\MySQL\benchmove limits\mysql.cfg limits\mysql-org.cfg C:\MySQL\benchperl crash-me --force Can't load 'C:/Perl/site/lib/auto/DBI/DBI.dll' for module DBI: load_file:The spe cified module could not be found at C:/Perl/lib/DynaLoader.pm line 229. at C:/Perl/site/lib/DBI.pm line 236 BEGIN failed--compilation aborted at C:/Perl/site/lib/DBI.pm line 236. Compilation failed in require at crash-me line 43. BEGIN failed--compilation aborted at crash-me line 43. Bob Kramer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySql/Perl installation problem
Hi, It doesn't sound to me that you've installed these packages (if they are packages) for the correct version of perl; Possibly they've been dumped in the OS default? (/usr/lib/perl5/5.00503) etc.? I suggest fetching the latest source from CPAN and building it manually. Chris Evans wrote: I am having a problem with testing MySql (max) version 3.23.49a. I downloaded the 3 required Perl packages (Data-Dumper, DBI, and Msql-Mysql-modules), the latest versions, and installed them. The OS is RH Linux 7.2. The installation of both the binary MySql distribution and the Perl packages seemed to go ok, and the MySql installation passed the little initial tests. I am getting the following error doing run-all-tests: [root@scully sql-bench]# run-all-tests install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains: /usr/lib/perl5/5.6.0/i386-linux /usr/lib/perl5/5.6.0 /usr/lib/perl5/site_perl/5.6.0/i386-linux /usr/lib/perl5/site_perl/5.6.0 /usr/lib/perl5/site_perl .) at (eval 44) line 3. Perhaps the DBD::mysql perl module hasn't been fully installed, or perhaps the capitalisation of 'mysql' isn't right. Available drivers: ADO, ExampleP, Multiplex, Proxy. at /usr/local/mysql-max-3.23.49a-pc-linux-gnu-i686/sql-bench/server-cfg line 238 Any thoughts about what is wrong? Thanks. Chris Evans [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySql/Perl installation problem
I have downloaded and installed DBD-mysql-2.1011, which has allowed the test suite $MYSQL_HOME/sql-bench/run-all-tests to complete successfully. (I had thought that the insert test was not working, but I was simply too impatient--it took about 45 min of clock time to run.) Everything is working now I think, although I am having a little problem with setting up user passwords. Thanks for the help! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Perl list
On Fri, Apr 06, 2001 at 03:03:40PM -0700, Kristopher Briscoe wrote: Does anyone know of a good list(s) relating to PERL and MySQL? Also, any good repositories of example code? Thanks, Kris- I dunno if it's _good_ or not, but it's a repository: http://www.kitebird.com/mysql-perl/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Perl list
On 6 Apr 2001, at 15:03, Kristopher Briscoe wrote: Does anyone know of a good list(s) relating to PERL and MySQL? Also, any good repositories of example code? As you are using the DBI you should be on the DBI list: http://lists.perl.org/showlist.cgi?name=dbi-users but you might be interested in some other lists: http://lists.perl.org/ Peter --- "Reality is that which, when you stop believing in it, doesn't go away". -- Philip K. Dick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
