Re: Can't locate object method connect via package DBI

Joe Atzberger wrote:

>
> If it helps, here is the statement I am using in my small test script:
> $dbh = DBI->connect("DBI:mysql:koha","<username>","<password>")
>

I assume you are using a real username in place of <username> and a real
password in place of <password>, and the matching values in the GRANT
commands.

      SS:  Yes, I am using a real username and password.  The username matches the value in the GRANT
             command.  The GRANT command does not ask for a password, but I am using the one assigned
             when I created the account, and I can login to mysql using that password.

If you can connect on command line, as you suggest, then please also test
some critical operations like create a new table and then deleting it.
Those are the kinds of permissions that your Koha user needs to have at
installation.  Getting in is not enough.

      SS:  Yes, I can create tables, insert values, select values, delete values, drop tables, etc.

The exact statement Koha uses is:
    my $dbh=
DBI->connect("DBI:$db_driver:dbname=$db_name;host=$db_host;port=$db_port",
$db_user, $db_passwd);


All the strings with dollar signs ($) prepended are variables populated with
values from the bottom of koha-conf.xml.

      SS:  The code pulls the values from context->config, which I assume get its values from
             from koha-conf.xml.  The values in koha-conf.xml are correct for hostname, database, port, user
             and pass.

Make sure your Apache VirtualHost config uses SetEnv KOHA_CONF ... with the
correct path to your koha-conf.xml file.  This should be the same file path
you reference in shell by saying something like:

export KOHA_CONF=/path/to/my/koha-conf.xml

Otherwise you are testing something different than Apache is seeing.  If you
edited the Apache configs at all, remember to do a (graceful) restart to
make them take effect.

      SS:  SetEnv KOHA_CONF is correct in the <VIrtualHost> section of httpd.conf.
             After making this change, I rebooted the server.

--Joe

      SS:  If you have any other suggestions, they are greately appreciated.

_______________________________________________
Koha mailing list
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha