possible database problem ?
Posted: 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,
etc produce normal output, so that database is readable
directory listing looks the same as on another box that I manage.
What could be the problem ?
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
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#
What could be the problem ?