Hi, I have been trying to install ISPConfig3 on a CentOS 6.4 server but when i try and access the ISPConfig managment it produces this error in firefox Code: <!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN"> <html><head> <title>400 Bad Request</title> </head><body> <h1>Bad Request</h1> <p>Your browser sent a request that this server could not understand.<br /> Reason: You're speaking plain HTTP to an SSL-enabled server port.<br /> Instead use the HTTPS scheme to access this URL, please.<br /> <blockquote>Hint: <a href="https://webwax.audiofactor.net:8080/"><b>https://webwax.audiofactor.net:8080/</b></a></blockquote></p> </body></html> I have tried disabling SSL when running the ISPConfig installer and tried accessing the management page but this does not work I have tried running the management on a different port this also does not display the login screen apache is running but it wont let me access the ISPConfig management page any ideas on how to solve this problem? Thanks Haz
Update Ive just tried accessing it through safari webbrowser and its showing abit of the login page with some what apears to be mysql errors Code: #0 db->query(SELECT * FROM sys_session WHERE session_id = 'ld0uoabfphjb3ok63m5cv3kam5') called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:172] #1 db->queryOneRecord(SELECT * FROM sys_session WHERE session_id = 'ld0uoabfphjb3ok63m5cv3kam5') called at [/usr/local/ispconfig/interface/lib/classes/session.inc.php:55] #2 session->read(ld0uoabfphjb3ok63m5cv3kam5) #3 session_start() called at [/usr/local/ispconfig/interface/lib/app.inc.php:76] #4 app->__construct() called at [/usr/local/ispconfig/interface/lib/app.inc.php:275] #5 require_once(/usr/local/ispconfig/interface/lib/app.inc.php) called at [/usr/local/ispconfig/interface/web/index.php:32] #0 db->query(SELECT config FROM sys_ini WHERE sysini_id = 1) called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:172] #1 db->queryOneRecord(SELECT config FROM sys_ini WHERE sysini_id = 1) called at [/usr/local/ispconfig/interface/lib/classes/getconf.inc.php:52] #2 getconf->get_global_config(misc) called at [/usr/local/ispconfig/interface/web/index.php:42] Skip to the navigation.Skip to the content. hosting control panel Powered by ISPConfig #0 db->query(INSERT INTO sys_session (session_id,date_created,last_updated,session_data) VALUES ('ld0uoabfphjb3ok63m5cv3kam5','2013-09-06 17:32:21','2013-09-06 17:32:21','s|a:4:{s:2:\"id\";s:26:\"ld0uoabfphjb3ok63m5cv3kam5\";s:5:\"theme\";s:7:\"default\";s:8:\"language\";s:2:\"en\";s:6:\"module\";a:1:{s:4:\"name\";s:5:\"login\";}}')) called at [/usr/local/ispconfig/interface/lib/classes/session.inc.php:86] #1 session->write(ld0uoabfphjb3ok63m5cv3kam5, s|a:4:{s:2:"id";s:26:"ld0uoabfphjb3ok63m5cv3kam5";s:5:"theme";s:7:"default";s:8:"language";s:2:"en";s:6:"module";a:1:{s:4:"name";s:5:"login";}}) #2 session_write_close() called at [/usr/local/ispconfig/interface/lib/app.inc.php:89] #3 app->__destruct()
Code: #0 db->query(SELECT * FROM sys_session WHERE session_id = '7plefgd6dnn984h8ajlptp0310') called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:172] #1 db->queryOneRecord(SELECT * FROM sys_session WHERE session_id = '7plefgd6dnn984h8ajlptp0310') called at [/usr/local/ispconfig/interface/lib/classes/session.inc.php:55] #2 session->read(7plefgd6dnn984h8ajlptp0310) #3 session_start() called at [/usr/local/ispconfig/interface/lib/app.inc.php:76] #4 app->__construct() called at [/usr/local/ispconfig/interface/lib/app.inc.php:275] #5 require_once(/usr/local/ispconfig/interface/lib/app.inc.php) called at [/usr/local/ispconfig/interface/web/index.php:32] ... I have the same problem with the error messages after updating ispconfig. Did you find a solution? Code: dbispconfig.sys_session repair Error File './dbispconfig/sys_session.MYD' not found (Errcode: 2) dbispconfig.sys_session repair Error Can't find file: 'sys_session' (errno: 2) dbispconfig.sys_session repair error Corrupt For me it turns out, that the "sys_session"-table is corrupt - does anybody know how to fix it? Or how I can force ispconfig to reecreate it? Thanks, Hackbard_C
For the sake of completeness, I got help at the german version of this forum. Just drop the sys_session table by hand and recreate it. Code: CREATE TABLE `sys_session` ( `session_id` varchar(64) NOT NULL DEFAULT '', `date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `last_updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `session_data` longtext, PRIMARY KEY (`session_id`), KEY `last_updated` (`last_updated`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
