已解决请删帖

beizi

已解决请删帖

启蒙星

mysql什么版本，表没有创建成功应该还有其他错误的，你的o2oa用户有数据库的管理员权限吗

beizi

启蒙星 发表于 2022-5-6 13:53
mysql什么版本，表没有创建成功应该还有其他错误的，你的o2oa用户有数据库的管理员权限吗 ...

mysql 8.0.28  用户用的是xadmin

beizi

启蒙星 发表于 2022-5-6 13:53
mysql什么版本，表没有创建成功应该还有其他错误的，你的o2oa用户有数据库的管理员权限吗 ...

可否提供表 我手动创建导入

启蒙星

我说的是连接数据库的用户有没有管理员权限，我看你配置的用户是o2oa，o2启动过程中有什么报错没

beizi

启蒙星 发表于 2022-5-7 11:05
我说的是连接数据库的用户有没有管理员权限，我看你配置的用户是o2oa，o2启动过程中有什么报错没 ...

有权限的 用的是root 启动过程中没有报错
                                       
                                       
    @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@   
    @@@                          @@@   
    @@@                          @@@   
    @@@@@@@@@@@@@@@@@@@@@@@@@@   @@@   
                           @@@   @@@   
                           @@@   @@@   
    @@@   @@@@@@@@@@#      @@@   @@@   
    @@@           @@@      @@@   @@@   
    @@@           @@@      @@@   @@@   
    @@@   @@@@@@@@@@#      @@@   @@@   
    @@@   @@@              @@@   @@@   
    @@@   @@@              @@@   @@@   
    @@@   @@@@@@@@@@@@@@@@@@@@   @@@   
    @@@                          @@@   
    @@@                          @@@   
    @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@   
                                       
                                       
>>> server directory:/o2server
>>> version:7.1
>>> java:11.0.10
>>> osinux
>>> nodeAgent port:20010, encrypt:true
help                                   show usage message.
start|stop [all]                       start stop all enable server.
start|stop data                        start stop data server.
start|stop storage                     start stop storage server.
start|stop center                      start stop center server.
start|stop application                 start stop application server.
start|stop web                         start stop web server.
setPassword (oldpasswd) (newpasswd)    change initial manager password.
create encrypt key                     create random RSA key.
version                                show available update version.
exit                                   exit after stop.
ctl -<argument> option                 system control command, no argument display help.

