insipid (reflexion) wrote in lj_everywhere,

  • Mood:

DB connection problems - 'Can't call method "selectrow_array"...'

Any advice on how to debug/troubleshoot a DB connection issue?

[error] Can't call method "selectrow_array" on an undefined value at /home/lj/cgi-bin/ line 5844.

Before you ask: yes, I'm a moron; yes, I've read the server docs; and yes, I don't know enough about how to use Linux.

I was really hoping to be able to do this all by myself, but I guess not.

I keep getting the above error message in my apache log whenever I try to view anything. Having read through nearly every post in here from the last 18 months, it seems to be saying that it's not connecting to the database properly.

I've checked it out every way I can think of (but this is where my Linux/apache/mysql ignorance comes in):
- reports everything as ok.
- mysqld is definitely running, and I can connect with mysql using the same host/username/password
- in my DBINFO, using 'host' => "localhost" or 'sock' => "/var/lib/mysql/mysql.sock" cause to work okay, but trying 'host' => "" causes to say it couldn't get the database handle (at the moment, I don't have another IP address, or hostname, for this machine)

I'm working from the tarball dated Aug 25th (I can't use CVS from here at work because of the firewall.)

It's a RedHat 9 box with Apache 1.3.26 compiled with mod_perl 1.29 built in.

I can't think of any more info.

Obviously, any advice/suggestions would be insanely appreciated.

  • Post a new comment


    Comments allowed for members only

    Anonymous comments are disabled in this journal

    default userpic

    Your IP address will be recorded