[Koha-bugs] [Bug 24351] New: Connection to remote mysql server errors

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24351

            Bug ID: 24351
           Summary: Connection to remote mysql server errors
 Change sponsored?: ---
           Product: Koha
           Version: 19.11
          Hardware: All
                OS: All
            Status: NEW
          Severity: major
          Priority: P5 - low
         Component: Installation and upgrade (command-line installer)
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: seemaalbal at gmail.com
        QA Contact: testopia at bugs.koha-community.org

Hi
I am installing Koha 19.11 on Debian 4.9. 
My SQL server is running on another instance. 

My my.cnf looks like this:
[client]
host=<remote ip>
user=root
password=xxxxx

I have successfully installed library instance using the koha-create
--create-db <libraryname> command

This has installed a koha site in my apache2. However, the koha-conf.xml under
/etc/koha/sites/<libraryname>/koha-conf.xml had db hostname as localhost. 
I have edited this to point to my sql server. 

However, when I do a wget localhost:8080 I still get an internal server error.

DBI
Connect('database=<libraryname;host=localhost;port=3306','koha_libraryname',...)
failed: Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2 No such file or directory):
/usr/share/koha/intranet/cgi-bin/mainpage.pl 

Please let me know where and how is the database server getting the default
value of localhost.

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.