[OpenSIPS-Users] auth_db:get_ha1: failed to query database

Bogdan-Andrei Iancu bogdan at voice-system.ro
Fri Jul 10 17:42:07 CEST 2009


Hi Ram,

Looks like your subscriber table is corrupted and has no "username" column.

Regards,
Bogdan

ram wrote:
>
>
>
> Hi
>  
> iam setting up CDRtools with Radius and Opensips
>  
> everything working Fine
>  
> Opensips is running
>  
> when the client try to register i get the follwing errors in the 
> /var/log/syslog
>  
> I have downloaded latest SVN Trunk of 1.5.X
>  
>  
> Jul  9 12:56:56 freeswitch /usr/local/sbin/opensips[1386]: 
> --------REGISTER LOOP IN MAIN ROUTE
> Jul  9 12:56:56 freeswitch /usr/local/sbin/opensips[1386]: 
> ERROR:db_mysql:get_new_stmt_ctx: failed while mysql_stmt_prepare: 
> (1054) Unknown column 'username' in 'where clause'
> Jul  9 12:56:56 freeswitch /usr/local/sbin/opensips[1386]: 
> ERROR:db_mysql:db_mysql_do_prepared_query: failed to create new context
> Jul  9 12:56:56 freeswitch /usr/local/sbin/opensips[1386]: 
> ERROR:auth_db:get_ha1: failed to query database
>  
> any suggestions , or this is bug
>  
> Ram
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>   




More information about the Users mailing list