I don't really understand what you mean by the text I've highlighted, what you've posted is just the directory location. Have a look at the instructions in the wiki for the correct command to show the tables and db etc.
I don't really understand what you mean by the text I've highlighted, what you've posted is just the directory location. Have a look at the instructions in the wiki for the correct command to show the tables and db etc.
su - zimbra
ls -l /opt/zimbra/data/cbpolicyd/db/cbpolicyd.sqlitedb <- what does that show?
zmprov ms $(zmhostname) -zimbraServiceEnabled cbpolicyd <- disable the service and give it a couple of minutes to stop
mv /opt/zimbra/data/cbpolicyd/db/cbpolicyd.sqlitedb /opt/zimbra/data/cbpolicyd/db/cbpolicyd.sqlitedb.old <- move it to one side
zmprov ms $(zmhostname) +zimbraServiceEnabled cbpolicyd <- give that a few minutes to restart
ls -l /opt/zimbra/data/cbpolicyd/db/cbpolicyd.sqlitedb <- what does that show?
cd /opt/zimbra/data/cbpolicyd/db/cbpolicyd
sqlite3 cbpolicyd.sqlitedb
sqlite> select * from sqlite_sequence;
.tables
su - zimbra
ls -l /opt/zimbra/data/cbpolicyd/db/cbpolicyd.sqlitedb <- what does that show?
zmprov ms $(zmhostname) -zimbraServiceEnabled cbpolicyd <- disable the service and give it a couple of minutes to stop
mv /opt/zimbra/data/cbpolicyd/db/cbpolicyd.sqlitedb /opt/zimbra/data/cbpolicyd/db/cbpolicyd.sqlitedb.old <- move it to one side
zmprov ms $(zmhostname) +zimbraServiceEnabled cbpolicyd <- give that a few minutes to restart
ls -l /opt/zimbra/data/cbpolicyd/db/cbpolicyd.sqlitedb <- what does that show?
cd /opt/zimbra/data/cbpolicyd/db/cbpolicyd
sqlite3 cbpolicyd.sqlitedb
sqlite> select * from sqlite_sequence;
.tables
Does that show any information from the db?
thanks for your answer, i've started cbpolicyd on a single server and i've that output for :
I don't really understand what's happening here and as I don't have a NE server I'm not really sure where to look for the answer. Those steps I've listed did work for me on a test server. Is yours a single or multi server installation? I should also have asked this in my previous post, do you see anything useful in the log file at: /opt/zimbra/log/cbpolicyd.log
phoenix wrote:I don't really understand what's happening here and as I don't have a NE server I'm not really sure where to look for the answer. Those steps I've listed did work for me on a test server. Is yours a single or multi server installation? I should also have asked this in my previous post, do you see anything useful in the log file at: /opt/zimbra/log/cbpolicyd.log
It's a single server, if i reboot the server i've that line on cbpolicyd.log :