WeX5铛铛登录时报错

masits

我的开发环境是Mac，因为dangdang-server绿色安装包无法再Mac上运行，我就将dangdang-server部署在外网的NT服务器上，启动成功，在本地按照说明书配置好数据库，测试连接通过，当时铛铛登录时报错：

十一月 23, 2016 10:31:13 下午 org.apache.catalina.core.StandardWrapperValve invoke

严重: Servlet.service() for servlet WeX5_Baas_Servlet threw exception

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'x5sys.sa_opperson' doesn't exist

        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)

        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

        at java.lang.reflect.Constructor.newInstance(Constructor.java:526)

        at com.mysql.jdbc.Util.handleNewInstance(Util.java:400)

        at com.mysql.jdbc.Util.getInstance(Util.java:383)

        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980)

        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)

        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)

        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)

        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)

        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)

        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901)

        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2002)

        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)

        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)

        at com.justep.baas.data.DataUtils.queryData(Unknown Source)

        at com.justep.baas.action.CRUD.query(Unknown Source)

        at org.Login.login(Login.java:46)

        at org.Login__do.loginAction(Login__do.java:107)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

        at java.lang.reflect.Method.invoke(Method.java:606)

        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)

然后我在studio里用数据库访问该表，报错，无法访问：

liuhongjian

检查一下数据库配置信息是否正确

masits

没问题，测试连接OK，也可以显示表结构，就是在studio里打开数据库或select * from [table]会报错，网上说是因为数据库损坏，但是我是按照官方配置说明来copy data目录的

masits

我的WeX5版本是WeX5-V3.5 for mac

masits

因为我的dangdang-server是部署在另外一台机器上的，我运行的时候，好像获取token的时候拒绝访问：
2016-11-24 19:15:24 结束-中间文件生成缓存文件: /UI2/chat/wex5/index.w
发送GET请求出现异常！java.net.ConnectException: Connection refused
java.net.ConnectException: Connection refused
        at java.net.PlainSocketImpl.socketConnect(Native Method)
        at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
        at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
        at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
        at java.net.Socket.connect(Socket.java:579)
        at java.net.Socket.connect(Socket.java:528)
        at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
        at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
        at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
        at sun.net.www.http.HttpClient.<init>(HttpClient.java:211)
        at sun.net.www.http.HttpClient.New(HttpClient.java:308)
        at sun.net.www.http.HttpClient.New(HttpClient.java:326)
        at sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient(HttpURLConnection.java:996)
        at sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:932)
        at sun.net.www.protocol.http.HttpURLConnection.connect(HttpURLConnection.java:850)
        at org.Login.sendGet(Login.java:118)
        at org.Login.login(Login.java:56)
        at org.Login__do.loginAction(Login__do.java:107)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        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)