recently engaged in SIP phone related projects, encountered a lot of trouble when building opensips server, most of which could be solved by looking up information, but today I encountered a problem that I could not find the solution on the Internet, so I decided to share it with you.
virtual system is Ubuntu14.04
opensips version is 2.1.2
when opensips service is started, the following error occurs:
[email protected]-VirtualBox:/usr/local/opensips_proxy/sbin# ./opensipsctl start
INFO: Starting OpenSIPS :
ERROR: PID file /var/run/opensips.pid does not exist -- OpenSIPS start failed
view the ERROR log and prompt “ERROR:core:db_check_table_version: invalid version 7 for table dialog found”, assuming there was a problem with the database creation
[email protected]-VirtualBox:/usr/local/opensips_proxy/sbin# tail -f /var/log/syslog
Oct 13 08:40:29 sjt-VirtualBox ./opensips[2851]: INFO:alias_db:mod_init: initializing...
Oct 13 08:40:29 sjt-VirtualBox ./opensips[2851]: INFO:dialog:mod_init: Dialog module - initializing
Oct 13 08:40:29 sjt-VirtualBox ./opensips[2851]: INFO:core:evi_publish_event: Registered event <E_DLG_STATE_CHANGED(12)>
Oct 13 08:40:29 sjt-VirtualBox ./opensips[2851]: ERROR:core:db_check_table_version: invalid version 7 for table dialog found, expected 10
Oct 13 08:40:29 sjt-VirtualBox ./opensips[2851]: ERROR:dialog:init_dlg_db: error during table version check.
Oct 13 08:40:29 sjt-VirtualBox ./opensips[2851]: ERROR:dialog:mod_init: failed to initialize the DB support
Oct 13 08:40:29 sjt-VirtualBox ./opensips[2851]: ERROR:core:init_mod: failed to initialize module dialog
Oct 13 08:40:29 sjt-VirtualBox ./opensips[2851]: ERROR:core:main: error while initializing modules
creates opensips database
again
[email protected]-VirtualBox:/usr/local/opensips_proxy/sbin# ./opensipsdbctl create
MySQL password for root:
INFO: test server charset
INFO: creating database opensips ...
ERROR 1007 (HY000) at line 1: Can't create database 'opensips'; database exists
ERROR: Creating database opensips failed!
indicates that the database already exists and the creation failed. The reason was finally found, because I had built a database before, and this installation configuration of OpenSiPs did not match the previous database, so the OpenSips service could not be started.
therefore, delete the previous database, recreate, execute./opensipsdbctl reinit.
[email protected]-VirtualBox:/usr/local/opensips_proxy/sbin# ./opensipsdbctl reinit
MySQL password for root:
INFO: Database opensips deleted
INFO: test server charset
INFO: creating database opensips ...
INFO: Using table engine MyISAM.
INFO: Core OpenSIPS tables successfully created.
Install presence related tables? (y/n): y
INFO: creating presence tables into opensips ...
INFO: Presence tables successfully created.
Install tables for imc cpl siptrace domainpolicy carrierroute userblacklist b2b cachedb_sql registrant call_center fraud_detection? (y/n): y
INFO: creating extra tables into opensips ...
INFO: Extra tables successfully created.
open opensips service again, success!
[email protected]-VirtualBox:/usr/local/opensips_proxy/sbin# ./opensipsctl start
INFO: Starting OpenSIPS :
INFO: started (pid: 3128)
Read More:
- This version of chromedriver only supports chrome version 92 crawler simulates the problem of Google plug-in version when the browser clicks and reports an error
- DB2 table annotation pull
- An error was reported in the process of importing the table from mysql5.7: [err] 1067 – invalid default value for ‘***‘
- SAP Migo 101 receives the work order and reports an error – check table tfbefu_ CR entry 10 does not exist – Countermeasures
- DB: the solution of table already exist when migrating
- Insufficient table space ORA-00604 unable to extend table SYS.AUD by 8192
- An error occurred when installing pytorch version 1.7 GPU
- 1093 – You can’t specify target table ‘table’ for update in FROM clause
- DB2 create table error – 104 42601 illegal symbol encountered in SQL statement
- Django. DB. Utils. Programmingerror: (1146, “table * doesn’t exist”) causes and Solutions
- DB2 encountered the problem of sqlcode = 911 lock table when updating record update
- db2 Database Error: table space access is not allowed
- You have an error in your SQL syntax； check the manual that corresponds to your MySQL server version
- An error occurred during the installation of assembly ‘Microsoft.VC80.CRT,version=”8.0.50727.42″,typ
- entity framework core + SQLite Error 1: ‘no such table: Blogs’.
- Errors in IntelliJ ieeasql statements and table names in @ table
- Error 1146 (42s02): table ‘database name. Table name’ doesn’t exist ‘
- Error:Kotlin: Module was compiled with an incompatible version of Kotlin. The binary version of its
- An error occurred during the installation of assembly ‘ Microsoft.VC90 .CRT,version = “9.0.
- (element UI component table) how to add a style to a table