<div class="gmail_quote"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">If it helps, here is the statement I am using in my small test script:<br>
$dbh = DBI->connect("DBI:mysql:koha","<username>","<password>")<font color="#888888"><br></font></blockquote></div><br>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.<br>
<br>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.<br>
<br>The exact statement Koha uses is:<br> my $dbh= DBI->connect("DBI:$db_driver:dbname=$db_name;host=$db_host;port=$db_port", $db_user, $db_passwd);<br><br>All the strings with dollar signs ($) prepended are variables populated with values from the bottom of koha-conf.xml. <br>
<br>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:<br><br><div style="margin-left: 40px;">
export KOHA_CONF=/path/to/my/koha-conf.xml<br></div><br>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.<br>
<br>--Joe<br>