1 (edited by 3m 2016-04-07 19:03:29)

Topic: Cron <sogod@test> /usr/local/GNUstep/Local/Tools/Admin/sogo-tool expir

======== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.4  zhb-iredmail-01b38c1dcf1e
- Linux/BSD distribution name and version: FreeBSD 10.3
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx):Apache
- Manage mail accounts with iRedAdmin-Pro? no
- Related log if you're reporting an issue:
====
Hi! Every minute get messages

2016-04-07 05:12:00.319 sogo-tool[1990:100180] Table 'sogo.sogo_sessions_folder' doesn't exist
Abort trap
Apr 07 05:12:00 sogo-ealarms-notify [1989]: [ERROR] <0x0x2c431188[GCSAlarmsFolder]> -[GCSAlarmsFolder recordsForEntriesFromDate:toDate:]: cannot execute fetch: <MySQL4Exception: 0x2c444268> NAME:ExecutionFailed REASON:Table 'sogo.sogo_alarms_folder' doesn't exist
Apr 07 05:12:00 sogo-ealarms-notify [1989]: [ERROR] <0x0x2c5737f8[GCSAlarmsFolder]> -[GCSAlarmsFolder deleteRecordsForEntriesUntilDate:]: cannot delete record: <MySQL4Exception: 0x2c444aa8> NAME:ExecutionFailed REASON:Table 'sogo.sogo_alarms_folder' doesn't exist

sogo.log

Apr 07 06:02:53 sogod [702]: [ERROR] <0x0x2626ad88[SOGoSQLUserProfile]> could not run SQL 'SELECT c_settings FROM sogo_user_profile WHERE c_uid = 'postmaster@test.km'': <MySQL4Exception: 0x2626b9a8> NAME:ExecutionFailed REASON:Table 'sogo.sogo_user_profile' doesn't exist
Apr 07 06:02:54 sogod [702]: [ERROR] <0x2612AB48[SOGoContactFolders]:Contacts> a database error occured: Table 'sogo.sogo_folder_info' doesn't exist
Apr 07 06:02:55 sogod [702]: 192.168.1.4 "POST /SOGo/so/postmaster@test.km/Mail/0/folderDrafts/newDraft1460023351-1/save HTTP/1.1" 200 341/2561 1.584 - - -
Apr 07 06:02:58 sogod [702]: [ERROR] <0x0x2612f268[SOGoSQLUserProfile]> could not run SQL 'SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'postmaster@test.km'': <MySQL4Exception: 0x2613e668> NAME:ExecutionFailed REASON:Table 'sogo.sogo_user_profile' doesn't exist
Apr 07 06:02:58 sogod [702]: [ERROR] <0x0x262691c8[SOGoSQLUserProfile]> could not run SQL 'SELECT c_settings FROM sogo_user_profile WHERE c_uid = 'postmaster@test.km'': <MySQL4Exception: 0x2626a6a8> NAME:ExecutionFailed REASON:Table 'sogo.sogo_user_profile' doesn't exist
Apr 07 06:02:59 sogod [702]: 192.168.1.4 "GET /SOGo/so/postmaster@test.km/Mail/0/folderDrafts/1/2/attachments HTTP/1.1" 200 187222/0 1.469 - - -
Apr 07 06:03:24 sogod [702]: [ERROR] <0x0x2612f268[SOGoSQLUserProfile]> could not run SQL 'SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'postmaster@test.km'': <MySQL4Exception: 0x2613e668> NAME:ExecutionFailed REASON:Table 'sogo.sogo_user_profile' doesn't exist
Apr 07 06:03:24 sogod [702]: [ERROR] <0x0x2625cd68[SOGoSQLUserProfile]> could not run SQL 'SELECT c_settings FROM sogo_user_profile WHERE c_uid = 'postmaster@test.km'': <MySQL4Exception: 0x2626a368> NAME:ExecutionFailed REASON:Table 'sogo.sogo_user_profile' doesn't exist
Apr 07 06:03:25 sogod [702]: 192.168.1.4 "POST /SOGo/so/postmaster@test.km/Mail/0/folderINBOX/uids HTTP/1.1" 200 527/53 1.237 - - -
Apr 07 06:03:25 sogod [702]: [ERROR] <0x0x2612efc8[SOGoSQLUserProfile]> could not run SQL 'SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'postmaster@test.km'': <MySQL4Exception: 0x2613e668> NAME:ExecutionFailed REASON:Table 'sogo.sogo_user_profile' doesn't exist
Apr 07 06:03:25 sogod [702]: [ERROR] <0x0x262691c8[SOGoSQLUserProfile]> could not run SQL 'SELECT c_settings FROM sogo_user_profile WHERE c_uid = 'postmaster@test.km'': <MySQL4Exception: 0x2626a188> NAME:ExecutionFailed REASON:Table 'sogo.sogo_user_profile' doesn't exist
Apr 07 06:03:27 sogod [702]: 192.168.1.4 "POST /SOGo/so/postmaster@test.km/Mail/0/folderINBOX/headers HTTP/1.1" 200 505/20 1.235 1598 68% -
Apr 07 06:06:14 sogod [702]: [ERROR] <0x0x2623c8c8[GCSSessionsFolder]> -[GCSSessionsFolder recordForEntryWithID:]: cannot execute fetch: <MySQL4Exception: 0x258b1de8> NAME:Execut

----

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

2

Re: Cron <sogod@test> /usr/local/GNUstep/Local/Tools/Admin/sogo-tool expir

Restart SOGo service please, sogo will create required sql tables automatically.