Hellol On 01/11/14 16:38, shm...@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 -- Daniel-Constantin Mierla http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda Kamailio Advanced Training, Nov 24-27, Berlin - http://www.asipto.com _______________________________________________ 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
