迁移到新服务器，部分页面不显示数据

liangyongfei

你不会了解 发表于 2017-2-15 11:57
我用的是后来下载的mysql，没由用x5自带的mysql，是否会有问题+

数据库没有耦合！可以使用自己的！具体问题你还得自己调试找找！反正现在的效果是数据库中查不出数据！

你不会了解

liangyongfei 发表于 2017-2-15 12:05
数据库没有耦合！可以使用自己的！具体问题你还得自己调试找找！反正现在的效果是数据库中查不出数据！ ...

我现在改用自带的mysql，启动startMySQL.sh 报Warning: World-writable config file '/usr/oristartech/x5/mysql/my.ini' is ignored怎么解决

liangyongfei

你不会了解 发表于 2017-2-15 17:40
我现在改用自带的mysql，启动startMySQL.sh 报Warning: World-writable config file '/usr/oristartech/x ...

权限问题，上网搜下吧
http://www.ttlsa.com/mysql/warni ... cmy-cnf-is-ignored/

你不会了解

liangyongfei 发表于 2017-2-15 17:42
权限问题，上网搜下吧
http://www.ttlsa.com/mysql/warning-world-writable-config-file-etcmy-cnf-is-ig ...

我使用了普通用户启动报错
Warning: World-writable config file '/usr/oristartech/x5/mysql/my.ini' is ignored
170216  9:32:03 [Warning] option 'thread_stack': unsigned value 126976 adjusted to 131072
170216  9:32:03 [Warning] Can't create test file /usr/oristartech/x5/mysql/data/PCP_Server.lower-test
170216  9:32:03 [Warning] Can't create test file /usr/oristartech/x5/mysql/data/PCP_Server.lower-test
170216  9:32:03  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.

你不会了解

你不会了解 发表于 2017-2-16 09:36
我使用了普通用户启动报错
Warning: World-writable config file '/usr/oristartech/x5/mysql/my.ini' is ...

170216  9:59:21 [Warning] option 'thread_stack': unsigned value 126976 adjusted to 131072
170216  9:59:21 [Warning] Can't create test file /usr/oristartech/x5/mysql/data/PCP_Server.lower-test
170216  9:59:21 [Warning] Can't create test file /usr/oristartech/x5/mysql/data/PCP_Server.lower-test
mysqld: File './mysql-bin.index' not found (Errcode: 13)
170216  9:59:21 [ERROR] Aborting

170216  9:59:21 [Note] mysqld: Shutdown complete

liangyongfei

你不会了解 发表于 2017-2-16 09:59
170216  9:59:21 [Warning] option 'thread_stack': unsigned value 126976 adjusted to 131072
170216   ...

可以将文件设置为可执行权限试试，我都说了！上网、搜下报错信息就可以了！

你不会了解

liangyongfei 发表于 2017-2-16 11:29
可以将文件设置为可执行权限试试，我都说了！上网、搜下报错信息就可以了！ ...

170217 10:26:20 [Warning] option 'thread_stack': unsigned value 126976 adjusted to 131072
170217 10:26:20  InnoDB: Started; log sequence number 0 185708979
170217 10:26:20 [Note] mysqld: ready for connections.
Version: '5.0.67-log'  socket: '/tmp/mysql.sock'  port: 3306  MySQL Community Server (GPL)

你不会了解

你不会了解 发表于 2017-2-17 10:27
170217 10:26:20 [Warning] option 'thread_stack': unsigned value 126976 adjusted to 131072
170217 1 ...

http://bbs.wex5.com/forum.php?mo ... signed%2Bvalue%2B12
有人说这是启动成功，为什么我还是访问不了数据库

liangyongfei

你不会了解 发表于 2017-2-17 10:31
http://bbs.wex5.com/forum.php?mo ... signed%2Bvalue%2B12
有人说这是启动成功，为什么我还是访问不了数 ...

配置数据源测试连接下
http://docs.wex5.com/wex5-studio-question-list-2010/

不能连接成功吗？？数据库中有表吧！

你不会了解

liangyongfei 发表于 2017-2-17 10:57
配置数据源测试连接下
http://docs.wex5.com/wex5-studio-question-list-2010/

额，这个是服务器，studio打不开，
这是我测的
[root@PCP_Server /]# pidof mysqld
1703