I've been going through the LJ developer documentation and I've gotten to 10. MySQL: 3. Populate the Database and can't seem to create my "system" user.
I get the following output/error when I try to do update-db.pl:
$ bin/upgrading/update-db.pl --runsql --populateI also get an error when it try to do make_system.pl:
Updating cluster: 0
cluster: status
0: OKAY
System user not found. Creating with random password.
Failed to create system user. at bin/upgrading/update-db.pl line 188.
$ bin/upgrading/make_system.plI think that make_system.pl is incorrect when it determines that the system account already exists:
This tool will create [...]
Creating system account...
Already exists.
Modifying 'system' account...
ERROR: can't find newly-created system account.
$ mysql -u lj -pI'm guessing that LJ::create_account() isn't behaving the way it should. I'm using default installations of all the supporting software (apache, mod_perl, mysql) and as far as I can tell, things in ljconfig.pl look fine. And checkconfig.pl seems happy:
mysql> use livejournal;
Database changed
mysql> select * from user;
Empty set (0.00 sec)
$ bin/checkconfig.plI'd love any suggestions.
[Checking for Perl Modules....]
Missing optional module.... (I'm OK with that, they're for OpenID and AtomAPI)
[Checking LJ Environment...]
[Checking Database...]
All good.
NOTE: checkconfig.pl doesn't check everything yet