Issue Webmail and smtp not working

[waseem]

Hi,
i ran into an issue with my plesk
i am unable to open roundcube ang logs shows this line

[13-Sep-2016 09:32:42 +0500]: <pass> DB Error: [1932] Table 'roundcubemail.session' doesn't exist in engine (SQL Query: INSERT INTO `session` (`sess_id`, `vars`, `ip`, `created`, `changed`) VALUES ('rni1m6j70l4phkcnaosvh8gasg9d81', 'dGVtcHxiOjE7bGFuZ3asgsagasVhsagsagZ2V8casgasgzo1OiJlbl9VUyI7dGasgFzasag3xzOasgasgjU6ImxvZ2luIjtyZXasgF1ZXNga0X3Rvaasgas2VufHM6MzI6IjQzVmwzNasgUdyZGFZMGZMOUEzTlRtbjJVdVltYndnMXRDIjs=', '111.255.1.11', now(), now())) in /usr/share/psa-roundcube/program/lib/Roundcube/rcube_db.php on line 539 (GET /roundcube/index.php?_user=admin%40pshostpk.com)

any body know how to resolve it?
also my ports are not working so even not able to use any email client

when i use this command
telnet localhost 25
reply is

Trying 127.0.0.1...
Connected to hostname.
Escape character is '^]'.
220 hostname ESMTP Postfix (Ubuntu)

and it stuck there,

it should be check relay but it is not checking can any one explain these things???

Regards

 

[IgorG]

Looks like that Roundcube database roundcubemail is corrupted.

Try to create session table according to

# mysql -uadmin -p`cat /etc/psa/.psa.shadow` roundcubemail

mysql> show create table session\G
*************************** 1. row ***************************
Table: session
Create Table: CREATE TABLE `session` (
`sess_id` varchar(128) NOT NULL,
`created` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
`changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
`ip` varchar(40) NOT NULL,
`vars` mediumtext NOT NULL,
PRIMARY KEY (`sess_id`),
KEY `changed_index` (`changed`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
1 row in set (0.00 sec)

 

[waseem]

Hi as per command show create table session\G
reply is
ERROR 1932 (42S02): Table 'roundcubemail.session' doesn't exist in engine
What to do now???

 

[IgorG]

I have posted an example for existing session table. Use this "create" mysql command for creation missing session table. Contact Plesk Support Team if you are not familiar with SQL.

 

[waseem]

i pasted

mysql>
CREATE TABLE `session` (
`sess_id` varchar(128) NOT NULL,
`created` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
`changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
`ip` varchar(40) NOT NULL,
`vars` mediumtext NOT NULL,
PRIMARY KEY (`sess_id`),
KEY `changed_index` (`changed`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

and got errors in return that table session is already existed

 

[IgorG]

I hope that you did it for roundcubemail database?

 

[waseem]

yes i just replicate your steps