Re: DBD::mysql make test failure - /tmp/mysql.sock
On Thu, Aug 28, 2003 at 09:06:59PM -0700, Ron Ih wrote: I have tried editing the /etc/my.cnf file which is shown below: [client] port=3306 socket=/var/lib/mysql/mysql.sock [mysqld] port=3306 socket=/var/lib/mysql/mysql.sock set-variable = key_buffer_size=16M [snip] However, the make test keeps failing with the error messages shown at the bottom of this email. It keeps trying to connect to MySQL through the socket in /tmp when its in /var/lib/mysql. How do I tell the compiler to look there? I am concerned that the compiler will direct the driver to look in /tmp. The perl Makefile.PL and make seem to work OK. I don't believe that DBD::mysql reads my.cnf. The solution I used was to symlink /var/lib/mysql.sock to /tmp/mysql.sock; you can do this temporarily to pass make test, then read perldoc DBD::mysql to see how to configure the socket file in the DBI-connect call. (I'm not sure if there's an easy way to tell make test the location of mysql.sock--someone who knows DBD::mysql better may give a more accurate answer.) --keith -- [EMAIL PROTECTED] alt.os.linux.slackware FAQ: http://wombat.san-francisco.ca.us/cgi-bin/fom
foreign_key_info for DBD::Pg
So the recent discussion on column_info in DBD::Pg had me delving into the code to see if foreign_key_info had been implemented but undocumented. Turns out it has not, at least in the latest release version of DBD::Pg. Is anyone currently working on implementing it? If not, are people interested in adding it? I have a need for the method, and would be willing to try to write it if nobody else is working on it. --keith -- [EMAIL PROTECTED] public key: http://wombat.san-francisco.ca.us/kkeller/kkeller.asc alt.os.linux.slackware FAQ: http://wombat.san-francisco.ca.us/cgi-bin/fom
Re: Q: MySQL 'v' Postgres column attributes
On Wed, Feb 19, 2003 at 01:10:00PM -0800, David Wheeler wrote: On Wednesday, February 19, 2003, at 01:03 AM, Ron Savage wrote: Is there a Postgres DBI/DBD::Pg call which will retrieve the column attributes the way show columns from $table does under MySQL? column_info(). http://search.cpan.org/author/TIMB/DBI/DBI.pm#column_info I'm not sure this is supported by DBD::Pg: it's not mentioned there (and most supported methods are). I haven't had a chance to try yet, though--I'll see if I can do it later. In the meantime, $attrs= $dbh-func($table,'table_attributes') is documented in DBD::Pg, and works well enough. --keith -- [EMAIL PROTECTED] public key: http://wombat.san-francisco.ca.us/kkeller/kkeller.asc alt.os.linux.slackware FAQ: http://wombat.san-francisco.ca.us/cgi-bin/fom