Re: Re: Re: DBI::mysql fetch() without execute() PROBLEM

[cfreak]

I should have seen that right away. You are trying to connect to a mysql database with syntax for the DBI::CSV module. When using the mysql driver connect like this:

my $dsn = "DBI:mysql:database=your_db_name;host=your_hostname;";
my $dbh = DBI->connect($dsn,'your_db_username','your_db_password') or 
+die "Couldn't connect to database";

So instead of "f_dir" use "database=" and make sure to put the host name. If you are trying to use a comma separated file somewhere on your system then you should use the CSV driver, just keep using the f_dir part and put "CSV" where you have "mysql".

Hope that helps

Chris

[peppiv]

Thanks for the catch. I actually had it that way once, but since I couldn't get it to work I dropped it.



#!/usr/bin/perl -w
     
    use strict;
    use DBI;
    use CGI::Carp qw(fatalsToBrowser);
    use CGI qw (:standard);
    print "Content-type: text/html\n\n";
    

     my $dbh = DBI->connect(qq{DBI:mysql:database=subscriptions;host=l
+ocalhost,I DON'T HAVE A USERNAME AND PASSWORD OTHER THAN ROOT}, {Rais
+eError => 1} );

     my $sth = $dbh->prepare( q{SELECT email FROM contacts WHERE state
+ = ?} );

     $sth->execute('OH') or die $sth->errstr; 

     while (my @result = $sth->fetchrow_array()) {
        print "@result\n";
        }     
        
     # check for problems which may have terminated the fetch early
     die $sth->errstr if $sth->err;
     
     $dbh->disconnect;


I've tried many things to connect but to no avail. \s tells me that I'm connected via a UNIX socket. I can only find docs about different ports. Could this be a problem?



Can't call method "prepare" on an undefined value at /usr/local/etc/ht
+tpd/cgi-bin/DBI_mysql_01.pl line 12.


Is there any way to view the path or connection?

[cfreak]

even if you don't have a password you should still put in the username. I'm not sure what you mean by \s. You should also make sure your mysql database is running. (i.e. Can you connect to it using the mysql client?).

[peppiv]

Things I've learned.

\s is the command you type in when you're in the mysql client. It tells you lots of cool information. Who you're logged in as, your connection, etc. Very neat.

Also, I've learned to run "top" in Telnet. It tells me all the processes running. Including the mysqld.