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
