Page MenuHomePhorge
Create Task
Maniphest T2103

Can't get Chwala working after an upgrade.
Closed, InvalidPublic
Actions

Description

pykolab-0.8.7-1.1.el7.kolab_16.noarch

I ran yum upgrade and many things broke and I was afraid greatly! Then I watched the chatter coming from the logs and resolved most of my issues as most was permission based.... Except Chwala. I can't make chwala work.

chown mysql /var/run/mariadb
chown -R nobody.nobody /var/lock/dirsrv/
chown -R nobody.nobody /var/run/dirsrv/
chown amavis.amavis /var/run/clam*
chown kolab.kolab /var/run/kolabd
chown -R amavis.amavis /var/run/amavisd
chown -R kolab.kolab /var/run/wallaced
chown -R mongodb.mongodb /var/run/mongodb/
systemctl restart mariadb
systemctl restart dirsrv@leofstan
systemctl restart amavisd
systemctl restart kolabd
systemctl restart mongod
systemctl restart wallace

BUT! I can't get file access from chwala. This is from my chwala error log when I try to access:

[27-Jul-2016 04:01:41,519700 -1000]: <sthppbnt> DB Error: SQLSTATE[HY000] [2002] No such file or directory in /usr/share/roundcubemail/program/lib/Roundcube/rcube_db.php on line 173 (GET /chwalaapi/?timestamp=1469280715&method=invitations&_=1469256779649)
[27-Jul-2016 04:01:41,626100 -1000]: <sthppbnt> DB Error: SQLSTATE[HY000] [2002] No such file or directory in /usr/share/roundcubemail/program/lib/Roundcube/rcube_db.php on line 173 (GET /chwalaapi/?timestamp=1469280715&method=invitations&_=1469256779650)
[24-Aug-2016 18:00:02 Pacific/Honolulu] PHP Warning: PDO::construct(): MySQL server has gone away in /usr/share/roundcubemail/program/lib/Roundcube/rcube_db.php on line 161
[24-Aug-2016 18:00:03 Pacific/Honolulu] PHP Warning: PDO::construct(): Error while reading greeting packet. PID=1526 in /usr/share/roundcubemail/program/lib/Roundcube/rcube_db.php on line 161
[25-Aug-2016 04:00:03,418000 -1000]: <ll5pckm1> DB Error: SQLSTATE[HY000] [2006] MySQL server has gone away in /usr/share/roundcubemail/program/lib/Roundcube/rcube_db.php on line 173 (GET /chwalaapi/?timestamp=1472097540&method=invitations&_=1472075958134)
[15-Dec-2016 19:03:34,920481 -1000]: <2nsgpe52> DB Error: SQLSTATE[HY000] [2002] Connection refused in /usr/share/roundcubemail/program/lib/Roundcube/rcube_db.php on line 173 (GET /chwalaapi/?timestamp=1481766844&method=invitations&_=1481738866938)
[15-Dec-2016 19:04:35,831379 -1000]: <2nsgpe52> DB Error: SQLSTATE[HY000] [2002] Connection refused in /usr/share/roundcubemail/program/lib/Roundcube/rcube_db.php on line 173 (GET /chwalaapi/?timestamp=1481766844&method=invitations&_=1481738866939)
[15-Dec-2016 22:45:26,836390 -1000]: <8eao3630> DB Error: SQLSTATE[HY000] [2002] Connection refused in /usr/share/roundcubemail/program/lib/Roundcube/rcube_db.php on line 173 (GET /chwalaapi/?timestamp=1481841866&method=invitations&_=1481840667477)
[15-Dec-2016 22:46:26,827163 -1000]: <8eao3630> DB Error: SQLSTATE[HY000] [2002] Connection refused in /usr/share/roundcubemail/program/lib/Roundcube/rcube_db.php on line 173 (GET /chwalaapi/?timestamp=1481841866&method=invitations&_=1481840667478)
[15-Dec-2016 22:47:26,845369 -1000]: <8eao3630> DB Error: SQLSTATE[HY000] [2002] Connection refused in /usr/share/roundcubemail/program/lib/Roundcube/rcube_db.php on line 173 (GET /chwalaapi/?timestamp=1481841866&method=invitations&_=1481840667479)
[root@leofstan chwala]# cat errors
[25-Jul-2016 20:45:39,503100 -1000]: <sthppbnt> DB Error: SQLSTATE[HY000] [2002] No such file or directory in /usr/share/roundcubemail/program/lib/Roundcube/rcube_db.php on line 173 (GET /chwalaapi/?timestamp=1469280715&method=invitations&_=1469256777777)
[25-Jul-2016 21:18:42,442100 -1000]: <sthppbnt> DB Error: SQLSTATE[HY000] [2002] No such file or directory in /usr/share/roundcubemail/program/lib/Roundcube/rcube_db.php on line 173 (GET /chwalaapi/?timestamp=1469280715&method=invitations&_=1469256777810)
[25-Jul-2016 21:18:42,556900 -1000]: <sthppbnt> DB Error: SQLSTATE[HY000] [2002] No such file or directory in /usr/share/roundcubemail/program/lib/Roundcube/rcube_db.php on line 173 (GET /chwalaapi/?timestamp=1469280715&method=invitations&_=1469256777809)
[26-Jul-2016 15:50:06,012300 -1000]: <sthppbnt> DB Error: SQLSTATE[HY000] [2002] No such file or directory in /usr/share/roundcubemail/program/lib/Roundcube/rcube_db.php on line 173 (GET /chwalaapi/?timestamp=1469280715&method=invitations&_=1469256778920)
[26-Jul-2016 16:46:46,335400 -1000]: <sthppbnt> DB Error: SQLSTATE[HY000] [2002] No such file or directory in /usr/share/roundcubemail/program/lib/Roundcube/rcube_db.php on line 173 (GET /chwalaapi/?timestamp=1469280715&method=invitations&_=1469256778976)
[27-Jul-2016 04:01:41,519700 -1000]: <sthppbnt> DB Error: SQLSTATE[HY000] [2002] No such file or directory in /usr/share/roundcubemail/program/lib/Roundcube/rcube_db.php on line 173 (GET /chwalaapi/?timestamp=1469280715&method=invitations&_=1469256779649)
[27-Jul-2016 04:01:41,626100 -1000]: <sthppbnt> DB Error: SQLSTATE[HY000] [2002] No such file or directory in /usr/share/roundcubemail/program/lib/Roundcube/rcube_db.php on line 173 (GET /chwalaapi/?timestamp=1469280715&method=invitations&_=1469256779650)
[24-Aug-2016 18:00:02 Pacific/Honolulu] PHP Warning: PDO::construct(): MySQL server has gone away in /usr/share/roundcubemail/program/lib/Roundcube/rcube_db.php on line 161
[24-Aug-2016 18:00:03 Pacific/Honolulu] PHP Warning: PDO::construct(): Error while reading greeting packet. PID=1526 in /usr/share/roundcubemail/program/lib/Roundcube/rcube_db.php on line 161
[25-Aug-2016 04:00:03,418000 -1000]: <ll5pckm1> DB Error: SQLSTATE[HY000] [2006] MySQL server has gone away in /usr/share/roundcubemail/program/lib/Roundcube/rcube_db.php on line 173 (GET /chwalaapi/?timestamp=1472097540&method=invitations&_=1472075958134)
[15-Dec-2016 19:03:34,920481 -1000]: <2nsgpe52> DB Error: SQLSTATE[HY000] [2002] Connection refused in /usr/share/roundcubemail/program/lib/Roundcube/rcube_db.php on line 173 (GET /chwalaapi/?timestamp=1481766844&method=invitations&_=1481738866938)
[15-Dec-2016 19:04:35,831379 -1000]: <2nsgpe52> DB Error: SQLSTATE[HY000] [2002] Connection refused in /usr/share/roundcubemail/program/lib/Roundcube/rcube_db.php on line 173 (GET /chwalaapi/?timestamp=1481766844&method=invitations&_=1481738866939)
[15-Dec-2016 22:45:26,836390 -1000]: <8eao3630> DB Error: SQLSTATE[HY000] [2002] Connection refused in /usr/share/roundcubemail/program/lib/Roundcube/rcube_db.php on line 173 (GET /chwalaapi/?timestamp=1481841866&method=invitations&_=1481840667477)
[15-Dec-2016 22:46:26,827163 -1000]: <8eao3630> DB Error: SQLSTATE[HY000] [2002] Connection refused in /usr/share/roundcubemail/program/lib/Roundcube/rcube_db.php on line 173 (GET /chwalaapi/?timestamp=1481841866&method=invitations&_=1481840667478)
[15-Dec-2016 22:47:26,845369 -1000]: <8eao3630> DB Error: SQLSTATE[HY000] [2002] Connection refused in /usr/share/roundcubemail/program/lib/Roundcube/rcube_db.php on line 173 (GET /chwala//api/?timestamp=1481841866&method=invitations&_=1481840667479)

Those files stating No such file or directory stat is below

File: '/usr/share/roundcubemail/program/lib/Roundcube/rcube_db.php'
Size: 39294           Blocks: 80         IO Block: 4096   regular file

Device: 2eh/46d Inode: 111411782 Links: 1
Access: (0644/-rw-r--r--) Uid: ( 0/ root) Gid: ( 0/ root)
Access: 2016-12-19 13:48:25.621676433 -0500
Modify: 2016-11-27 10:58:05.000000000 -0500
Change: 2016-12-15 13:38:52.350429126 -0500
Birth: -

Seems like roundcube is having trouble attempting to talk to mySQL.

Yum history below too if helpful
Loaded plugins: fastestmirror, priorities

ID | Command line | Date and time | Action(s) | Altered

68 | upgrade                  | 2016-12-15 13:36 | I, O, U        |  458 EE
67 | upgrade                  | 2016-10-18 17:25 | Update         |    6
66 | install iotop            | 2016-10-17 04:59 | Install        |    1
65 | upgrade                  | 2016-10-12 18:37 | I, U           |   12 EE
64 | upgrade                  | 2016-10-01 21:01 | I, U           |   54 EE
63 | upgrade                  | 2016-09-26 19:41 | I, U           |   34 EE

Details

Ticket Type
Task

Event Timeline

ccregor created this task.Dec 20 2016, 1:51 AM
machniak subscribed.Dec 20 2016, 11:25 AM

Did you try to use mysql from command line? Does Roundcube work? What exactly did you upgrade?

ccregor added a comment.Dec 21 2016, 1:56 AM

Roundcube works, everything works, mail, calendaring, address book, etc.... I can even browse files in the roundcube files. I can't view or edit files. The Chwala errors posted are from when I try to view/edit.
What should I try out in SQL?

ccregor added a comment.Dec 21 2016, 1:58 AM

I upgraded all kolab packages from current on 10/18 to what was current on 12/15 for CentOS 7

machniak added a comment.Dec 21 2016, 10:18 AM

Anything interesting in mariadb logs?

machniak closed this task as Invalid.Dec 29 2016, 9:43 AM

I just did an update on some old Kolab:Winterfell installation:

33 | update                   | 2016-12-29 09:31 | E, I, O, U     |  481 EE
32 | update                   | 2016-08-31 12:05 | E, I, U        |  194 EE

I see no issues. Anyway this looks more like a mysql issue.