[SR-Users] mysql db error

[Daniel-Constantin Mierla]

Hellol

On 01/11/14 16:38, shmick at 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 at 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