Add my specific settings directly in backup_server_settings.db

1

I’m still working on my NethServer module, I have now something workable to install urbackup on a Centos6 but I would love to change some settings directly after the installation without human interactions.

I mean to give the backup folder (/var/lib/urbackup for example) without the need to set it manually in the setting page and also create the admin and set a password.

For this I attempted to open and modify the database backup_server_settings.db, but I have an error message back.

[root@nethserver-dev urbackup]# sqlite3 /var/urbackup/backup_server_settings.db
SQLite version 3.6.20
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .tables
Error: file is encrypted or is not a database
sqlite> .quit

if I try another sqlite database it is the same problem

[root@nethserver-dev urbackup]# sqlite3 backup_server_settings.db
SQLite version 3.6.20
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .tables
Error: file is encrypted or is not a database

I use centos6.7

[root@nethserver-dev urbackup]# cat /etc/redhat-release 
CentOS release 6.7 (Final)

and urbackup 1.4.14

[root@nethserver-dev urbackup]# rpm -qa |grep urbackup
urbackup-server-1.4.14-3.1.x86_64
nethserver-urbackup-0.0.2-1.ns6.sdl.noarch

I’m not sure it is normal :slight_smile: do you have another idea ??

2

Your SQLite version is over 7 years old. Maybe try a newer version?

3

The initial backup storage folder can be set by echo "/media/backupstorage" > $LOCALSTATEDIR/urbackup/backupfolder. That is what the debian package does.

4 
[root@nethserver-dev urbackup]# rpm -qa |grep sqlite
sqlite-3.6.20-1.el6.x86_64

my problem comes here ?

5

UrBackup uses WAL which was added in 3.7.0 https://www.sqlite.org/wal.html

1 Like
6

You should be able to set the admin password via start_urbackup_server --reset_pw password. Setting it manually is probably a bit difficult.

1 Like
7

I suppose that I need to build my own rpm