Re: DBD::Mysql not working properly in mac OS X

[daxim]

Your description of how you attempted to install the module is vague, but from the results it looks like the module is not correctly installed. Try again and do it properly. Show your attempts and the errors you get.

[romy_mathew]

Below is the method I used for installing DBD::Mysql

1. perl Makefile.PL –mysql_config=/usr/local/mysql/bin/mysql_config –t
+estuser=root –testpassword=111111
I will use the following settings for compiling and testing:

cflags (mysql_config ) = -I/usr/local/mysql/include -Os -g -fno-common
+ -fno-strict-aliasing -arch x86_64
embedded (mysql_config ) = 
ldflags (mysql_config ) = 
libs (mysql_config ) = -L/usr/local/mysql/lib -lmysqlclient -lpthread
mysql_config (Users choice ) = /usr/local/mysql/bin/mysql_config
nocatchstderr (default ) = 0
nofoundrows (default ) = 0
ssl (guessed ) = 0
testdb (default ) = test
testhost (default ) = 
testpassword (User’s choice) = 111111
testsocket (default ) = 
testuser (User’s choice) = root

2. make

3. make test

All tests successful.
Files=51, Tests=1270, 22 wallclock secs ( 0.38 usr  0.16 sys +  3.51 c
+usr  0.49 csys =  4.54 CPU)
Result: PASS

4. sudo make install 

Installing /Library/Perl/5.12/darwin-thread-multi-2level/auto/DBD/mysq
+l/mysql.bundle
Appending installation info to /Library/Perl/Updates/5.12.4/darwin-thr
+ead-multi-2level/perllocal.pod

[talexb]

OK -- can you run something very simple, either from the debugger, or as a simple script, that just connects to the database?

[romy_mathew]

it gives output in the terminal but the same when i try in the http://localhost/cgi-bin/hello.pl it fails from line my $dbh = DBI->connect($dsn, $userid, $password ) or die $DBI::errstr;