Hi all I have installed dhe modifyed prepaid application and pouplated the database to. the authentication works fine also the read credit but I cant send calls, I think there is some missconfiguration with providers table. I get the following logs from postgresql:
LOG: statement: SELECT * FROM asterisk_authenticate('23') AS authenticate(credit integer, tariffid integer, activated bool, expired bool, cardid text) LOG: statement: SELECT stoptime is NULL FROM card left join cid USING(cidid) left join call USING(cardid) WHERE stoptime is NULL and cid='23' and not (starttime is NULL) LOG: statement: SELECT 1 LOG: statement: SELECT * FROM asterisk_authorize(1,'37744387555') AS authorize(rate integer, tariffrateid integer, prefix text, tech text, ipaddress text, providerid integer, countryprefixid integer) LOG: statement: SELECT 1 LOG: statement: SELECT asterisk_acct_start('1087916518.15','SIP/23-3328','23','2004-06-22 17:02:17',135236120,135225320,79,'') ERROR: insert or update on table "call" violates foreign key constraint "providerid_fkey" DETAIL: Key (providerid)=(135236120) is not present in table "provider". LOG: statement: SELECT 1 LOG: statement: SELECT asterisk_acct_stop('1087916518.15','19','ANSWERED','2004-06-22 17:02:17') I send outbound calls from extensions.conf in this structure: exten => _0.,2,Dial(h323/${CALLERID}#${EXTEN:[EMAIL PROTECTED]) Best Regards Hekuran _______________________________________________ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users