Linux Admin Server

How to change firebird 'sysdba' account and password?

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

  • Export current database:

# 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