Simple Database connect
I'm running mod_perl MySQL on a Mac OSX machine with the following
information at the start of the Apache server :
[Fri Aug 16 10:38:41 2002] [alert] httpd: Could not determine the
server's fully qualified domain name, using 127.0.0.1 for ServerName
[Fri Aug 16 10:38:41 2002] [notice] Apache/1.3.26 (Darwin) PHP/4.2.2
mod_perl/1.26 configured -- resuming normal operations
[Fri Aug 16 10:38:41 2002] [notice] Accept mutex: flock (Default: flock)
I'm trying to interface the hereafter described database with the
following script :
The error is at the end : could you help me to fix it (Perhaps I've made
a mistake in installing manually the DBI package which is probably
inside of /usr/libexec/httpd/libphp4.so)
#!/usr/bin/perl
# load module
use DBI();
# connect
my $dbh = DBI-connect(DBI:mysql:database=jobs;host=localhost, root,
, {'RaiseError' = 1});
# execute query
my $sth = $dbh-prepare(SELECT * FROM location);
$sth-execute();
# iterate through resultset
while(my $ref = $sth-fetchrow_hashref())
{
print ID: $ref-{'id'}\nLocation: $ref-{'location'}\n\n;
}
# clean up
$dbh-disconnect();
Database Description :
mysql show tables;
++
| Tables_in_jobs |
++
| country|
| degree |
| department |
| industry |
| listing|
| location |
| r_education|
| r_employment |
| r_reference|
| r_skill|
| r_user |
| salary |
| subject|
++
13 rows in set (0.00 sec)
mysql select * from location;
++--+
| id | location |
++--+
| 1 | New York |
| 2 | London |
| 3 | Paris|
| 4 | Tokyo|
| 5 | Bombay |
++--+
5 rows in set (0.48 sec)
Error from error_log file :
dyld: /usr/sbin/httpd multiple definitions of symbol __dig_vec
/usr/libexec/httpd/libphp4.so definition of __dig_vec
/Library/Perl/darwin/auto/DBD/mysql/mysql.bundle definition of __dig_vec
dyld: /usr/sbin/httpd multiple definitions of symbol __dig_vec
/usr/libexec/httpd/libphp4.so definition of __dig_vec
/Library/Perl/darwin/auto/DBD/mysql/mysql.bundle definition of __dig_vec
[Fri Aug 16 16:28:24 2002] [error] (22)Invalid argument: getsockname
Pierre Vaudrey
email [EMAIL PROTECTED]
Re: Simple Database connect
On Friday, August 16, 2002, at 07:52 AM, Pierre Vaudrey wrote: dyld: /usr/sbin/httpd multiple definitions of symbol __dig_vec /usr/libexec/httpd/libphp4.so definition of __dig_vec /Library/Perl/darwin/auto/DBD/mysql/mysql.bundle definition of __dig_vec dyld: /usr/sbin/httpd multiple definitions of symbol __dig_vec /usr/libexec/httpd/libphp4.so definition of __dig_vec /Library/Perl/darwin/auto/DBD/mysql/mysql.bundle definition of __dig_vec It looks as though you have some symbol conflicts between PHP and MySQL. Try turning off libphp.so. If that works, you may need to recompile PHP and/or MySQL. HTH, David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://david.wheeler.net/ Yahoo!: dew7e Jabber: [EMAIL PROTECTED]
Re: Simple Database connect
David Wheeler wrote: On Friday, August 16, 2002, at 07:52 AM, Pierre Vaudrey wrote: dyld: /usr/sbin/httpd multiple definitions of symbol __dig_vec /usr/libexec/httpd/libphp4.so definition of __dig_vec /Library/Perl/darwin/auto/DBD/mysql/mysql.bundle definition of __dig_vec dyld: /usr/sbin/httpd multiple definitions of symbol __dig_vec /usr/libexec/httpd/libphp4.so definition of __dig_vec /Library/Perl/darwin/auto/DBD/mysql/mysql.bundle definition of __dig_vec It looks as though you have some symbol conflicts between PHP and MySQL. Try turning off libphp.so. If that works, you may need to recompile PHP and/or MySQL. most likely this: http://perl.apache.org/docs/1.0/guide/troubleshooting.html#_exit_signal_Segmentation_fault__11___with_mysql And this: [Fri Aug 16 10:38:41 2002] [alert] httpd: Could not determine the server's fully qualified domain name, using 127.0.0.1 for ServerName is amended by adding: 127.0.0.1 localhost.localdomain localhost to /etc/hosts __ Stas BekmanJAm_pH -- Just Another mod_perl Hacker http://stason.org/ mod_perl Guide --- http://perl.apache.org mailto:[EMAIL PROTECTED] http://use.perl.org http://apacheweek.com http://modperlbook.org http://apache.org http://ticketmaster.com
Re: Simple Database connect
Le vendredi 16 août 2002, à 07:17 PM, Stas Bekman a écrit : David Wheeler wrote: On Friday, August 16, 2002, at 07:52 AM, Pierre Vaudrey wrote: dyld: /usr/sbin/httpd multiple definitions of symbol __dig_vec /usr/libexec/httpd/libphp4.so definition of __dig_vec /Library/Perl/darwin/auto/DBD/mysql/mysql.bundle definition of __dig_vec dyld: /usr/sbin/httpd multiple definitions of symbol __dig_vec /usr/libexec/httpd/libphp4.so definition of __dig_vec /Library/Perl/darwin/auto/DBD/mysql/mysql.bundle definition of __dig_vec It looks as though you have some symbol conflicts between PHP and MySQL. Try turning off libphp.so. If that works, you may need to recompile PHP and/or MySQL. I've disabled PHP in httpd.conf and I can print the table : thanks for the tip !! most likely this: http://perl.apache.org/docs/1.0/guide/troubleshooting.html#_exit_signal_Segmentation_fault__11___with_mysql I will do if I need in parallel PHP mod_perl And this: [Fri Aug 16 10:38:41 2002] [alert] httpd: Could not determine the server's fully qualified domain name, using 127.0.0.1 for ServerName is amended by adding: 127.0.0.1 localhost.localdomain localhost to /etc/hosts I'll change the hosts file thanks. __ Stas BekmanJAm_pH -- Just Another mod_perl Hacker http://stason.org/ mod_perl Guide --- http://perl.apache.org mailto:[EMAIL PROTECTED] http://use.perl.org http://apacheweek.com http://modperlbook.org http://apache.org http://ticketmaster.com Pierre Vaudrey 174 rue de Lyon 01800 Bourg Saint Christophe tel 0474 61 1167 mobile 0675 61 5902 email [EMAIL PROTECTED]
