Topic: Issue with access to SoGo after clear installation in version 9.9
==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release):
root@mail:~# cat /etc/iredmail-release
0.9.9 MARIADB edition.
- Deployed with iRedMail Easy or the downloadable installer?
via downloadable installer
- Linux/BSD distribution name and version:
root@mail:~# cat /etc/debian_version
9.9
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):
MySQL
- Web server (Apache or Nginx):
Nginx
- Manage mail accounts with iRedAdmin-Pro?
no
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====
Hi,
I was performed migration to new server, on old and on new i has version 9.9
On new I was selected installation with componnet SoGo.
I was migration using this scenario:
https://docs.iredmail.org/migrate.to.ne … erver.html
After that evrything working properly, without SoGo. I cant login https://ip/SoGo I got application website but when I will put credential which are working in roundcube, and on SoGO I got error.
in log file /var/log/sogo/sogo.log i have this information:
Oct 24 03:30:06 sogod [1374]: [ERROR] <0x0x562899b73c70[SQLSource]> could not run SQL 'c_uid = 'xxxx@xxxxx'': <MySQL4Exception: 0x562899b14d40> NAME:ExecutionFailed REASON:View 'sogo.users' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Oct 24 03:30:06 sogod [1374]: SOGoRootPage Login from 'x.x.x.x' for user 'xxxx@xxxx' might not have worked - password policy: 65535 grace: -1 expire: -1 bound: 0
Oct 24 03:30:06 sogod [1374]: x.x.x.x "POST /SOGo/connect HTTP/1.0" 403 34/81 0.076 - - 0
Oct 24 03:30:36 sogod [1374]: [ERROR] <0x0x562899b73c70[SQLSource]> could not run SQL 'c_uid = 'xxxx@xxxx'': <MySQL4Exception: 0x562899af6100> NAME:ExecutionFailed REASON:View 'sogo.users' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Oct 24 03:30:36 sogod [1374]: SOGoRootPage Login from 'x.x.x.x' for user 'xxxx@xxxx' might not have worked - password policy: 65535 grace: -1 expire: -1 bound: 0
Oct 24 03:30:36 sogod [1374]: x.x.x.x "POST /SOGo/connect HTTP/1.0" 403 34/81 0.003 - - 0
Oct 24 03:30:53 sogod [1374]: [ERROR] <0x0x562899b73c70[SQLSource]> could not run SQL 'c_uid = 'yyyy@xxxx'': <MySQL4Exception: 0x562899886910> NAME:ExecutionFailed REASON:View 'sogo.users' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Oct 24 03:30:53 sogod [1374]: SOGoRootPage Login from 'x.x.x.x' for user 'yyyy@xxxx' might not have worked - password policy: 65535 grace: -1 expire: -1 bound: 0
Oct 24 03:30:53 sogod [1374]: x.x.x.x "POST /SOGo/connect HTTP/1.0" 403 34/76 0.004 - - 0
Oct 24 03:31:09 sogod [1374]: [ERROR] <0x0x562899b73c70[SQLSource]> could not run SQL 'c_uid = 'postmaster@xxxx'': <MySQL4Exception: 0x562899ad81b0> NAME:ExecutionFailed REASON:View 'sogo.users' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Oct 24 03:31:09 sogod [1374]: SOGoRootPage Login from 'x.x.x.x' for user 'postmaster@xxxx' might not have worked - password policy: 65535 grace: -1 expire: -1 bound: 0
Oct 24 03:31:09 sogod [1374]: x.x.x.x "POST /SOGo/connect HTTP/1.0" 403 34/81 0.004 - - 0
Waiting for data... (interrupt to abort)when Im trying to check what is in tables users in sogo db i got this :
Database changed
MariaDB [sogo]> show tables;
+------------------------+
| Tables_in_sogo |
+------------------------+
| sogo_acl |
| sogo_alarms_folder |
| sogo_cache_folder |
| sogo_folder_info |
| sogo_quick_appointment |
| sogo_quick_contact |
| sogo_sessions_folder |
| sogo_store |
| sogo_user_profile |
| users |
+------------------------+
10 rows in set (0.00 sec)
MariaDB [sogo]> select * from users;
ERROR 1356 (HY000): View 'sogo.users' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use themreally thanks for help.
----
Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.