AVG Admin Server for Linux/FreeBSD accesses the Firebird database by
default using the SYSDBA account. If you want to change the user and
password by which AVG Admin Server accesses Firebird, please follow
these steps:
1. If AVG Admin Server is not yet installed:
- Create a new user in Firebird database:
# gsec -user SYSDBA -password masterkey -add user -pw password
- You can check that the user was created using this command:
# gsec -user SYSDBA -password masterkey -display
- Install AVG Admin Server and fill in correct information about database connection during the installation
- This will create new database and save the connection information to configuration file.
2. If AVG Admin Server is already installed and running:
- Create a new user in Firebird database:
# gsec -user SYSDBA -password masterkey -add <user> -pw <password>
- You can check that the user was created using this command:
# gsec -user SYSDBA -password masterkey -display
# avgadmsrv --exportDB <some directory>
- Change the configuration of AVG Admin server manually by editing /opt/avg/avgadmsrv/etc/avgadmsrv.conf
- In the configuration file change connection setting to your newly created user and his password:
DBAUserName=<user>
DBAPassword=<passwd>
- Stop the AVG Admin Server:
# /etc/init.d/avgadmsrvd stop
- Create new database (it will be created with the new user connection):
# avgadmsrv --createDB
- Import the exported database:
# avgadmsrv --importDB DIR
- Start the AVG Admin Server:
# /etc/init.d/avgadmsrvd start