[OpenSER-Users-ES] Problemas de Autentificación
David Villasmil
david.villasmil.work at gmail.com
Wed Jan 16 17:49:49 CET 2008
On Jan 16, 2008 4:55 PM, Iñaki Baz Castillo <ibc at in.ilimit.es> wrote:
> On Wednesday 16 January 2008 16:50:43 David Villasmil wrote:
> > Hola a todos,
> >
> >
> > Es posible ejecutar un query contra mysql en el openser.cfg?
>
> Sí:
> http://www.openser.org/docs/modules/1.3.x/avpops.html#AEN287
>
>
>
> --
> Iñaki Baz Castillo
> ibc at in.ilimit.es
>
> _______________________________________________
> Users-es mailing list
> Users-es at lists.openser.org
> http://lists.openser.org/cgi-bin/mailman/listinfo/users-es
>
He estado mirando el modulo y he hecho lo siguiente:
quiero obtener el balance de un cliente a partir del $ua, así:
modparam("avpops","avp_url","mysql://user:pass@1.2.3.4/dbname")
modparam("avpops", "avp_table", "clients")
if ($(au{s.len})>0){
avp_db_query("select balance from clients where number =
'$au';","$avp(i:10001)");
xlog("L_NOTICE", "\select balance from dbname.clients where number =
'$au';\n");
xlog("L_NOTICE", "\nMYSQL Query executed\nResults: $avp(i:10001)\n");
}
pero siempre da valores NULL, aparentemente se conecta y todo, pero...
Saludos
David
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.kamailio.org/pipermail/sr-users-es/attachments/20080116/2fe12ad9/attachment-0002.htm
More information about the Users-es
mailing list