- freeswitch@nas> load mod_mariadb
- 2017-11-14 23:25:58.703145 [INFO] mod_enum.c:879 ENUM Reloaded
- 2017-11-14 23:25:58.703145 [CONSOLE] switch_loadable_module.c:1642 Successfully Loaded [mod_mariadb]
- 2017-11-14 23:25:58.703145 [NOTICE] switch_loadable_module.c:435 Adding dsn prefix 'mariadb'
- 2017-11-14 23:25:58.703145 [NOTICE] switch_loadable_module.c:435 Adding dsn prefix 'maria'
- 2017-11-14 23:25:58.703145 [NOTICE] switch_loadable_module.c:435 Adding dsn prefix 'mysql'
- +OK Reloading XML
- +OK
- 2017-11-14 23:25:58.723114 [INFO] switch_time.c:1423 Timezone reloaded 1750 definitions
- freeswitch@nas> jsrun m.js
- +OK
- freeswitch@nas> 2017-11-14 23:26:02.723146 [INFO] jsmain.cpp:3 DBH TEST
- 2017-11-14 23:26:02.723146 [INFO] jsmain.cpp:10 DB STATUS: true
- 2017-11-14 23:26:02.723146 [CRIT] mod_mariadb.c:646 Failed to send query (SELECT * FROM my_table) to database: Table 'fs.my_table' doesn't exist
- 2017-11-14 23:26:02.723146 [ERR] switch_core_sqldb.c:1656 ERR: [SELECT * FROM my_table]
- [Table 'fs.my_table' doesn't exist]
- 2017-11-14 23:26:02.723146 [CRIT] mod_mariadb.c:646 Failed to send query (DROP TABLE my_table) to database: Unknown table 'my_table'
- 2017-11-14 23:26:02.723146 [ERR] switch_core_sqldb.c:1661 ERR: [DROP TABLE my_table]
- [Unknown table 'my_table']
- 2017-11-14 23:26:02.983177 [INFO] jsmain.cpp:20 DB ROW - ID: 1 NAME: name1
- 2017-11-14 23:26:02.983177 [INFO] jsmain.cpp:20 DB ROW - ID: 2 NAME: name2
- 2017-11-14 23:26:02.983177 [INFO] jsmain.cpp:24 DSN: mariadb://Server=127.0.0.1;Database=fs;Uid=root;Pwd=password123;
- 2017-11-14 23:26:02.983177 [INFO] jsmain.cpp:25 AFFECTED: 0
- 2017-11-14 23:26:02.983177 [INFO] jsmain.cpp:26 LAST ERROR:
- freeswitch@nas> unload mod_mariadb
- 2017-11-14 23:26:31.183177 [NOTICE] switch_loadable_module.c:1285 Deleting dsn prefix 'mariadb'
- +OK
- 2017-11-14 23:26:31.183177 [NOTICE] switch_loadable_module.c:1285 Deleting dsn prefix 'maria'
- 2017-11-14 23:26:31.183177 [NOTICE] switch_loadable_module.c:1285 Deleting dsn prefix 'mysql'
- 2017-11-14 23:26:31.183177 [CONSOLE] switch_loadable_module.c:2117 Stopping: mod_mariadb
- 2017-11-14 23:26:31.183177 [CONSOLE] switch_loadable_module.c:2137 mod_mariadb unloaded.
- freeswitch@nas> jsrun m.js
- +OK
- freeswitch@nas> 2017-11-14 23:26:41.663133 [INFO] jsmain.cpp:3 DBH TEST
- 2017-11-14 23:26:41.663133 [ERR] switch_core_db.c:223 SQL ERR [unable to open database file]
- 2017-11-14 23:26:41.663133 [CRIT] switch_core_sqldb.c:645 Failure to connect to CORE_DB mariadb://Server=127.0.0.1;Database=fs;Uid=root;Pwd=password123;!
- 2017-11-14 23:26:41.663133 [ERR] fsdbh.cpp:95 Connection failed. DBH NOT Connected.
- 2017-11-14 23:26:41.663133 [ERR] undefined:8 Exception: Failed to create new DBH instance (near: "var dbh = new DBH(db_connection_string);")
- freeswitch@nas> load mod_mariadb
- 2017-11-14 23:26:49.823114 [INFO] mod_enum.c:879 ENUM Reloaded
- 2017-11-14 23:26:49.843119 [INFO] switch_time.c:1423 Timezone reloaded 1750 definitions
- 2017-11-14 23:26:49.843119 [CONSOLE] switch_loadable_module.c:1642 Successfully Loaded [mod_mariadb]
- 2017-11-14 23:26:49.843119 [NOTICE] switch_loadable_module.c:435 Adding dsn prefix 'mariadb'
- 2017-11-14 23:26:49.843119 [NOTICE] switch_loadable_module.c:435 Adding dsn prefix 'maria'
- 2017-11-14 23:26:49.843119 [NOTICE] switch_loadable_module.c:435 Adding dsn prefix 'mysql'
- +OK Reloading XML
- +OK
- freeswitch@nas> jsrun m.js
- +OK
- freeswitch@nas> 2017-11-14 23:26:52.123139 [INFO] jsmain.cpp:3 DBH TEST
- 2017-11-14 23:26:52.123139 [INFO] jsmain.cpp:10 DB STATUS: true
- 2017-11-14 23:26:52.243176 [INFO] jsmain.cpp:20 DB ROW - ID: 1 NAME: name1
- 2017-11-14 23:26:52.243176 [INFO] jsmain.cpp:20 DB ROW - ID: 2 NAME: name2
- 2017-11-14 23:26:52.243176 [INFO] jsmain.cpp:20 DB ROW - ID: 1 NAME: name1
- 2017-11-14 23:26:52.243176 [INFO] jsmain.cpp:20 DB ROW - ID: 2 NAME: name2
- 2017-11-14 23:26:52.243176 [INFO] jsmain.cpp:24 DSN: mariadb://Server=127.0.0.1;Database=fs;Uid=root;Pwd=password123;
- 2017-11-14 23:26:52.243176 [INFO] jsmain.cpp:25 AFFECTED: 0
- 2017-11-14 23:26:52.243176 [INFO] jsmain.cpp:26 LAST ERROR:
- freeswitch@nas> load mod_pgsql
- 2017-11-14 23:30:24.063144 [INFO] mod_enum.c:879 ENUM Reloaded
- 2017-11-14 23:30:24.063144 [CONSOLE] switch_loadable_module.c:1642 Successfully Loaded [mod_pgsql]
- +OK Reloading XML
- +OK
- 2017-11-14 23:30:24.063144 [NOTICE] switch_loadable_module.c:435 Adding dsn prefix 'pgsql'
- freeswitch@nas> 2017-11-14 23:30:24.063144 [INFO] switch_time.c:1423 Timezone reloaded 1750 definitions
- freeswitch@nas> unload mod_pgsql
- 2017-11-14 23:30:26.783180 [NOTICE] switch_loadable_module.c:1285 Deleting dsn prefix 'pgsql'
- 2017-11-14 23:30:26.783180 [CONSOLE] switch_loadable_module.c:2117 Stopping: mod_pgsql
- 2017-11-14 23:30:26.783180 [CONSOLE] switch_loadable_module.c:2137 mod_pgsql unloaded.
- +OK
- freeswitch@nas>