We have to use '' instead of ' in the stored procedure.
Maybe you don't have a matching voiptariff entry
(with dstid = voiptariffdst.id) or the account has no
sufficient balance or the currency symbol for the account
and the tariff does not match. Or maybe the system cannot
find an account for your user.
Another way to check this problem is to look at PostgreSQL
log and/or RADIUS log to see at which moment the authorization
fails.
On Fri, 2004-08-13 at 04:11, Abano, Fernando A. (ePerformax) wrote:
> Hi Michal,
>
> I am still attempting to make sqlbill work. The diffence between your
> sample voiptariffdst/voiptariff and mine is in the prefix where for
> example, my prefix=1 while in the sample, it is 001 for the USA. I have
> edited that prefix in the table to reflect 1 instead of 001 but it still
> would not compute the price. I then simulated the query and below is the
> result:
>
> select * from voiptariffdst where active and
> ascii(prefix)=ascii('19017154800') and ('19017154800' like (prefix ||
> ''%'')) limit 1;
>
> And got this result:
>
> ERROR: operator is not unique: "unknown" % "unknown"
> HINT: Could not choose a best candidate operator. You may need to add
> explicit type casts.
>
> I changed the query to:
>
> select * from voiptariffdst where active and
> ascii(prefix)=ascii('19017154800') and ('19017154800' like (prefix ||
> '%')) limit 1;
>
> And got :
>
> id | active | prefix | description
> ----+--------+--------+-------------
> 57 | t | 1 | USA
> (1 row)
>
> It appears that the double single quote near the % was creating an error
> in match_tariff.
>
> Is my finding correct?
-------------------------------------------------------
SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
_______________________________________________________
List: Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx
Archive: http://sourceforge.net/mailarchive/forum.php?forum_id=8549
Homepage: http://www.gnugk.org/
