Re: [SOGo] SOGo database move - unsuccessfull
hi, I had to do pg_dump all and restore then also disabled the ipv6 on the machine. This all worked. thanks KH On Thu, Jan 24, 2013 at 5:19 PM, Christian Mack christian.m...@uni-konstanz.de wrote: Hello Khapare Joshi Am 2013-01-24 18:08, schrieb Khapare Joshi: I have been running sogo for now two years in virtual server. since users increased I wanted to move to another physical server. I am having issue with sogo database. I dumped the sogo database with pg_dump and tried to restore with pg_restore. At the end of the pg_restore i get following error: ALTER TABLE ALTER TABLE WARNING: no privileges could be revoked for public REVOKE WARNING: no privileges could be revoked for public REVOKE WARNING: no privileges were granted for public GRANT WARNING: no privileges were granted for public GRANT Anyway, then I tried to login to interface - i do not see any calendars, contacts etc. then tried with sogo-tool, I still do not see the calendars, contacts etc. I see lots of meesage in sogo.log 0x7f8d3df2a368[SOGoCache] an error occurred when caching value for key 'session:wg1iycSZeH9KHietXslAkQ==': WRITE FAILURE Jan 24 16:59:22 sogod [9037]: 0x0x7f8d3df2a368[SOGoCache] an error occurred when caching value for key 'test+attributes': WRITE FAILURE Jan 24 16:59:22 sogod [9038]: |SOGo| starting method 'POST' on uri '/SOGo/so/test/Contacts/personal/canAccessContent' Jan 24 16:59:22 sogod [9033]: |SOGo| starting method 'POST' on uri '/SOGo/so/test/Contacts/test.com/canAccessContent http://test.com/canAccessContent' Jan 24 16:59:22 sogod [9038]: 0x0x7f8d3df1bad8[SOGoCache] an error occurred when caching value for key 'session:wg1iycSZeH9KHietXslAkQ==': WRITE FAILURE Jan 24 16:59:22 sogod [9033]: 0x0x7f8d3df2a358[SOGoCache] an error occurred when caching value for key 'session:wg1iycSZeH9KHietXslAkQ==': WRITE FAILURE Jan 24 16:59:22 sogod [9037]: 0x0x7f8d3df2a368[SOGoCache] an error occurred when caching value for key 'test+attributes': WRITE FAILURE Jan 24 16:59:22 sogod [9037]: 0x0x7f8d3df2a368[SOGoCache] an error occurred when caching value for key 't...@test.com mailto:t...@test.com+attributes': WRITE FAILURE my sogo version in old server is : 2.0.2 and in new server 2.0.3 postgres version on old server is : 8.4 and in new server 9.2 Obviously your user public does not get the required privileges on your tables. So every write operation will not work. This applies to session information also. So you will not get any response from SOGo. Fix this and it will work. Kind regards, Christian Mack -- Christian Mack Gruppe Informationsdienste Rechenzentrum Universität Konstanz -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] SOGo database move - unsuccessfull
Hello all, I have been running sogo for now two years in virtual server. since users increased I wanted to move to another physical server. I am having issue with sogo database. I dumped the sogo database with pg_dump and tried to restore with pg_restore. At the end of the pg_restore i get following error: ALTER TABLE ALTER TABLE WARNING: no privileges could be revoked for public REVOKE WARNING: no privileges could be revoked for public REVOKE WARNING: no privileges were granted for public GRANT WARNING: no privileges were granted for public GRANT Anyway, then I tried to login to interface - i do not see any calendars, contacts etc. then tried with sogo-tool, I still do not see the calendars, contacts etc. I see lots of meesage in sogo.log 0x7f8d3df2a368[SOGoCache] an error occurred when caching value for key 'session:wg1iycSZeH9KHietXslAkQ==': WRITE FAILURE Jan 24 16:59:22 sogod [9037]: 0x0x7f8d3df2a368[SOGoCache] an error occurred when caching value for key 'test+attributes': WRITE FAILURE Jan 24 16:59:22 sogod [9038]: |SOGo| starting method 'POST' on uri '/SOGo/so/test/Contacts/personal/canAccessContent' Jan 24 16:59:22 sogod [9033]: |SOGo| starting method 'POST' on uri '/SOGo/so/test/Contacts/test.com/canAccessContent' Jan 24 16:59:22 sogod [9038]: 0x0x7f8d3df1bad8[SOGoCache] an error occurred when caching value for key 'session:wg1iycSZeH9KHietXslAkQ==': WRITE FAILURE Jan 24 16:59:22 sogod [9033]: 0x0x7f8d3df2a358[SOGoCache] an error occurred when caching value for key 'session:wg1iycSZeH9KHietXslAkQ==': WRITE FAILURE Jan 24 16:59:22 sogod [9037]: 0x0x7f8d3df2a368[SOGoCache] an error occurred when caching value for key 'test+attributes': WRITE FAILURE Jan 24 16:59:22 sogod [9037]: 0x0x7f8d3df2a368[SOGoCache] an error occurred when caching value for key 't...@test.com+attributes': WRITE FAILURE my sogo version in old server is : 2.0.2 and in new server 2.0.3 postgres version on old server is : 8.4 and in new server 9.2 Any help would be great. KH -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo database move - unsuccessfull
Hello Khapare Joshi Am 2013-01-24 18:08, schrieb Khapare Joshi: I have been running sogo for now two years in virtual server. since users increased I wanted to move to another physical server. I am having issue with sogo database. I dumped the sogo database with pg_dump and tried to restore with pg_restore. At the end of the pg_restore i get following error: ALTER TABLE ALTER TABLE WARNING: no privileges could be revoked for public REVOKE WARNING: no privileges could be revoked for public REVOKE WARNING: no privileges were granted for public GRANT WARNING: no privileges were granted for public GRANT Anyway, then I tried to login to interface - i do not see any calendars, contacts etc. then tried with sogo-tool, I still do not see the calendars, contacts etc. I see lots of meesage in sogo.log 0x7f8d3df2a368[SOGoCache] an error occurred when caching value for key 'session:wg1iycSZeH9KHietXslAkQ==': WRITE FAILURE Jan 24 16:59:22 sogod [9037]: 0x0x7f8d3df2a368[SOGoCache] an error occurred when caching value for key 'test+attributes': WRITE FAILURE Jan 24 16:59:22 sogod [9038]: |SOGo| starting method 'POST' on uri '/SOGo/so/test/Contacts/personal/canAccessContent' Jan 24 16:59:22 sogod [9033]: |SOGo| starting method 'POST' on uri '/SOGo/so/test/Contacts/test.com/canAccessContent http://test.com/canAccessContent' Jan 24 16:59:22 sogod [9038]: 0x0x7f8d3df1bad8[SOGoCache] an error occurred when caching value for key 'session:wg1iycSZeH9KHietXslAkQ==': WRITE FAILURE Jan 24 16:59:22 sogod [9033]: 0x0x7f8d3df2a358[SOGoCache] an error occurred when caching value for key 'session:wg1iycSZeH9KHietXslAkQ==': WRITE FAILURE Jan 24 16:59:22 sogod [9037]: 0x0x7f8d3df2a368[SOGoCache] an error occurred when caching value for key 'test+attributes': WRITE FAILURE Jan 24 16:59:22 sogod [9037]: 0x0x7f8d3df2a368[SOGoCache] an error occurred when caching value for key 't...@test.com mailto:t...@test.com+attributes': WRITE FAILURE my sogo version in old server is : 2.0.2 and in new server 2.0.3 postgres version on old server is : 8.4 and in new server 9.2 Obviously your user public does not get the required privileges on your tables. So every write operation will not work. This applies to session information also. So you will not get any response from SOGo. Fix this and it will work. Kind regards, Christian Mack -- Christian Mack Gruppe Informationsdienste Rechenzentrum Universität Konstanz -- users@sogo.nu https://inverse.ca/sogo/lists