From Abrupt Hornbill, 7 Years ago, written in Plain Text.
- view diff
Embed
  1. freeswitch@nas> load mod_mariadb
  2. 2017-11-14 23:25:58.703145 [INFO] mod_enum.c:879 ENUM Reloaded
  3. 2017-11-14 23:25:58.703145 [CONSOLE] switch_loadable_module.c:1642 Successfully Loaded [mod_mariadb]
  4. 2017-11-14 23:25:58.703145 [NOTICE] switch_loadable_module.c:435 Adding dsn prefix 'mariadb'
  5. 2017-11-14 23:25:58.703145 [NOTICE] switch_loadable_module.c:435 Adding dsn prefix 'maria'
  6. 2017-11-14 23:25:58.703145 [NOTICE] switch_loadable_module.c:435 Adding dsn prefix 'mysql'
  7.  
  8. +OK Reloading XML
  9. +OK
  10.  
  11. 2017-11-14 23:25:58.723114 [INFO] switch_time.c:1423 Timezone reloaded 1750 definitions
  12. freeswitch@nas> jsrun m.js
  13.  
  14. +OK
  15.  
  16. freeswitch@nas> 2017-11-14 23:26:02.723146 [INFO] jsmain.cpp:3 DBH TEST
  17. 2017-11-14 23:26:02.723146 [INFO] jsmain.cpp:10 DB STATUS: true
  18. 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
  19. 2017-11-14 23:26:02.723146 [ERR] switch_core_sqldb.c:1656 ERR: [SELECT * FROM my_table]
  20. [Table 'fs.my_table' doesn't exist]
  21. 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'
  22. 2017-11-14 23:26:02.723146 [ERR] switch_core_sqldb.c:1661 ERR: [DROP TABLE my_table]
  23. [Unknown table 'my_table']
  24. 2017-11-14 23:26:02.983177 [INFO] jsmain.cpp:20 DB ROW - ID: 1 NAME: name1
  25. 2017-11-14 23:26:02.983177 [INFO] jsmain.cpp:20 DB ROW - ID: 2 NAME: name2
  26. 2017-11-14 23:26:02.983177 [INFO] jsmain.cpp:24 DSN: mariadb://Server=127.0.0.1;Database=fs;Uid=root;Pwd=password123;
  27. 2017-11-14 23:26:02.983177 [INFO] jsmain.cpp:25 AFFECTED: 0
  28. 2017-11-14 23:26:02.983177 [INFO] jsmain.cpp:26 LAST ERROR:
  29.  
  30. freeswitch@nas> unload mod_mariadb
  31. 2017-11-14 23:26:31.183177 [NOTICE] switch_loadable_module.c:1285 Deleting dsn prefix 'mariadb'
  32.  
  33. +OK
  34.  
  35. 2017-11-14 23:26:31.183177 [NOTICE] switch_loadable_module.c:1285 Deleting dsn prefix 'maria'
  36. 2017-11-14 23:26:31.183177 [NOTICE] switch_loadable_module.c:1285 Deleting dsn prefix 'mysql'
  37. 2017-11-14 23:26:31.183177 [CONSOLE] switch_loadable_module.c:2117 Stopping: mod_mariadb
  38. 2017-11-14 23:26:31.183177 [CONSOLE] switch_loadable_module.c:2137 mod_mariadb unloaded.
  39. freeswitch@nas> jsrun m.js
  40.  
  41. +OK
  42.  
  43. freeswitch@nas> 2017-11-14 23:26:41.663133 [INFO] jsmain.cpp:3 DBH TEST
  44. 2017-11-14 23:26:41.663133 [ERR] switch_core_db.c:223 SQL ERR [unable to open database file]
  45. 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;!
  46. 2017-11-14 23:26:41.663133 [ERR] fsdbh.cpp:95 Connection failed.  DBH NOT Connected.
  47. 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);")
  48.  
  49. freeswitch@nas> load mod_mariadb
  50. 2017-11-14 23:26:49.823114 [INFO] mod_enum.c:879 ENUM Reloaded
  51. 2017-11-14 23:26:49.843119 [INFO] switch_time.c:1423 Timezone reloaded 1750 definitions
  52. 2017-11-14 23:26:49.843119 [CONSOLE] switch_loadable_module.c:1642 Successfully Loaded [mod_mariadb]
  53. 2017-11-14 23:26:49.843119 [NOTICE] switch_loadable_module.c:435 Adding dsn prefix 'mariadb'
  54. 2017-11-14 23:26:49.843119 [NOTICE] switch_loadable_module.c:435 Adding dsn prefix 'maria'
  55. 2017-11-14 23:26:49.843119 [NOTICE] switch_loadable_module.c:435 Adding dsn prefix 'mysql'
  56.  
  57. +OK Reloading XML
  58. +OK
  59.  
  60. freeswitch@nas> jsrun m.js
  61.  
  62. +OK
  63.  
  64. freeswitch@nas> 2017-11-14 23:26:52.123139 [INFO] jsmain.cpp:3 DBH TEST
  65. 2017-11-14 23:26:52.123139 [INFO] jsmain.cpp:10 DB STATUS: true
  66. 2017-11-14 23:26:52.243176 [INFO] jsmain.cpp:20 DB ROW - ID: 1 NAME: name1
  67. 2017-11-14 23:26:52.243176 [INFO] jsmain.cpp:20 DB ROW - ID: 2 NAME: name2
  68. 2017-11-14 23:26:52.243176 [INFO] jsmain.cpp:20 DB ROW - ID: 1 NAME: name1
  69. 2017-11-14 23:26:52.243176 [INFO] jsmain.cpp:20 DB ROW - ID: 2 NAME: name2
  70. 2017-11-14 23:26:52.243176 [INFO] jsmain.cpp:24 DSN: mariadb://Server=127.0.0.1;Database=fs;Uid=root;Pwd=password123;
  71. 2017-11-14 23:26:52.243176 [INFO] jsmain.cpp:25 AFFECTED: 0
  72. 2017-11-14 23:26:52.243176 [INFO] jsmain.cpp:26 LAST ERROR:
  73.  
  74. freeswitch@nas>
  75.