Frequently Asked Questions 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.
- 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.
- 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.
- 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: 'firstname.lastname@example.org' (Using password: YES)As a result, ATSlog fails to install/update.
- 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.
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" IDENTIFIEDBY '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;