3 Nov
2014
3 Nov
'14
5:09 p.m.
Hellol
On 01/11/14 16:38, shmick(a)riseup.net wrote:
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;
the above is related to MySQL, nothing related to kamailio itself.
The 'show columns' is an invalid mysql command. As columns are something
related to a table, i guess, in the eventuality such command exists,
that there has to be a table name.
I use 'describe tablename' to see the structure of a table in mysql
database.
Cheers,
Daniel
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)
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
--
Daniel-Constantin Mierla
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio Advanced Training, Nov 24-27, Berlin - http://www.asipto.com