Installation

Issue with Library Browser after upgrade to 2.19

Re: Issue with Library Browser after upgrade to 2.19

by Anthony Weaver -
Number of replies: 0
Glenn,

Thanks I had just finished addressing the issue with git aborting because of problems being changed before you replied. It was indeed a database setting in site.conf. Our site.conf was still using this format for the database info:
$database_dsn="dbi:mysql:webwork"

I commented that out and made it match site.conf.dist which has:

# Modern database DSN format:
# DBI:driver:database=$database;host=$hostname;port=$port (when DB not on localhost)
# or DBI:driver:database=$database;host=127.0.0.1;port=$port (when DB on localhost, using TCP)
# See: https://metacpan.org/pod/DBD::MariaDB#port
# "To connect to a MariaDB or MySQL server on localhost using TCP/IP,
# you must specify the host as 127.0.0.1 with the optional port, e.g. 3306."
# or DBI:driver:database=$database (when DB on localhost, using socket)

# One thing on which it depends is the driver name, which you may want to modify.
# It also depends on the database name, which may be non-standard in some settings,
# as may be the hostname and port of the database server.

# driver should be one of:
# "mysql" for the DBD:mysql driver
# "MariaDB" for the DBD:mysql driver

# Select the desired DB driver:
$database_driver="mysql";
#$database_driver="MariaDB";

$database_host="localhost";
$database_port="3306";
$database_name="webwork";

# For a DB on localhost - default to using Unix socket.
# Change to 0 to use a TCP connection to 127.0.0.1.
$database_use_socket_if_localhost=1;

if ( $database_host eq "localhost" ) {
if ( $database_use_socket_if_localhost ) {
$database_dsn="DBI:$database_driver:database=$database_name";
} else {
$database_dsn="DBI:$database_driver:database=$database_name;host=127.0.0.1;port=$database_port";
}
} else {
$database_dsn="DBI:$database_driver:database=$database_name;host=$database_host;port=$database_port";
}

# The default storange engine to use is set here:
$database_storage_engine = 'myisam';