Tib (tigerknight) wrote in lj_dev,
Tib
tigerknight
lj_dev

  • Mood:

update-db.pl and make_system.pl unable to find database

I'm still having problems connecting LJ to mysql :/ Any input is appreciated. I'd link to it, but I think I had it friend restricted (d'oh!) so no one could see it. Well..


I 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.
Subscribe
  • Post a new comment

    Error

    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

    Your IP address will be recorded 

  • 8 comments