[Pdx-pm] DBD::mysql

[James marks]

OK, some progress but no success. (I'm beginning to feel like a real  
bonehead.)


> From the top level build directory, as root, try doing:
>
> chmod u+rwx `find .`

Tried:

[iMac:~/.cpan/build] jamesmar% chmod u+rwx `find .`

Did not observe any change in the write permissions of the files in the  
subdirectories. They all show (unless I'm misunderstanding it) that I  
have read, write and execute permission:

drwxr-xr-x
-rwxr-xr-x




> "...Edit
>
> /System/Library/Perl/5.8.1/darwin-thread-multi-2level/Config.pm
>
> and change the line
>
> ld="MACOSX_...."
>
> to read
>
> ld="env MACOSX_...."



I changed:

ld='MACOSX_DEPLOYMENT_TARGET=10.3 cc'

to:

ld='env MACOSX_DEPLOYMENT_TARGET=10.3 cc'

and got a lot farther in the install but still had a lot of failures:

(snip)

Can't exec "mysql_config": No such file or directory at Makefile.PL  
line 174.
readline() on closed filehandle PIPE at Makefile.PL line 176.

(snip)

Checking if your kit is complete...
Looks good
Note (probably harmless): No library found for -lgz

(snip)

Warning: duplicate function definition 'do' detected in mysql.xs, line  
192
Warning: duplicate function definition 'rows' detected in mysql.xs,  
line 290

(snip)

t/40numrows........DBI connect('test','',...) failed: Access denied for  
user: 'root at localhost' (Using password: NO) at t/40numrows.t line 59
Cannot connect: Access denied for user: 'root at localhost' (Using  
password: NO)
         Either your server is not up and running or you have no
         permissions for acessing the DSN DBI:mysql:test.
         This test requires a running server and write permissions.
         Please make sure your server is running and you have
         permissions, then retry.

(snip)

t/mysql............Mysql connect('database=test;host=','',...) failed:  
Access denied for user: 'root at localhost' (Using password: NO) at  
t/mysql.t line 55
not ok 1: Access denied for user: 'root at localhost' (Using password: NO)
         It looks as if your server is not up and running.
         This test requires a running server.
         Please make sure your server is running and retry.

(snip)

Failed Test       Stat Wstat Total Fail  Failed  List of Failed
------------------------------------------------------------------------ 
-------
t/10dsnlist.t       10  2560     9   17 188.89%  1-9
t/20createdrop.t    10  2560     5    9 180.00%  1-5
t/30insertfetch.t   10  2560    11   21 190.91%  1-11
t/40bindparam.t     10  2560    28   55 196.43%  1-28
t/40blobs.t         10  2560    11   21 190.91%  1-11
t/40listfields.t    10  2560    18   35 194.44%  1-18
t/40nulls.t         10  2560    11   21 190.91%  1-11
t/40numrows.t       10  2560    25   49 196.00%  1-25
t/50chopblanks.t    10  2560    35   69 197.14%  1-35
t/50commit.t       255 65280    30   59 196.67%  1-30
t/ak-dbd.t         255 65280    90  175 194.44%  1 4-90
t/akmisc.t          10  2560   351  701 199.72%  1-351
t/dbdadmin.t        10  2560    21   41 195.24%  1-21
t/insertid.t       255 65280    12   24 200.00%  1-12
t/mysql.t                       ??   ??       %  ??
t/mysql2.t         255 65280    ??   ??       %  ??
1 test skipped.
Failed 16/18 test scripts, 11.11% okay. 723/730 subtests failed, 0.96%  
okay.
make: *** [test_dynamic] Error 2
   /usr/bin/make test -- NOT OK
Running make install
   make test had returned bad status, won't install without force



It appears to me that I have two problems:

1) I'm unable to connect to the web server
2) I'm unable to connect to the MySQL server

My web server is running, verified by entering the URL of a local file,  
"phpTest.php" in the browser and seeing PHP correctly executed and  
returned by the Apache server. I"m assuming, therefore, that the  
problem is with write permissions but I'm currently logged in as the  
root and should have all permissions, correct?

My MySQL server is also running, verified by observing mysqld included  
in the current processes and by successfully logging in and out of  
MySQL as a user. I can create a  MySQL user and GRANT access without  
requiring a password, but nowhere in the install procedure does it  
instruct me to do that.


Suggestions?