[Asterisk-Users] Fixed! Midifyed-Prepaid-Application

[Hekuran Doli]

Hi all
I simply added a resller account then cardtype cid and card I also filled
the order and sale table. I didnt populate the providers* tables because I
didnt need it. Populated the country, countryprefix to. keep checking ID`s
couse if you give wrong ID to tables you cant link them!
Try this and if it wont work then Im gona post the datagram with exact
rocords on my database.

Feel free to ask!

Best Regards
Hekuran Doli
Kosova

> Hi Hekuran,
>
> You can post an example account how did you populate the database on it?
> thanks
>
> regards
>
>
> ----- Original Message -----
> From: "Hekuran Doli" <asterisk at ati-kos.com>
> To: <asterisk-users at lists.digium.com>
> Sent: Monday, June 21, 2004 9:23 AM
> Subject: [Asterisk-Users] Fixed! Midifyed-Prepaid-Application
>
>
>> Hi all
>> I fixed this problem I just Granted Privileges for ap_prepaid tables
>> and seems to work well.
>>
>> Thank you very much!
>>
>> Best Regards
>> Hekuran Doli
>>
>> > Thank you Alex.
>> > I just got an idea that something wrong is hapening with postgresql.
>> after I log_statement = true I got the following error that I didnt
>> understand why this could hapen couse I dont know postgresql to much
>> but Im trying to search in google. If any one couse help me to fix
>> this It would be so helpfull.
>> >
>> > LOG:  statement: SELECT 1
>> > LOG:  statement: SELECT * FROM asterisk_authenticate('22') AS
>> > authenticate(credit integer, tariffid integer, activated bool,
>> expired bool, cardid text)
>> > ERROR:  permission denied for relation cid
>> > CONTEXT:  PL/pgSQL function "asterisk_authenticate" line 8 at select
>> into variables
>> >
>> > Best Regards
>> > Hekuran
>> >
>> >
>> >> Try to debug postgresql query's done by app_prepaid...
>> >> set log_statement = true in postgresql.conf and watch postgresql
>> log's ..
>> >> maybe it can help you ...
>> >>
>> >> Alex
>> >>
>> >> On Sun, 2004-06-20 at 20:27 +0000, Hekuran Doli wrote:
>> >>> bill my local clients registred to my asterisk box using sip
>> >>
>> >>
>> >> _______________________________________________
>> >> Asterisk-Users mailing list
>> >> Asterisk-Users at lists.digium.com
>> >> http://lists.digium.com/mailman/listinfo/asterisk-users
>> >> To UNSUBSCRIBE or update options visit:
>> >>    http://lists.digium.com/mailman/listinfo/asterisk-users
>> >
>> >
>> >
>> > _______________________________________________
>> > Asterisk-Users mailing list
>> > Asterisk-Users at lists.digium.com
>> > http://lists.digium.com/mailman/listinfo/asterisk-users
>> > To UNSUBSCRIBE or update options visit:
>> >    http://lists.digium.com/mailman/listinfo/asterisk-users
>>
>>
>>
>> _______________________________________________
>> Asterisk-Users mailing list
>> Asterisk-Users at lists.digium.com
>> http://lists.digium.com/mailman/listinfo/asterisk-users
>> To UNSUBSCRIBE or update options visit:
>>    http://lists.digium.com/mailman/listinfo/asterisk-users
>>
>
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users