[GH-ISSUE #99] Fresh install: Error: no such table: backup_account #73

Closed
opened 2026-02-27 08:14:13 +03:00 by kerem · 7 comments
Owner

Originally created by @MartinTerp on GitHub (May 21, 2018).
Original GitHub issue: https://github.com/lucascbeyeler/zmbackup/issues/99

Originally assigned to: @lucascbeyeler on GitHub.

ISSUE TYPE
  • Bug Report
ENVIRONMENT VERSION
  • Zmbackup Version: 1.2.2
  • Zimbra Version: 8.8.8
  • Linux Distribution & Version: CentOS7
SUMMARY

After installing, nothing happends, sqlite database not populated, eventhough i choose TXT

STEPS TO REPRODUCE

This is my first run ever, no backups made before this

[zimbra@mail01 ~]$ zmbackup -f
WARN: my@email.com already has backup today. Nothing to do.
Error: no such table: backup_account
.....
Nothing to do. Closing...
ACTUAL RESULTS
Originally created by @MartinTerp on GitHub (May 21, 2018). Original GitHub issue: https://github.com/lucascbeyeler/zmbackup/issues/99 Originally assigned to: @lucascbeyeler on GitHub. ##### ISSUE TYPE - Bug Report ##### ENVIRONMENT VERSION - Zmbackup Version: 1.2.2 - Zimbra Version: 8.8.8 - Linux Distribution & Version: CentOS7 ##### SUMMARY After installing, nothing happends, sqlite database not populated, eventhough i choose TXT ##### STEPS TO REPRODUCE This is my first run ever, no backups made before this ``` [zimbra@mail01 ~]$ zmbackup -f WARN: my@email.com already has backup today. Nothing to do. Error: no such table: backup_account ..... Nothing to do. Closing... ``` ##### ACTUAL RESULTS
kerem 2026-02-27 08:14:13 +03:00
Author
Owner

@AndreFelipeMachado commented on GitHub (May 22, 2018):

Hello,
I tried editing /etc/zmbackup/zmbackup.conf
#AFM 20180522
#SESSION_TYPE=TXT
SESSION_TYPE=SQLITE3

then
sudo su -
su - zimbra
zmbackup -m
but the /opt/zimbra/backup/sessions.sqlite3 resulted empty.
Then manually executed
sqlite3 /opt/zimbra/backup/sessions.sqlite3 < /usr/local/lib/zmbackup/sqlite3/database.sql
and now it is created with its tables but still no data.
Situation improved, but still not getting a backup at a test lab install:

zimbra@ubuntu1404ltsserver01:~$ zmbackup -f
WARN: admin@zimbratest.com.br found inside blacklist - Nothing to do.
WARN: ham.9rb9jhqm@zimbratest.com.br found inside blacklist - Nothing to do.
WARN: spam.lcbuqph9an@zimbratest.com.br found inside blacklist - Nothing to do.
WARN: virus-quarantine.qcob9qp@zimbratest.com.br found inside blacklist - Nothing to do.
WARN: galsync.kv2vtfn
@zimbratest.com.br found inside blacklist - Nothing to do.
WARN: teste1@zimbratest.com.br already has backup today. Nothing to do.
WARN: teste2@zimbratest.com.br already has backup today. Nothing to do.
WARN: galsync@zimbratest2.com.br found inside blacklist - Nothing to do.
WARN: zmbackup@zimbratest.com.br found inside blacklist - Nothing to do.
Nothing to do. Closing...

Regards.

<!-- gh-comment-id:391074969 --> @AndreFelipeMachado commented on GitHub (May 22, 2018): Hello, I tried editing /etc/zmbackup/zmbackup.conf #AFM 20180522 #SESSION_TYPE=TXT SESSION_TYPE=SQLITE3 then sudo su - su - zimbra zmbackup -m but the /opt/zimbra/backup/sessions.sqlite3 resulted empty. Then manually executed sqlite3 /opt/zimbra/backup/sessions.sqlite3 < /usr/local/lib/zmbackup/sqlite3/database.sql and now it is created with its tables but still no data. Situation improved, but still not getting a backup at a test lab install: zimbra@ubuntu1404ltsserver01:~$ zmbackup -f WARN: admin@zimbratest.com.br found inside blacklist - Nothing to do. WARN: ham.9rb9jhqm@zimbratest.com.br found inside blacklist - Nothing to do. WARN: spam.lcbuqph9an@zimbratest.com.br found inside blacklist - Nothing to do. WARN: virus-quarantine._qcob9qp@zimbratest.com.br found inside blacklist - Nothing to do. WARN: galsync.kv2vtfn_@zimbratest.com.br found inside blacklist - Nothing to do. WARN: teste1@zimbratest.com.br already has backup today. Nothing to do. WARN: teste2@zimbratest.com.br already has backup today. Nothing to do. WARN: galsync@zimbratest2.com.br found inside blacklist - Nothing to do. WARN: zmbackup@zimbratest.com.br found inside blacklist - Nothing to do. Nothing to do. Closing... Regards.
Author
Owner

@the-solipsist commented on GitHub (Aug 5, 2018):

Hi. I'm facing the same issue. Any suggested resolutions?

<!-- gh-comment-id:410535453 --> @the-solipsist commented on GitHub (Aug 5, 2018): Hi. I'm facing the same issue. Any suggested resolutions?
Author
Owner

@digitalray commented on GitHub (Aug 28, 2018):

Same here: Error: no such table: backup_account. Also it doesn't seem to keep a log in the config defined location which is /opt/zimbra/log/zmbackup.log. I'll try to uninstall and reinstall configured with sqlite and see if that works.

<!-- gh-comment-id:416453726 --> @digitalray commented on GitHub (Aug 28, 2018): Same here: Error: no such table: backup_account. Also it doesn't seem to keep a log in the config defined location which is /opt/zimbra/log/zmbackup.log. I'll try to uninstall and reinstall configured with sqlite and see if that works.
Author
Owner

@digitalray commented on GitHub (Aug 28, 2018):

Uninstalling and reinstalling with sqlite option did get rid of that error message. But now when I do a -f -a acct@domain.com, the generated archive file is 0 bytes. And /opt/zimbra/log/zmbackup.log again contains no log entries.

<!-- gh-comment-id:416461072 --> @digitalray commented on GitHub (Aug 28, 2018): Uninstalling and reinstalling with sqlite option did get rid of that error message. But now when I do a -f -a acct@domain.com, the generated archive file is 0 bytes. And /opt/zimbra/log/zmbackup.log again contains no log entries.
Author
Owner

@mvldebian commented on GitHub (Sep 30, 2018):

Same here, https://groups.google.com/forum/#!topic/zmbackup/ba4dn9HUcGA

<!-- gh-comment-id:425683435 --> @mvldebian commented on GitHub (Sep 30, 2018): Same here, https://groups.google.com/forum/#!topic/zmbackup/ba4dn9HUcGA
Author
Owner

@ananiasfilho commented on GitHub (Sep 30, 2018):

Same here, https://groups.google.com/forum/#!topic/zmbackup/ba4dn9HUcGA

Try using new 1.2.3 branch!

<!-- gh-comment-id:425757419 --> @ananiasfilho commented on GitHub (Sep 30, 2018): > Same here, https://groups.google.com/forum/#!topic/zmbackup/ba4dn9HUcGA Try using new 1.2.3 branch!
Author
Owner

@abdou84 commented on GitHub (Nov 20, 2018):

Hello,
I tried editing /etc/zmbackup/zmbackup.conf
#AFM 20180522
#SESSION_TYPE=TXT
SESSION_TYPE=SQLITE3

then
sudo su -
su - zimbra
zmbackup -m
but the /opt/zimbra/backup/sessions.sqlite3 resulted empty.
Then manually executed
sqlite3 /opt/zimbra/backup/sessions.sqlite3 < /usr/local/lib/zmbackup/sqlite3/database.sql
and now it is created with its tables but still no data.
Situation improved, but still not getting a backup at a test lab install:

zimbra@ubuntu1404ltsserver01:~$ zmbackup -f
WARN: admin@zimbratest.com.br found inside blacklist - Nothing to do.
WARN: ham.9rb9jhqm@zimbratest.com.br found inside blacklist - Nothing to do.
WARN: spam.lcbuqph9an@zimbratest.com.br found inside blacklist - Nothing to do.
WARN: virus-quarantine.qcob9qp@zimbratest.com.br found inside blacklist - Nothing to do. WARN: galsync.kv2vtfn@zimbratest.com.br found inside blacklist - Nothing to do.
WARN: teste1@zimbratest.com.br already has backup today. Nothing to do.
WARN: teste2@zimbratest.com.br already has backup today. Nothing to do.
WARN: galsync@zimbratest2.com.br found inside blacklist - Nothing to do.
WARN: zmbackup@zimbratest.com.br found inside blacklist - Nothing to do.
Nothing to do. Closing...

Regards.

go to vim /etc/zmbackup/blacklist.conf
remove all account from this file
save and quit
try zmbackup -f agin should work

<!-- gh-comment-id:440261901 --> @abdou84 commented on GitHub (Nov 20, 2018): > Hello, > I tried editing /etc/zmbackup/zmbackup.conf > #AFM 20180522 > #SESSION_TYPE=TXT > SESSION_TYPE=SQLITE3 > > then > sudo su - > su - zimbra > zmbackup -m > but the /opt/zimbra/backup/sessions.sqlite3 resulted empty. > Then manually executed > sqlite3 /opt/zimbra/backup/sessions.sqlite3 < /usr/local/lib/zmbackup/sqlite3/database.sql > and now it is created with its tables but still no data. > Situation improved, but still not getting a backup at a test lab install: > > zimbra@ubuntu1404ltsserver01:~$ zmbackup -f > WARN: [admin@zimbratest.com.br](mailto:admin@zimbratest.com.br) found inside blacklist - Nothing to do. > WARN: [ham.9rb9jhqm@zimbratest.com.br](mailto:ham.9rb9jhqm@zimbratest.com.br) found inside blacklist - Nothing to do. > WARN: [spam.lcbuqph9an@zimbratest.com.br](mailto:spam.lcbuqph9an@zimbratest.com.br) found inside blacklist - Nothing to do. > WARN: virus-quarantine._[qcob9qp@zimbratest.com.br](mailto:qcob9qp@zimbratest.com.br) found inside blacklist - Nothing to do. WARN: galsync.kv2vtfn_@zimbratest.com.br found inside blacklist - Nothing to do. > WARN: [teste1@zimbratest.com.br](mailto:teste1@zimbratest.com.br) already has backup today. Nothing to do. > WARN: [teste2@zimbratest.com.br](mailto:teste2@zimbratest.com.br) already has backup today. Nothing to do. > WARN: [galsync@zimbratest2.com.br](mailto:galsync@zimbratest2.com.br) found inside blacklist - Nothing to do. > WARN: [zmbackup@zimbratest.com.br](mailto:zmbackup@zimbratest.com.br) found inside blacklist - Nothing to do. > Nothing to do. Closing... > > Regards. go to vim /etc/zmbackup/blacklist.conf remove all account from this file save and quit try zmbackup -f agin should work
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
starred/zmbackup#73
No description provided.