Hi all
I am trying to set up a Community Server :)
Linux ubuntu 2.6.35-22-generic #34-Ubuntu SMP Sun Oct 10 09:26:05 UTC 2010 x86_64 GNU/Linux
java version "1.6.0_20"
OpenJDK Runtime Environment (IcedTea6 1.9) (6b20-1.9-0ubuntu1)
OpenJDK 64-Bit Server VM (build 17.0-b16, mixed mode)
mysql Ver 14.14 Distrib 5.1.49, for debian-linux-gnu (x86_64) using readline 6.1
I am using the sample-community.conf configuration file, almost unmodified : I only changed the DB username and password, and the server IP address. All the rest is unchanged.
When starting, the CS says :
--------------------------
read log configuration
log4j:WARN No appenders could be found for logger (com.jolbox.bonecp.BoneCPConfig).
log4j:WARN Please initialize the log4j system properly.
[INFO] 16/10/10 14:47 CommunityDAO: Creating DB schema...
[WARNING] 16/10/10 14:47 CommunityDAO: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CHARSET utf8, removed BOOLEAN DEFAULT FALSE, FOREIGN KEY(accountname) REFERENC' at line 1
[WARNING] 16/10/10 14:47 CommunityDAO: CREATE TABLE comments ( swarmid BIGINT UNSIGNED, commentid SERIAL PRIMARY KEY, accountname VARCHAR(128) CHARSET utf8 NOT NULL, time TIMESTAMP DEFAULT NOW(), reply_to BIGINT UNSIGNED DEFAULT NULL, upvote INTEGER DEFAULT 0, downvote INTEGER DEFAULT 0, ip VARCHAR(16) NOT NULL, body TEXT NOT NULL CHARSET utf8, removed BOOLEAN DEFAULT FALSE, FOREIGN KEY(accountname) REFERENCES valid_accounts(username) ON DELETE CASCADE, FOREIGN KEY(swarmid) REFERENCES published_swarms(swarmid) ON DELETE CASCADE ) TYPE=INNODB
[WARNING] 16/10/10 14:47 CommunityDAO: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'community_db.comments' doesn't exist
[WARNING] 16/10/10 14:47 CommunityDAO: CREATE INDEX comment_dates ON comments(time)
[INFO] 16/10/10 14:47 CommunityDAO: Created admin account with blank password -- change the password!
[INFO] 16/10/10 14:47 CommunityDAO: Starting reload of soft state...
[INFO] 16/10/10 14:47 CommunityDAO: db sync took: 7 for 0
[INFO] 16/10/10 14:47 CommunityDAO: Registered: 0 infrastructure keys
[INFO] 16/10/10 14:47 EmbeddedServer: max_threads: 30
2010-10-16 14:47:30.252::INFO: Logging to STDERR via org.mortbay.log.StdErrLog
[INFO] 16/10/10 14:47 KeyRegistrationServlet: Key registration servlet created.
[INFO] 16/10/10 14:47 SwarmPublishServlet: Swarm publishing servlet created.
[INFO] 16/10/10 14:47 EmbeddedServer: Authentication required for swarm publishing
[INFO] 16/10/10 14:47 EmbeddedServer: host: 127.0.0.1
[INFO] 16/10/10 14:47 EmbeddedServer: port: 8081
2010-10-16 14:47:30.336::INFO: jetty-6.1.x
2010-10-16 14:47:30.606::INFO: Started SelectChannelConnector@127.0.0.1:8081
[INFO] 16/10/10 14:47 EmbeddedServer: started embedded server
[INFO] 16/10/10 14:47 CommunityDAO: Using user timeout: 86400000 seconds
[INFO] 16/10/10 14:47 CommunityDAO: Pruned 0 old peers
[INFO] 16/10/10 14:47 CommunityDAO: Starting reload of soft state...
[INFO] 16/10/10 14:47 CommunityDAO: db sync took: 4 for 0
--------------------------------
Jo