frustratedI tried to run the upgrade the update-db.pl command and got the following:
:/home/lj# bin/upgrading/update-db.pl --runsql --populate
Can't connect to the database (clust#0), so I can't update it.
I /was/ able to run the mysql -uroot commands and create the database, grant access and etc. Plus the system shows mysql processes running and if I connect to it manually I get a good status output (as follows)
mysql> status
--------------
mysql Ver 11.15 Distrib 3.23.47, for pc-linux-gnu (i686)
Connection id: 30
Current database: myjournal
Current user: root@localhost
Current pager: stdout
Using outfile: ''
Server version: 3.23.47-log
Protocol version: 10
Connection: Localhost via UNIX socket
Client characterset: latin1
Server characterset: latin1
UNIX socket: /var/run/mysqld/mysqld.sock
Uptime: 23 hours 34 min 1 sec
Threads: 1 Questions: 25 Slow queries: 0 Opens: 8 Flush tables: 1 Open tables: 2 Queries per second avg: 0.000
--------------
mysql>
here's my config from the ljconfig.pl
%DBINFO = (
'master' => { # master must be named 'master'
'host' => "localhost",
'port' => 3306,
'user' => 'sjmaster',
'pass' => '*********',
'role' => {
'cluster1' => 1,
},
},
# example of a TCP-based DB connection
#'somehostname' => {
# 'host' => "somehost",
# 'port' => 1234,
# 'user' => 'username',
# 'pass' => 'password',
#},
# example of a UNIX domain-socket DB connection
#'otherhost' => {
# 'sock' => "$LJ::HOME/var/mysqld.sock",
# 'user' => 'username',
# 'pass' => 'password',
#},
);
# clusters? (for each @CLUSTERS, need a 'cluster$i' role above)
$DEFAULT_CLUSTER = 1;
@CLUSTERS = qw(1);
$ALLOW_CLUSTER_SELECT = 0; # for testing; you don't want this on.
----------------------------------------
I tried creating the system user, and this is what happened:
:/home/lj# bin/upgrading/make_system.pl
This tool will create your LiveJournal 'system' account and set its password. Or, if you already have a system user, it'll change its password to whatever you specify.
Enter password for the 'system' account: ********
Creating system account...
Can't call method "quote" on an undefined value at /home/lj/cgi-bin/ljlib.pl line 2032, line 1.