之前放在windows系统服务器下,能正常运行,现在平滑迁入Ubuntu服务器后无法登陆,提示" 登录失败,请检查您的成员名或密码是否填写正确。"实际用户名密码无错。
服务器使用的是AWS EC2,Ubuntu 14.04,nginx 1.7.9,php 5.6.4,数据库为AWS RDS,版本5.6.21。
1.4版本如此,在win服务器下正常升级后再次迁入ubuntu后亦如此。
数据连接:
<?php
$config->installed = true;
$config->debug = false;
$config->requestType = 'GET';
$config->db->host = 'xxx.rds.amazonaws.com';
$config->db->port = '3306';
$config->db->name = 'xxx.oa';
$config->db->user = 'xxx';
$config->db->password = 'xxx';
----
请帮忙解决,谢谢!
新年快乐!
linux下面会区分表名的大小写!!!!!!!!
问题出在这里!!!
开源事业的奋斗者们,你们辛苦了!
linux下面会区分表名的大小写。windows下面不区分,这个要检查下。
数据库的名字建议不要用带.的,可以将.改成下划线试试。
全新安装1.6版本时报错:
14:46:11 Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.`crm_address`' at line 1' in /xxx/o.xxx.com/app/sys/install/model.php:281
Stack trace:
#0 /xxx/o.xxx.com/app/sys/install/model.php(281): PDO->query(' DROP TABLE IF ...')
#1 /xxx/o.xxx.com/app/sys/install/model.php(171): installModel->createTable('5.6')
#2 /xxx/o.xxx.com/app/sys/install/control.php(83): installModel->checkConfig()
#3 [internal function]: install->step3()
#4 /xxx/o.xxx.com/framework/router.class.php(1267): call_user_func_array(Array, Array)
#5 /xxx/o.xxx.com/www/sys/install.php(37): router->loadModule()
#6 {main}
thrown in /xxx/o.xxx.com/app/sys/install/model.php on line 281 when visiting /sys/install.php?m=install&f=step3
打开debug后,报错如下:
03:53:07 ERROR: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'xxx.oa.sys_userGroup' doesn't exist
The sql is: SELECT module, method FROM `sys_userGroup` AS t1 LEFT JOIN `sys_groupPriv` AS t2 ON t1.group = t2.group wHeRe t1.account = 'xxx'
in /home/wwwroot/xxx/lib/dao/dao.class.php on line 498, last called by /home/wwwroot/xxx/app/sys/user/model.php on line 399 through function query.
in /home/wwwroot/xxx/framework/router.class.php on line 1695 when visiting /sys/index.php?m=user&f=login&referer=L3N5cy9pbmRleC5waHA=