生命在于折腾 生命不息 折腾不止

配置文件”serverconfig.property”中记录了如下信息，我们可以按需修改之。

#
#Wed Feb 26 22:16:41 CST 2003
WelcomePage=/JudgeOnline/index.acm
RootPath=/JudgeOnline/
DefaultTitle=Welcome to JudgeOnline

LangCount=4
LanguageDescs=G++,GCC,Pascal,Java,VC,VC++
LanguageExtMemory=868,868,1140,10100,0,0
LanguageExtTime=0,0,0,4000,0,0
LanguageExts=cc,c,pas,java,c,cpp
LanguageExes=exe,exe,exe,class,exe,exe
LanguageTimeFactor=1,1,1,1,1,1
CompileStreamOrder=1,1,0,1,1,1

G++CompileCmd=C\:\\JudgeOnline\\bin\\gcc\\bin\\g++.exe -fno-asm -s -w -O1 -DONLINE_JUDGE -o %PATH%%NAME% %PATH%%NAME%.%EXT%
GCCCompileCmd=C\:\\JudgeOnline\\bin\\gcc\\bin\\gcc.exe -fno-asm -s -w -O1 -DONLINE_JUDGE -o %PATH%%NAME% %PATH%%NAME%.%EXT%
PascalCompileCmd=C\:\\JudgeOnline\\bin\\fpc\\fpc.exe -Sg -dONLINE_JUDGE %PATH%%NAME%.%EXT%
JavaCompileCmd=javac %PATH%%NAME%.%EXT%
JavaRunCmd=java -classpath %PATH% %NAME%
#VCCompileCmd=C\:\\JudgeOnline\\bin\\cl.exe %PATH%%NAME%.%EXT% /Fe%PATH%%NAME% /O2 /DONLINE_JUDGE
#VC++CompileCmd=C\:\\JudgeOnline\\bin\\cl.exe %PATH%%NAME%.%EXT% /Fe%PATH%%NAME% /O2 /DONLINE_JUDGE

WorkingPath=C\:\\temp
DataFilesPath=D\:\\data
DeleteTempFile=True
RunShell=C\:\\JudgeOnline\\bin\\run.exe
ComShell=C\:\\JudgeOnline\\bin\\com.exe
AdminName=admin
AdminEmail=admin@admin.net

Debug=False
DebugFile=C\:\\debug.txt
#ErrFile=C\:\\err.txt

可以采用同样的方法增加其他语言的支持

最近安装POJ，出现如下问题：

getConn ():Cannot create PoolableConnectionFactory (Server connection failure during transaction. Due to underlying exception: ‘java.sql.SQLException: Invalid authorization specification message from server: “Access denied for user ‘root’@'localhost’ (using password: YES)”‘.

** BEGIN NESTED EXCEPTION **

java.sql.SQLException
MESSAGE: Invalid authorization specification message from server: “Access denied for user ‘root’@'localhost’ (using password: YES)”

STACKTRACE:

java.sql.SQLException: Invalid authorization specification message from server: “Access denied for user ‘root’@'localhost’ (using password: YES)”
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1906)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:2520)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:817)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1898)
at com.mysql.jdbc.Connection.<init>(Connection.java:450)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:411)
at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at com.pku.judgeonline.common.DBConfig.I(Unknown Source)
at com.pku.judgeonline.common.ServerConfig.append(Unknown Source)
at com.pku.judgeonline.common.ServerConfig.I(Unknown Source)
at com.pku.judgeonline.servlet.Index.init(Unknown Source)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4187)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4496)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443

这个问题困扰我好几天，写个jsp的连接文件没有问题，但是用POJ中的context.xml连就不行。

刚开始以前是MySQL的版本问题，因为POJ用的是MySQL4.1.*，而我安装的是MySQL 5.1，其间还换了好几个版本的连接文件还是不行。

解决方法：POJ安装的时候在Tomcat的\webapps\JudgeOnline\META-INF下面有一个context.xml文件，但Tomcat重新Copy了一份到\conf\Catalina\localhost\JudgeOnline.xml，而且用的是后面这个配置文件，只要将后面这个文件的用户名和密码改成正确的就可以。

具体见：http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=51345