Sorry, you have provided all details before! If you manage to reproduce the error on-demand it would be good to test with the master branch and with the patch on bug 14778 (not in master yet). 2015-09-28 17:26 GMT+01:00 Scott Owen <sowen@edzone.net>:
Nope, SQL runs on the same server.
On Mon, Sep 28, 2015 at 12:14 PM, Jonathan Druart < jonathan.druart@bugs.koha-community.org> wrote:
Does your mysql server run on another server? If so, it should be defined in the koha-conf.xml, search the config section, then hostname.
2015-09-28 16:44 GMT+01:00 Scott Owen <sowen@edzone.net>:
Looks like here is where things go south....
******************************
[Fri Sep 25 15:20:03 2015] Auth.pm: DBI connect('dbname=koha_dlpms;host=localhost;port=3306','koha_dlpms',...) failed: Lost connection to MySQL server at 'sending authentication information', system error: 32 at /usr/share/perl5/DBIx/Connector.pm line 32
********************************
Could i just have a typo somewhere ????
*************************************
opac-search.pl?q=middol+school
**************************************
Rather than "localhost" should I hardcode in the system IP ??
***************************************
'dbname=koha_dlpms;host=localhost;port=3306'
****************************************
_____________________________________log snip______________________________________________
[Fri Sep 25 15:19:40.358978 2015] [cgi:error] [pid 6777] [client 10.1.1.111:36648] AH01215: [Fri Sep 25 15:19:18 2015] opac-user.pl: BEGIN failed--compilation aborted at /usr/share/koha/opac/cgi-bin/opac/opac-user.pl line 25., referer: http://10.1.1.37/cgi-bin/koha/opac-search.pl?q=middol+school [Fri Sep 25 15:19:27.363750 2015] [cgi:warn] [pid 6424] [client 10.1.1.111:15692] AH01220: Timeout waiting for output from CGI script /usr/share/koha/opac/cgi-bin/opac/opac-search.pl, referer: http://10.1.1.37/cgi-bin/koha/opac-search.pl?q=middol+school [Fri Sep 25 15:19:40.317727 2015] [cgi:warn] [pid 6427] [client 10.1.1.111:15697] AH01220: Timeout waiting for output from CGI script /usr/share/koha/opac/cgi-bin/opac/opac-search.pl, referer: http://10.1.1.37/cgi-bin/koha/opac-search.pl?q=middol+school [Fri Sep 25 15:19:40.418439 2015] [cgi:error] [pid 6424] [client 10.1.1.111:15692] Script timed out before returning headers: opac-search.pl, referer: http://10.1.1.37/cgi-bin/koha/opac-search.pl?q=middol+school [Fri Sep 25 15:19:40.523899 2015] [cgi:error] [pid 6427] [client 10.1.1.111:15697] Script timed out before returning headers: opac-search.pl, referer: http://10.1.1.37/cgi-bin/koha/opac-search.pl?q=middol+school [Fri Sep 25 15:19:40.751819 2015] [cgi:error] [pid 6414] [client 10.1.1.111:15685] Script timed out before returning headers: opac-search.pl, referer: http://10.1.1.37/cgi-bin/koha/opac-search.pl?q=middol+school [Fri Sep 25 15:19:40.318628 2015] [cgi:warn] [pid 6432] [client 10.1.1.111:15700] AH01220: Timeout waiting for output from CGI script /usr/share/koha/opac/cgi-bin/opac/opac-search.pl, referer: http://10.1.1.37/cgi-bin/koha/opac-search.pl?q=middol+school [Fri Sep 25 15:19:41.062151 2015] [cgi:error] [pid 6432] [client 10.1.1.111:15700] Script timed out before returning headers: opac-search.pl, referer: http://10.1.1.37/cgi-bin/koha/opac-search.pl?q=middol+school [Fri Sep 25 15:20:03.586683 2015] [cgi:error] [pid 6847] [client 10.1.1.111:36745] AH01215: ., referer: http://10.1.1.37/cgi-bin/koha/opac-search.pl?q=middol+school
___________________________________________________________________________________
Thanks for any pointers of where to go from here ....
-S
On Tue, Sep 22, 2015 at 10:48 PM, Robin Sheat <robin@catalyst.net.nz>
wrote:
Scott Owen schreef op di 22-09-2015 om 22:25 [-0400]:
Hummm.....database is located on the same box....so I think a conductivity issue is unlikely. Guess I'll start digging through logs in my free time....any particular log that might be a good place to start? any key words I should be looking for ?
Nothing in particular, but I'd look for anything odd in syslog, perhaps turn the mysql logging level up a bit and see what it says, and so forth. Note that I'm not 100% sure that this is the cause of your issue, but it looks like it from the surface.
-- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha