起步软件技术论坛
搜索
 找回密码
 注册

QQ登录

只需一步,快速开始

查看: 1797|回复: 3

[结贴] 部署到linux后,数据库连不上咋整

[复制链接]

10

主题

52

帖子

96

积分

初级会员

Rank: 2

积分
96
QQ
发表于 2017-4-9 14:45:05 | 显示全部楼层 |阅读模式
本帖最后由 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都没有被用到过

请问这是哪一步出错了啊?

访问错误

访问错误

数据源配置

数据源配置

webapps目录

webapps目录

10

主题

52

帖子

96

积分

初级会员

Rank: 2

积分
96
QQ
 楼主| 发表于 2017-4-9 19:02:40 | 显示全部楼层
和这个帖子上的问题差不多,不过这个帖子没给出如何解决的方法
http://bbs.wex5.com/forum.php?mo ... %2Bmysql&page=1
回复 支持 反对

使用道具 举报

10

主题

52

帖子

96

积分

初级会员

Rank: 2

积分
96
QQ
 楼主| 发表于 2017-4-9 19:04:07 | 显示全部楼层
我Windows和ubuntu上下载的wex5版本都是3.6:

mysql的jar包都是
mysql-connector-java-5.1.36-bin.jar
回复 支持 反对

使用道具 举报

10

主题

52

帖子

96

积分

初级会员

Rank: 2

积分
96
QQ
 楼主| 发表于 2017-4-9 19:44:35 | 显示全部楼层
本帖最后由 abc3240660 于 2017-4-9 20:13 编辑

目前已经解决了,是因为我把mysql的端口3306改成了3307,但是tomcat下的context.xml也需要改成3307才行。
目前ubuntu上的浏览器访问127.0.0.1:8080/acc已经成功,Windows上的浏览器访问http://192.168.11.138:8080/acc也能成功。

192.168.11.138是ubuntu虚拟机的IP

但是生成的手机APP运行后,提示访问http://192.168.11.138:8080/acc失败,有可能是手机和ubuntu间网络不同。手机上的浏览器直接访问http://192.168.11.138:8080/acc也不通。




回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|X3技术论坛|Justep Inc.    

GMT+8, 2024-5-5 13:19 , Processed in 0.087465 second(s), 26 queries .

Powered by Discuz! X3.4

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表