|
本帖最后由 abc3240660 于 2017-4-9 19:37 编辑
照着视频做了个记帐本小程序,部署到windows上访问http://127.0.0.1:8080/acc页面正常,但是部署到ubuntu虚拟机上,访问http://127.0.0.1:8080/acc页面显示数据库连不上。
数据库都是用的wex5环境自带的account,而且在Windows系统上用“启动MySQL管理工具.bat”可以成功连到远程的ubuntu上的mysql。
windows上部署方法:
把www下的acc文件夹和BaasServer文件夹改名为baas都放在webapps目录下,并拷贝WEB-INF到acc目录下,然后依次启动
启动MySQL数据库.bat
启动WeX5运行平台.bat
ubuntu上部署方法:
下载的runtime是WeX5_V3.6-runtime-java-linux.tar.gz,解压后,把acc文件夹和baas文件夹都放在webapps目录下,并拷贝WEB-INF到acc目录下,然后依次启动startMySQL.sh和startWeX5.sh。
以下是ubuntu上启动wex5的log:
damon@ubuntu:~/working/wex5_ide$ ./startWeX5.sh
Using CATALINA_BASE: ../../apache-tomcat
Using CATALINA_HOME: /home/damon/working/wex5_ide/apache-tomcat
Using CATALINA_TMPDIR: ../../apache-tomcat/temp
Using JRE_HOME: ../../java/jre1.8
Using CLASSPATH: ../../java/jre1.8/lib/tools.jar:../../apache-tomcat/bin/tomcat-juli.jar:/home/damon/working/wex5_ide/apache-tomcat/bin/bootstrap.jar
Apr 09, 2017 2:06:31 AM org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: /usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib
Apr 09, 2017 2:06:32 AM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
Apr 09, 2017 2:06:32 AM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1493 ms
Apr 09, 2017 2:06:32 AM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Apr 09, 2017 2:06:32 AM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.41
Apr 09, 2017 2:06:32 AM org.apache.catalina.startup.HostConfig deployDescriptor
INFO: Deploying configuration descriptor PushServer.xml
2017-04-09 02:06:33 PushServer stop
Apr 09, 2017 2:06:33 AM org.apache.catalina.startup.HostConfig deployDescriptor
INFO: Deploying configuration descriptor manager.xml
Apr 09, 2017 2:06:34 AM org.apache.catalina.startup.HostConfig deployDescriptor
INFO: Deploying configuration descriptor host-manager.xml
Apr 09, 2017 2:06:34 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory wex5
Apr 09, 2017 2:06:34 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory acc
Apr 09, 2017 2:06:34 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory app-template
Apr 09, 2017 2:06:34 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory docs
Apr 09, 2017 2:06:35 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory ROOT
Apr 09, 2017 2:06:35 AM org.apache.catalina.loader.WebappClassLoader validateJarFile
INFO: validateJarFile(/home/damon/working/wex5_ide/apache-tomcat/webapps/baas_bak/WEB-INF/lib/servlet-api.jar) - jar not loaded. See Servlet Spec 2.3, section 9.7.2. Offending class: javax/servlet/Servlet.class
Apr 09, 2017 2:06:35 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory baas
Apr 09, 2017 2:06:35 AM org.apache.catalina.loader.WebappClassLoader validateJarFile
INFO: validateJarFile(/home/damon/working/wex5_ide/apache-tomcat/webapps/baas/WEB-INF/lib/servlet-api.jar) - jar not loaded. See Servlet Spec 2.3, section 9.7.2. Offending class: javax/servlet/Servlet.class
Apr 09, 2017 2:06:36 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory examples
Apr 09, 2017 2:06:36 AM org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
Apr 09, 2017 2:06:36 AM org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
Apr 09, 2017 2:06:36 AM org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/52 config=null
Apr 09, 2017 2:06:36 AM org.apache.catalina.startup.Catalina start
INFO: Server startup in 4318 ms
log4j:WARN No appenders could be found for logger (com.samaxes.filter.CacheFilter).
log4j:WARN Please initialize the log4j system properly.
2017-04-09 02:06:53 获取数据库[java:comp/env/account]连接失败,可能原因:数据库已经关闭或者数据源配置错误
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at com.justep.baas.data.DataUtils.getConnection(Unknown Source)
at com.justep.baas.action.ActionContext.getConnection(Unknown Source)
at com.justep.baas.action.CRUD.query(Unknown Source)
at qdu.Accu__do.queryAccount(Accu__do.java:43)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at com.justep.baas.action.Engine.execAction(Unknown Source)
at com.justep.baas.action.Engine.execAction(Unknown Source)
at com.justep.baas.servlet.BaasServlet.execService(Unknown Source)
at com.justep.baas.servlet.BaasServlet.service(Unknown Source)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
而且,如果我把mysql-connector-java-5.1.36-bin.jar文件给删掉,也是报上面这样的错误,感觉好像这个mysql-connector-java-5.1.36-bin.jar都没有被用到过
请问这是哪一步出错了啊?
|
|