Hellol

On 01/11/14 16:38, shmick@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@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users