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