Error due to FreeSWITCH using ODBC requirements
If you are using mysql, make sure you are using MYODBC 3.51.18 or higher and enable FLAG_MULTI_STATEMENTS
If you are using mysql, make sure you are using MYODBC 3.51.18 or higher and enable FLAG_MULTI_STATEMENTS
# vim /etc/odbc.ini
[freeswitch]
Driver = MySQL
SERVER = localhost
PORT = 3306
DATABASE = myDatabase
OPTION = 67108864
Note: option = 67108864 Start SQL batch, freeswitch ODBC mode must be on
ODBC does not configure SQL preprocessing, resulting in an error when executing multiple SQL statements at the same time
ubuntu20.04
Download and install ODBC driver from MySQL website
Note that the version option of 8x is invalid after setting,
Solution demotion
mysql-connector-odbc-5.3.14-linux-ubuntu19.10-x86-64bit.tar.gz
Verification supports preprocessing methods, which are not described here for ODBC configuration
isql -v freeswitch
delete from sip_ registrations where sub_ host is null and hostname=’VM-0-13-ubuntu’ and network_ ip like ‘%’ and network_ port like ‘%’ and sip_ u
Read More:
- Oracle-OrcleInstanctClient Install ODBC Error: Oracle ODBC Driver with same name already exists
- MYSQL 5.7 Error Code: 1290. The MySQL server is running with the –secure-file-priv option so it..
- [Solved] public key is not available client side (option serverRsaPublicKeyFile not set)
- Ubuntu ERROR 2003 (HY000): Can’t connect to MySQL server on ‘127.0.0.1’ (111)
- Mysql8.02/ubuntu 20 ERROR 1449 (HY000) [How to Solve]
- [Solved] Django configures MySQL Error: NameError: name ”_MySQL ‘is not defined
- Mysql Flashback Warning: C:\Program Files\MySQL\MySQL Server 8.0\bin\mysql.exe
- Remote connection to MySQL database error: is not allowed to connect to this MYSQL server solution
- [Solved] ERROR 2002 (HY000): Can’t connect to local MySQL server through socket’/var/lib/mysql/mysql.sock’ (2)
- [Solved] MYSQL Error: ERROR! MySQL server PID file could not be found!
- How to Fix MySQL ERROR 1130 (HY000): Host ‘XXXX’ is not allowed to connect to this MySQL server
- [Solved] MYSQL Command Execute Error: Can ‘t connect to local MySQL server through socket ‘/tmp/mysql.sock ‘(2) “
- Centos7 Initialize mysql Error: Could not open file ‘/usr/local/mysql/log/mysqld.log‘ for error logging: Per
- How to Solve can‘t connect to local mysql server through socket ‘/var/lib/mysql/mysql.sock‘
- host ‘‘ is not allowed to connect to this mysql server Connect MYSQL Error
- MySql Install Error: Can‘t connect to local MySQL server through socket ‘/tmp/mysql.sock‘
- ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’
- MySQL Install Error: MySQL error 1042: Unable to connect to any of the specified MySQL hosts
- MYSQL Enter password:ERROR 2003 (HY000): Can‘t connect to MySQL server on ‘localhost:3306‘
- mac brew install mysql ‘/tmp/mysql.sock’ (2) [How to Solve]