****************************************
* storage server start completed.
* port: 20040.
****************************************
com.x.base.core.project.x_program_center loading datas, entity size:27.
2022-05-07 17:50:15.190 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.base.core.project.cache.CacheGuavaNotifyReceiveQueue start.
2022-05-07 17:50:15.191 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.program.center.CenterQueue start.
2022-05-07 17:50:15.196 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.program.center.LogQueue start.
****************************************
* center server start completed.
* port: 20030.
****************************************
2022-05-07 17:50:16.795 [main] INFO com.x.server.console.server.application.ApplicationServerTools - start to deploy official module: 25, custom module: 0.
2022-05-07 17:50:17.464 [main] INFO com.x.base.core.project.Context - com.x.base.core.project.x_query_service_processing loading datas, entity size:24.
2022-05-07 17:50:18.310 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.base.core.project.cache.CacheGuavaNotifyReceiveQueue start.
2022-05-07 17:50:19.011 [main] INFO com.x.base.core.project.Context - com.x.base.core.project.x_calendar_assemble_control loading datas, entity size:6.
2022-05-07 17:50:19.293 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.base.core.project.cache.CacheGuavaNotifyReceiveQueue start.
2022-05-07 17:50:20.684 [main] INFO com.x.base.core.project.Context - com.x.base.core.project.x_attendance_assemble_control loading datas, entity size:28.
2022-05-07 17:50:21.072 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.base.core.project.cache.CacheGuavaNotifyReceiveQueue start.
2022-05-07 17:50:21.448 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.attendance.assemble.control.QueuePersonAttendanceDetailAnalyse start.
2022-05-07 17:50:21.449 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.attendance.assemble.control.QueueAttendanceDetailStatistic start.
2022-05-07 17:50:23.135 [main] INFO com.x.base.core.project.Context - com.x.base.core.project.x_processplatform_service_processing loading datas, entity size:45.
2022-05-07 17:50:23.703 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.base.core.project.cache.CacheGuavaNotifyReceiveQueue start.
2022-05-07 17:50:23.708 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.processplatform.service.processing.processor.invoke.SyncJaxrsInvokeQueue start.
2022-05-07 17:50:23.709 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.processplatform.service.processing.processor.invoke.SyncJaxwsInvokeQueue start.
2022-05-07 17:50:23.711 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.processplatform.service.processing.UpdateTableQueue start.
2022-05-07 17:50:23.713 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.processplatform.service.processing.ArchiveHadoopQueue start.
2022-05-07 17:50:25.007 [main] INFO com.x.base.core.project.Context - com.x.base.core.project.x_bbs_assemble_control loading datas, entity size:17.
2022-05-07 17:50:25.327 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.base.core.project.cache.CacheGuavaNotifyReceiveQueue start.
2022-05-07 17:50:26.161 [ContextQuartzScheduler-x_program_center_Worker-2] INFO com.x.program.center.schedule.CollectMarket - start sync market data.
2022-05-07 17:50:26.294 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.bbs.assemble.control.queue.QueueNewReplyNotify start.
2022-05-07 17:50:26.294 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.bbs.assemble.control.queue.QueueNewSubjectNotify start.
2022-05-07 17:50:26.294 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.bbs.assemble.control.queue.NickNameConsumeQueue start.
2022-05-07 17:50:27.433 [main] INFO com.x.base.core.project.Context - com.x.base.core.project.x_portal_assemble_designer loading datas, entity size:8.
2022-05-07 17:50:27.640 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.base.core.project.cache.CacheGuavaNotifyReceiveQueue start.
2022-05-07 17:50:28.058 [main] INFO com.x.base.core.project.Context - com.x.base.core.project.x_portal_assemble_surface loading datas, entity size:7.
2022-05-07 17:50:28.343 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.base.core.project.cache.CacheGuavaNotifyReceiveQueue start.
2022-05-07 17:50:29.127 [main] INFO com.x.base.core.project.Context - com.x.base.core.project.x_query_assemble_designer loading datas, entity size:31.
2022-05-07 17:50:29.998 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.base.core.project.cache.CacheGuavaNotifyReceiveQueue start.
2022-05-07 17:50:30.972 [main] INFO com.x.base.core.project.Context - com.x.base.core.project.x_message_assemble_communicate loading datas, entity size:9.
2022-05-07 17:50:31.304 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.base.core.project.cache.CacheGuavaNotifyReceiveQueue start.
2022-05-07 17:50:31.306 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.message.assemble.communicate.KafkaConsumeQueue start.
2022-05-07 17:50:31.306 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.message.assemble.communicate.ActivemqConsumeQueue start.
2022-05-07 17:50:31.306 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.message.assemble.communicate.RestfulConsumeQueue start.
2022-05-07 17:50:31.307 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.message.assemble.communicate.ApiConsumeQueue start.
2022-05-07 17:50:31.307 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.message.assemble.communicate.MailConsumeQueue start.
2022-05-07 17:50:31.307 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.message.assemble.communicate.JdbcConsumeQueue start.
2022-05-07 17:50:31.307 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.message.assemble.communicate.TableConsumeQueue start.
2022-05-07 17:50:31.307 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.message.assemble.communicate.HadoopConsumeQueue start.
2022-05-07 17:50:31.313 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.message.assemble.communicate.PmsinnerConsumeQueue start.
2022-05-07 17:50:31.314 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.message.assemble.communicate.WsConsumeQueue start.
2022-05-07 17:50:31.314 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.message.assemble.communicate.CalendarConsumeQueue start.
2022-05-07 17:50:31.634 [ContextQuartzScheduler-x_program_center_Worker-2] INFO com.x.program.center.schedule.CollectMarket - wait sync market app size：44
2022-05-07 17:50:31.764 [ContextQuartzScheduler-x_program_center_Worker-2] INFO com.x.program.center.schedule.CollectMarket - end sync market data.
2022-05-07 17:50:32.299 [main] INFO com.x.base.core.project.Context - com.x.base.core.project.x_file_assemble_control loading datas, entity size:9.
2022-05-07 17:50:32.488 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.base.core.project.cache.CacheGuavaNotifyReceiveQueue start.
2022-05-07 17:50:32.494 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.file.assemble.control.jaxrs.file.FileRemoveQueue start.
2022-05-07 17:50:34.354 [main] INFO com.x.base.core.project.Context - com.x.base.core.project.x_cms_assemble_control loading datas, entity size:31.
2022-05-07 17:50:34.716 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.base.core.project.cache.CacheGuavaNotifyReceiveQueue start.
2022-05-07 17:50:34.718 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.cms.assemble.control.queue.QueueBatchOperation start.
2022-05-07 17:50:34.720 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.cms.assemble.control.queue.QueueDocumentDelete start.
2022-05-07 17:50:34.721 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.cms.assemble.control.queue.QueueDataRowImport start.
2022-05-07 17:50:34.721 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.cms.assemble.control.queue.QueueDocumentUpdate start.
2022-05-07 17:50:34.725 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.cms.assemble.control.queue.QueueDocumentViewCountUpdate start.
2022-05-07 17:50:34.730 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.cms.assemble.control.queue.QueueSendDocumentNotify start.
2022-05-07 17:50:34.731 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.cms.assemble.control.queue.ProjectionExecuteQueue start.
2022-05-07 17:50:35.605 [main] INFO com.x.base.core.project.Context - com.x.base.core.project.x_query_assemble_surface loading datas, entity size:45.
2022-05-07 17:50:36.305 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.base.core.project.cache.CacheGuavaNotifyReceiveQueue start.
2022-05-07 17:50:36.306 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.query.assemble.surface.queue.QueueImportData start.
2022-05-07 17:50:40.305 [main] INFO com.x.base.core.project.Context - com.x.base.core.project.x_processplatform_assemble_surface loading datas, entity size:47.
2022-05-07 17:50:40.742 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.base.core.project.cache.CacheGuavaNotifyReceiveQueue start.
2022-05-07 17:50:41.565 [main] INFO com.x.base.core.project.Context - com.x.base.core.project.x_jpush_assemble_control loading datas, entity size:2.
2022-05-07 17:50:41.720 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.base.core.project.cache.CacheGuavaNotifyReceiveQueue start.
2022-05-07 17:50:42.678 [main] INFO com.x.base.core.project.Context - com.x.base.core.project.x_organization_assemble_control loading datas, entity size:12.
2022-05-07 17:50:42.872 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.base.core.project.cache.CacheGuavaNotifyReceiveQueue start.
2022-05-07 17:50:43.545 [main] INFO com.x.base.core.project.Context - com.x.base.core.project.x_organization_assemble_personal loading datas, entity size:12.
2022-05-07 17:50:43.814 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.base.core.project.cache.CacheGuavaNotifyReceiveQueue start.
2022-05-07 17:50:43.815 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.organization.assemble.personal.jaxrs.exmail.QueueUpdateExmail start.
2022-05-07 17:50:44.160 [main] INFO com.x.base.core.project.Context - com.x.base.core.project.x_mind_assemble_control loading datas, entity size:8.
2022-05-07 17:50:44.338 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.base.core.project.cache.CacheGuavaNotifyReceiveQueue start.
2022-05-07 17:50:44.342 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.mind.assemble.control.queue.QueueShareNotify start.
2022-05-07 17:50:44.620 [main] INFO com.x.base.core.project.Context - com.x.base.core.project.x_processplatform_assemble_bam loading datas, entity size:32.
2022-05-07 17:50:44.967 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.base.core.project.cache.CacheGuavaNotifyReceiveQueue start.
2022-05-07 17:50:45.601 [main] INFO com.x.base.core.project.Context - com.x.base.core.project.x_processplatform_assemble_designer loading datas, entity size:47.
2022-05-07 17:50:46.024 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.base.core.project.cache.CacheGuavaNotifyReceiveQueue start.
2022-05-07 17:50:46.029 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.processplatform.assemble.designer.ProjectionExecuteQueue start.
2022-05-07 17:50:46.029 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.processplatform.assemble.designer.MappingExecuteQueue start.
2022-05-07 17:50:46.030 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.processplatform.assemble.designer.FormVersionQueue start.
2022-05-07 17:50:46.030 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.processplatform.assemble.designer.ProcessVersionQueue start.
2022-05-07 17:50:46.031 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.processplatform.assemble.designer.ScriptVersionQueue start.
2022-05-07 17:50:46.396 [main] INFO com.x.base.core.project.Context - com.x.base.core.project.x_component_assemble_control loading datas, entity size:1.
2022-05-07 17:50:46.528 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.base.core.project.cache.CacheGuavaNotifyReceiveQueue start.
2022-05-07 17:50:46.753 [main] INFO com.x.base.core.project.Context - com.x.base.core.project.x_hotpic_assemble_control loading datas, entity size:3.
2022-05-07 17:50:46.912 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.base.core.project.cache.CacheGuavaNotifyReceiveQueue start.
2022-05-07 17:50:46.912 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.hotpic.assemble.control.queueTask.DocumentExistsCheckTask start.
2022-05-07 17:50:47.376 [main] INFO com.x.base.core.project.Context - com.x.base.core.project.x_organization_assemble_authentication loading datas, entity size:6.
2022-05-07 17:50:47.545 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.base.core.project.cache.CacheGuavaNotifyReceiveQueue start.
2022-05-07 17:50:47.545 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.organization.assemble.authentication.jaxrs.authentication.QueueLoginRecord start.
2022-05-07 17:50:48.087 [main] INFO com.x.base.core.project.Context - com.x.base.core.project.x_meeting_assemble_control loading datas, entity size:4.
2022-05-07 17:50:48.253 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.base.core.project.cache.CacheGuavaNotifyReceiveQueue start.
2022-05-07 17:50:49.225 [main] INFO com.x.base.core.project.Context - com.x.base.core.project.x_organization_assemble_express loading datas, entity size:10.
2022-05-07 17:50:49.415 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.base.core.project.cache.CacheGuavaNotifyReceiveQueue start.
2022-05-07 17:50:49.756 [main] INFO com.x.base.core.project.Context - com.x.base.core.project.x_general_assemble_control loading datas, entity size:3.
2022-05-07 17:50:49.909 [main] INFO com.x.base.core.project.queue.AbstractQueue - queue class: com.x.base.core.project.cache.CacheGuavaNotifyReceiveQueue start.
****************************************
* application server start completed.
* port: 20020.
****************************************
****************************************
* web server start completed.
* port: 80.
****************************************

beizi

启蒙星 发表于 2022-5-7 11:05
我说的是连接数据库的用户有没有管理员权限，我看你配置的用户是o2oa，o2启动过程中有什么报错没 ...

就在刚才我重启服务 重启后可以进去了 表也有了 可能是更换数据库第一次自动创建表没有建全

论坛管理员

可能是