ATSlog - FAQ.

ATSlog works, but the text log file if being filled with some garbage instead of lines with call descriptions. What is the reason?

Possible reason:

The PBX port and computer port rates mismatch.

Solution:

Change the parameter $speed in the config file /usr/local/etc/atslog.conf Look up also for other port settings: $charsize, $parity, $stopbits. Port parameters can be taken from the documentation to the PBX.

When writing from the text log file into server SQL database the program issues the following warning:
Warning! No entries from the log file were parsed to the SQL server. This might has been caused by an error.

Possible reasons:

Wrong PBX model in the $model parameter of the config file.
It is also possible that the log file contains no lines with the PBX data.

How can I import data from the previously generated text log file into ATSlog?

Solution:

Copy the data into the file /var/log/atslog/calls.log (the default file; particularly check the value of the parameter $callslogfile of the config file /usr/local/etc/atslog.conf)
Use the function of writing all calls into the server SQL database:
```
# atslogmaster alltodb
```

ATSlog starts, but nothing happens, the data from PBX are not being writen. In the process list two atslogd daemons are present.

Possible reason:

There is no connection between the daemon and the PBX.

Solution:

Check the parameter $port of the config file /usr/local/etc/atslog.conf and check the plugging of the cable from PBX to the PC. Lack of connection can also be caused by a wrong cable pin-out.

Upon installation with the use of the MySQL server on another PC other than localhost, the ATSlog issues the following message:
```
ERROR 1130: Host 'atslog.server.com' is not allowed to connect to this MySQL server.
```
Or:
```
ERROR 1045: Access denied for user: 'root@atslog.server.com' (Using password: YES)
```
As a result, ATSlog fails to install/update.

Possible reason:

For ATSlog operation it is necessary to insert the data into MySQL under the superuser permissions. By default the root access is possible only from the localhost.

Solution:

Temporarily enlarge the superuser rights for accessing from the host 'atslog.server.com'. The command is:

GRANT ALL PRIVILEGES ON * . * TO "root"@"atslog.server.com" IDENTIFIED
BY 'noncrypted_root_password' WITH GRANT OPTION;

Thereafter the installation can be resumed
After installing dont forget to restore back the permissions of the root:

DELETE FROM mysql.user WHERE User = "root" AND Host = "atslog.server.com";
DELETE FROM mysql.db WHERE User = "root" AND Host = "atslog.server.com";
DELETE FROM mysql.tables_priv WHERE User = "root" AND Host = "atslog.server.com";
DELETE FROM mysql.columns_priv WHERE User = "root" AND Host = "atslog.server.com";

FLUSH PRIVILEGES;