1 Nov
2014
1 Nov
'14
11:38 a.m.
running kamailio from
deb http://deb.kamailio.org/kamailio jessie main
mysql> show columns;
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near '' at line 1
it was a while ago, but
i used the included script and followed wiki instructions to create the
initial DB
from memory it was a simple 1 liner cmd
any help is appreciated
thanks
mysql> show tables;
+---------------------+
| Tables_in_kamailio |
+---------------------+
| acc |
| acc_cdrs |
| active_watchers |
| address |
| aliases |
| carrier_name |
| carrierfailureroute |
| carrierroute |
| cpl |
| dbaliases |
| dialog |
| dialog_vars |
| dialplan |
| dispatcher |
| domain |
| domain_attrs |
| domain_name |
| domainpolicy |
| globalblacklist |
| grp |
| htable |
| imc_members |
| imc_rooms |
| lcr_gw |
| lcr_rule |
| lcr_rule_target |
| location |
| location_attrs |
| missed_calls |
| mohqcalls |
| mohqueues |
| mtree |
| mtrees |
| pdt |
| pl_pipes |
| presentity |
| pua |
| purplemap |
| re_grp |
| rls_presentity |
| rls_watchers |
| rtpproxy |
| sca_subscriptions |
| silo |
| sip_trace |
| speed_dial |
| subscriber |
| trusted |
| uacreg |
| uid_credentials |
| uid_domain |
| uid_domain_attrs |
| uid_global_attrs |
| uid_uri |
| uid_uri_attrs |
| uid_user_attrs |
| uri |
| userblacklist |
| usr_preferences |
| version |
| watchers |
| xcap |
+---------------------+
62 rows in set (0.00 sec)