FAQ

The AVG TCP Server supports these versions of Firebird servers: 

• Firebird Classic Server 1.0.3 
• Firebird Super Server 1.0.3 
• Firebird Classic Server 1.5 
• Firebird Super Server 1.5
  
  

You can configure the AVG TCP Server settings in the configuration file /opt/grisoft/avgtcpsrv/etc/avgtcpsrv.conf.

After the AVG TCP Server installation and configuration, you have to register it. You can do it this way:

/opt/grisoft/avgtcpsrv/bin/avgtcpsrv –r <license_number>
or
./avgtcpsrv -r <license_number> (from this folder: /opt/grisoft/avgtcpsrv/bin)

The AVG TCP Server creates "avglog.log" LOG file. You can find it in this folder: /opt/grisoft/avgtcpsrv/var/log/

You can start more detailed logging of the AVG TCP Server by changing the value of the "verbose" parameter to 1 (verbose=1) in the configuration file /opt/grisoft/avgtcpsrv/etc/avgtcpsrv.conf.

Some Firebird servers generate an unique password for the Firebird database during its installation. Because of this you have to set the password up in the AVG TCP Server configuration file (/opt/Grisoft/avgtcpsrv/etc/avgtcpsrv.conf).
You set it exactly like this:
DBAUserName=SYSDBA
DBAPassword=<PASSWORD>
If the access into the Firebird database is protected by a password and the password is not configured in the configuration file
(/opt/Grisoft/avgtcpsrv/etc/avgtcpsrv.conf), the AVG TCP Server will not start. You can find this error message in the LOG file

(/opt/Grisoft/avgtcpsrv/var/log/avglog.log) in this case:

WARN 000 AVG7.TCPSV.DC.FBConn ! FireBird database error: Your user name and password are not defined. Ask your database administrator to set up a Firebird login.

You can connect the AVG TCP Server to a remote DataCenter as well. You only need to use a correct connection string in the configuration file (/opt/grisoft/avgtcpsrv/etc/avgtcpsrv.conf) like this:

Databasepath=<IP>:/opt/grisoft/avgtcpsrv/var/datacenter/avgdb.fdb

Note: IP = IP address of the computer with DataCenter

In the case you have a unique password you have to use the correct password for the Firebird database as well.
If the connection to the remote database fails, you can see following warning in the LOG file (/opt/grisoft/avgtcpsrv/var/log/avglog.log):
WARN 000 AVG7.TCPSV.DC.FBConn ! FireBird database error: Unable to complete network request to host "192.168.104.193". Failed to establish a connection. Connection refused.

Remote computer is not started, or the Firebird database is not installed.

If a Firebird server is not installed, you can see following error message during the AVG TCP Server installation:

Could not find Firebird library '/usr/lib/libgds.so'!
The AVG TCP Server will not be able to work without this library! Please install it first.
Do you want to continue? (Y/N):

You can continue and install the AVG TCP Server but it is not possible to start it now. You have to set up the correct connection string to the DataCenter first. The configuration file may be found in following directory: /opt/Grisoft/avgtcpsrv/etc/avgtcpsrv.conf.

Please note that it is not necessary to run AVG TCP Server and Firebird database on the same computer. You may use the address of remote station where the Firebird database installed is in the configuration file.

• Following libraries are needed for proper running of AVG TCP Server:
  - libpthread.so (part of ebuild glibc)
  - libstdc++6.2-2.so.3 (part of ebuild lib-compat)

• Installation of essential libraries:
  #emerge glibc
  #emerge lib-compat

• Installation of a Firebird database:
  #emerge firebird

• The Firebird database can be started automatically during boot up process by adding it to the default runlevel:
  #rc-update add firebird default

• It is important to set a Firebird database password:
  #/opt/firebird/bin/changeDBAPassword.sh

• Now the AVG TCP Server can be installed. Installation tar package can be downloaded from Downloads.

• It is necessary to configure the AVG TCP Server. It is important to set the correct password for Firebird database. Edit these items, please:
  DBAUserName=sysdba
  DBAPassword=<PASSWORD>

• If the AVG TCP Server should be started automatically, please add it to the default runlevel running this command:
  #rc-update add avgtcpsrvd default

• It is also important to make the DataCenter database file accessible for a Firebird database. The owner of the DataCenter can be changed by this command:
  #chown firebird:firebird /opt/grisoft/avgtcpsrv/var/datacenter/avgdb.fdb

• Now everything should be installed and configured and it should be possible to run the Firebird database and the AVG TCP Server:
  #/etc/init.d/firebird start
  #/etc/init.d/avgtcpsrvd start