垂直分库配置后，mycat start 无法启动

Question

启动日志
STATUS | wrapper | 2018/10/13 07:50:11 | --> Wrapper Started as Daemon
STATUS | wrapper | 2018/10/13 07:50:11 | Launching a JVM...
INFO | jvm 1 | 2018/10/13 07:50:12 | Wrapper (Version 3.2.3) http://wrapper.tanukisoftware.org
INFO | jvm 1 | 2018/10/13 07:50:12 | Copyright 1999-2006 Tanuki Software, Inc. All Rights Reserved.
INFO | jvm 1 | 2018/10/13 07:50:12 |
INFO | jvm 1 | 2018/10/13 07:50:13 |
INFO | jvm 1 | 2018/10/13 07:50:13 | WrapperSimpleApp: Encountered an error running main: java.lang.ExceptionInInitializerError
INFO | jvm 1 | 2018/10/13 07:50:13 | java.lang.ExceptionInInitializerError
INFO | jvm 1 | 2018/10/13 07:50:13 | at io.mycat.MycatStartup.main(MycatStartup.java:53)
INFO | jvm 1 | 2018/10/13 07:50:13 | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO | jvm 1 | 2018/10/13 07:50:13 | at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
INFO | jvm 1 | 2018/10/13 07:50:13 | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
INFO | jvm 1 | 2018/10/13 07:50:13 | at java.lang.reflect.Method.invoke(Method.java:606)
INFO | jvm 1 | 2018/10/13 07:50:13 | at org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:240)
INFO | jvm 1 | 2018/10/13 07:50:13 | at java.lang.Thread.run(Thread.java:745)
INFO | jvm 1 | 2018/10/13 07:50:13 | Caused by: io.mycat.config.util.ConfigException: SelfCheck### schema order_db refered by user app_imooc is not exist!
INFO | jvm 1 | 2018/10/13 07:50:13 | at io.mycat.config.ConfigInitializer.selfChecking0(ConfigInitializer.java:142)
INFO | jvm 1 | 2018/10/13 07:50:13 | at io.mycat.config.ConfigInitializer.<init>(ConfigInitializer.java:118)
INFO | jvm 1 | 2018/10/13 07:50:13 | at io.mycat.config.MycatConfig.<init>(MycatConfig.java:72)
INFO | jvm 1 | 2018/10/13 07:50:13 | at io.mycat.MycatServer.<init>(MycatServer.java:170)
INFO | jvm 1 | 2018/10/13 07:50:13 | at io.mycat.MycatServer.<clinit>(MycatServer.java:116)
INFO | jvm 1 | 2018/10/13 07:50:13 | ... 7 more
STATUS | wrapper | 2018/10/13 07:50:15 | <-- Wrapper Stopped
截图提示发布不了！

Answer 1

sqlercn 2018-10-16 14:56:35

从以上信息看可能是配置问题：schema order_db refered by user app_imooc is not exist!.看一下server.xml的配置中用户相关的配置是否正确。

• 提问者 不会飞的大树 #1

  检查一下，没发现问题呢！
   <user name="app_imooc" defaultAccount="true">
            <property name="password">bDbWr7bVMgszTe82oMo8NaUsmFFdPCNl/lYXzOYoG8anTpQLvdx5e+LYJEmT0IAeSVp1loyxSZPyv1GoHbHFHg==</property>
            <property name="schemas">order_db,product_db,customer_db</property>
  
          </user>

• sqlercn 回复 提问者 不会飞的大树 #2

  在schema.xml中配置了order_db,product_db,customer_db这些库吗？

• 提问者 不会飞的大树 回复 sqlercn #3

  已经配置了的
  <dataNode name="ordb" dataHost="mysql0103" database="order_db"/>
          <dataNode name="prodb" dataHost="mysql0104" database="product_db"/>
          <dataNode name="custdb" dataHost="mysql0101" database="customer_db"/>
  后面datahost也配置好了的

点开查看后面4条评论