Tib (tigerknight) wrote in lj_dev,

Ok.. issues with mysql can't be avoided now...

I got the apache part of the ljcode fixed, thanks to those who told me to look at the rewrite lines in the INSTALL.apache.txt file. I've got some problems and I'll show them all, if you can help me with mysql setup and LJ,

Passwords protected for the innocent :]

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


here's my config from the ljconfig.pl
'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)
@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.

  • Post a new comment


    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

    Your IP address will be recorded