possible database problem ?

Business solution to host your own OpenVPN server with web management interface and bundled clients.
Post Reply
cas
OpenVpn Newbie
Posts: 2
Joined: Tue Jul 09, 2013 12:19 pm

possible database problem ?

Post by cas » Tue Jul 09, 2013 12:44 pm

Hi,

When I try to change an attribute in a user ( eg deny access) I get the following

UserPropProfileMultiPut: <Fault 9000: "sqlalchemy.exc.OperationalError: None: (OperationalError) attempt to write a readonly database u'UPDATE config SET value=? WHERE config.profile_id = ? AND config.name = ?' (u'+ALL_S2C_SUBNETS', 27, u'access_from.0')">

Other actions like creating an new group produce the same error.


on the commandline,

Code: Select all

 root@openvpnas:/usr/local/openvpn_as/scripts#./confdba -us
root@openvpnas:/usr/local/openvpn_as/scripts#./logdba --csv
etc produce normal output, so that database is readable

Code: Select all

root@openvpnas:/usr/local/openvpn_as/scripts# ls -al ../etc/db
total 7548
drwxr-xr-x 2 root root    4096 Jul  2 10:10 .
drwxr-xr-x 9 root root    4096 Oct 20  2012 ..
-rw------- 1 root root  195584 Jun 21 16:46 certs.db
-rw------- 1 root root   17408 Nov  6  2012 config.db
-rw------- 1 root root 7430144 Jul  2 10:10 log.db
-rw------- 1 root root    3608 Jul  2 10:10 log.db-journal
-rw------- 1 root root   53248 Jun 21 16:19 userprop.db
root@openvpnas:/usr/local/openvpn_as/scripts#
directory listing looks the same as on another box that I manage.

What could be the problem ?

cas
OpenVpn Newbie
Posts: 2
Joined: Tue Jul 09, 2013 12:19 pm

Re: possible database problem ?

Post by cas » Tue Jul 09, 2013 1:41 pm

A reboot of the server solved the problem. Still I would like to be able to solve this nicely if it should happen again.

Post Reply