1 Topic by robert.wolfe

  • robert.wolfe
  • Member
  • Offline
  • Registered: 2015-03-03
  • Posts: 37

Topic: Table 'sogo.sogo_sessions_folder' doesn't exist

==== Required information ====
- iRedMail version: Latest
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Linux/BSD distribution name and version: Debian - Latest AMD64
- Related log if you're reporting an issue:

2015-03-02 13:49:01.588 sogo-tool[4986] Table 'sogo.sogo_sessions_folder' doesn't exist
/usr/sbin/sogo-tool: Uncaught exception ExecutionFailed, reason: Table 'sogo.sogo_sessions_folder' doesn't exist
====

I am seeing this error repeatedly from crond in my postmaster@ email:

2015-03-02 13:49:01.588 sogo-tool[4986] Table 'sogo.sogo_sessions_folder' doesn't exist
/usr/sbin/sogo-tool: Uncaught exception ExecutionFailed, reason: Table 'sogo.sogo_sessions_folder' doesn't exist

Does anyone know if there is a fix to resolve this issue and to keep this from happening?

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by robert.wolfe

  • robert.wolfe
  • Member
  • Offline
  • Registered: 2015-03-03
  • Posts: 37

Re: Table 'sogo.sogo_sessions_folder' doesn't exist

I am also getting the following errors as well:

<0x0x1f909b0[GCSAlarmsFolder]> -[GCSAlarmsFolder recordsForEntriesFromDate:toDate:]: cannot execute fetch: <MySQL4Exception: 0x1f0c160> NAME:ExecutionFailed REASON:Table 'sogo.sogo_alarms_folder' doesn't exist
<0x0x1e37040[GCSAlarmsFolder]> -[GCSAlarmsFolder deleteRecordsForEntriesUntilDate:]: cannot delete record: <MySQL4Exception: 0x1defbc0> NAME:ExecutionFailed REASON:Table 'sogo.sogo_alarms_folder' doesn't exist

3 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,788

Re: Table 'sogo.sogo_sessions_folder' doesn't exist

This should happen right after iRedMail installation, because iRedMail installed and configured SOGo, but didn't start it before you reboot server. iRedMail also added cron job for SOGo, but SOGo was not running before, so it (SOGo) didn't create required SQL tables, this causes above errors reported by cron job.

So, the question is, does it happen regularly, or just once right after iRedMail installation?

4 Reply by ink0gnito (edited by ink0gnito 2015-03-25 18:16:46)

  • ink0gnito
  • Member
  • Offline
  • Registered: 2015-03-25
  • Posts: 3

Re: Table 'sogo.sogo_sessions_folder' doesn't exist

I have the same problem after fresh install. I also reboot the server, but the problem "Table 'sogo.sogo_sessions_folder' doesn't exist"and "Table 'sogo.sogo_alarms_folder' doesn't exist" is still there.

- iRedMail version: Latest
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Linux/BSD distribution name and version: Debian - Latest AMD64

5 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,788

Re: Table 'sogo.sogo_sessions_folder' doesn't exist

Does it occur after you restarted sogo service?

6 Reply by ink0gnito

  • ink0gnito
  • Member
  • Offline
  • Registered: 2015-03-25
  • Posts: 3

Re: Table 'sogo.sogo_sessions_folder' doesn't exist

Thank you, after i restarted sogo (service sogo restart) the tables were generated.

Iredmail ist very good, but I am very interested for the free 10 user edition (iredadmin pro). I hope she comes back soon.

Thank you