Joe, Thanks for your followup. Please see my responses below labeled "SS": 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
-- View this message in context: http://www.nabble.com/Can%27t-locate-object-method-connect-via-package-DBI-t... Sent from the Koha - Discuss mailing list archive at Nabble.com.