Hi to everyone,
I am running successfuly ser+acc modul+serweb. I can login into serweb with user. But when I click on accounting I get message "No calls".
I can see INVITE and BYE in DB and they have right values in domain atribute. In attchment can by found example of select from acc table.
I searched mailing list but I did not find any helpful hint. Has anyone some idea where can be a probleom or what should I check?
Thanx,
Pali
Is the username you are using to log into serweb either admin or 122 and is the domain configured in serweb 10.0.0.8 ? If so, do you see any error messages related to serweb in the logs of apache ?
Jan.
On 07-10 17:14, Pali Majernik wrote:
Hi to everyone,
I am running successfuly ser+acc modul+serweb. I can login into serweb with user. But when I click on accounting I get message "No calls".
I can see INVITE and BYE in DB and they have right values in domain atribute. In attchment can by found example of select from acc table.
I searched mailing list but I did not find any helpful hint. Has anyone some idea where can be a probleom or what should I check?
Thanx,
Pali
+------------------------------------------------------+------------------------------------------------------+------------+------------+-----------------------------+-----------------------------+-------------------------+-------------------------+-------------------------------------------------+----------+------------+-----------------+-----------------+---------------------+----------------+ | sip_from | sip_to | sip_status | sip_method | i_uri | o_uri | from_uri | to_uri | sip_callid | username | domain | fromtag | totag | time | timestamp | +------------------------------------------------------+------------------------------------------------------+------------+------------+-----------------------------+-----------------------------+-------------------------+-------------------------+-------------------------------------------------+----------+------------+-----------------+-----------------+---------------------+----------------+ | Miroslav Prikryl sip:admin@10.0.0.8;tag=1174671694 | sip:122@10.0.0.8;tag=baaa69c833d77d3 | 200 | INVITE | sip:pali@elephant.itsluzby | sip:pali@10.0.0.162:5060 | sip:admin@10.0.0.8 | sip:122@10.0.0.8 | 07B8186D-175F-4943-8A04-C9418041F927@10.0.0.169 | admin | 10.0.0.8 | 1174671694 | baaa69c833d77d3 | 2004-09-26 11:35:25 | 20040926133525 | | Miroslav Prikryl sip:admin@10.0.0.8;tag=1174671694 | sip:122@10.0.0.8;tag=baaa69c833d77d3 | 200 | INVITE | sip:122@10.0.0.8 | sip:pali@elephant.itsluzby | sip:admin@10.0.0.8 | sip:122@10.0.0.8 | 07B8186D-175F-4943-8A04-C9418041F927@10.0.0.169 | admin | 10.0.0.8 | 1174671694 | baaa69c833d77d3 | 2004-09-26 11:35:25 | 20040926133525 | | Miroslav Prikryl sip:admin@10.0.0.8;tag=1174671694 | sip:122@10.0.0.8;tag=baaa69c833d77d3 | 200 | ACK | sip:pali@10.0.0.162:5060 | sip:pali@10.0.0.162:5060 | sip:admin@10.0.0.8 | sip:122@10.0.0.8 | 07B8186D-175F-4943-8A04-C9418041F927@10.0.0.169 | admin | 10.0.0.8 | 1174671694 | baaa69c833d77d3 | 2004-09-26 11:35:25 | 20040926133525 | | sip:122@10.0.0.8;tag=baaa69c833d77d3 | Miroslav Prikryl sip:admin@10.0.0.8;tag=1174671694 | 200 | BYE | sip:admin@10.0.0.169:5060 | sip:admin@10.0.0.169:5060 | sip:122@10.0.0.8 | sip:admin@10.0.0.8 | 07B8186D-175F-4943-8A04-C9418041F927@10.0.0.169 | 122 | 10.0.0.8 | baaa69c833d77d3 | 1174671694 | 2004-09-26 11:35:40 | 20040926133540 | | sip:122@10.0.0.8;tag=baaa69c833d77d3 | Miroslav Prikryl sip:admin@10.0.0.8;tag=1174671694 | 200 | BYE | sip:admin@10.0.0.169:5060 | sip:admin@10.0.0.169:5060 | sip:122@10.0.0.8 | sip:admin@10.0.0.8 | 07B8186D-175F-4943-8A04-C9418041F927@10.0.0.169 | 122 | 10.0.0.8 | baaa69c833d77d3 | 1174671694 | 2004-09-26 11:35:40 | 20040926133540 | | Miroslav Prikryl sip:admin@10.0.0.8;tag=985609223 | sip:122@10.0.0.8;tag=1b91bcfcfb2a7f7 | 200 | INVITE | sip:pali@elephant.itsluzby | sip:pali@10.0.0.162:5060 | sip:admin@10.0.0.8 | sip:122@10.0.0.8 | 35345F88-0BDE-4921-B785-A14FFF8320F9@10.0.0.169 | admin | 10.0.0.8 | 985609223 | 1b91bcfcfb2a7f7 | 2004-09-26 14:24:31 | 20040926162431 | | Miroslav Prikryl sip:admin@10.0.0.8;tag=985609223 | sip:122@10.0.0.8;tag=1b91bcfcfb2a7f7 | 200 | INVITE | sip:122@10.0.0.8 | sip:pali@elephant.itsluzby | sip:admin@10.0.0.8 | sip:122@10.0.0.8 | 35345F88-0BDE-4921-B785-A14FFF8320F9@10.0.0.169 | admin | 10.0.0.8 | 985609223 | 1b91bcfcfb2a7f7 | 2004-09-26 14:24:31 | 20040926162431 | | Miroslav Prikryl sip:admin@10.0.0.8;tag=985609223 | sip:122@10.0.0.8;tag=1b91bcfcfb2a7f7 | 200 | ACK | sip:pali@10.0.0.162:5060 | sip:pali@10.0.0.162:5060 | sip:admin@10.0.0.8 | sip:122@10.0.0.8 | 35345F88-0BDE-4921-B785-A14FFF8320F9@10.0.0.169 | admin | 10.0.0.8 | 985609223 | 1b91bcfcfb2a7f7 | 2004-09-26 14:24:31 | 20040926162431 | | sip:122@10.0.0.8;tag=1b91bcfcfb2a7f7 | Miroslav Prikryl sip:admin@10.0.0.8;tag=985609223 | 200 | BYE | sip:admin@10.0.0.169:5060 | sip:admin@10.0.0.169:5060 | sip:122@10.0.0.8 | sip:admin@10.0.0.8 | 35345F88-0BDE-4921-B785-A14FFF8320F9@10.0.0.169 | 122 | 10.0.0.8 | 1b91bcfcfb2a7f7 | 985609223 | 2004-09-26 14:24:52 | 20040926162452 | | sip:122@10.0.0.8;tag=1b91bcfcfb2a7f7 | Miroslav Prikryl sip:admin@10.0.0.8;tag=985609223 | 200 | BYE | sip:admin@10.0.0.169:5060 | sip:admin@10.0.0.169:5060 | sip:122@10.0.0.8 | sip:admin@10.0.0.8 | 35345F88-0BDE-4921-B785-A14FFF8320F9@10.0.0.169 | 122 | 10.0.0.8 | 1b91bcfcfb2a7f7 | 985609223 | 2004-09-26 14:24:52 | 20040926162452 | | sip:122@10.0.0.162:5060;tag=d9c9373da9dfda5 | sip:121@10.0.0.8 | 200 | INVITE | sip:admin@elephant.itsluzby | sip:admin@10.0.0.169:5060 | sip:122@10.0.0.162:5060 | sip:121@10.0.0.8 | cee7b3b9e425481250e22937f18fa52b@10.0.0.162 | 122 | 10.0.0.162 | d9c9373da9dfda5 | n/a | 2004-09-26 14:26:49 | 20040926162649 | | sip:122@10.0.0.162:5060;tag=d9c9373da9dfda5 | sip:121@10.0.0.8 | 200 | INVITE | sip:121@10.0.0.8 | sip:admin@elephant.itsluzby | sip:122@10.0.0.162:5060 | sip:121@10.0.0.8 | cee7b3b9e425481250e22937f18fa52b@10.0.0.162 | 122 | 10.0.0.162 | d9c9373da9dfda5 | n/a | 2004-09-26 14:26:49 | 20040926162649 | | sip:122@10.0.0.162:5060;tag=d9c9373da9dfda5 | sip:121@10.0.0.8 | 200 | ACK | sip:admin@10.0.0.169:5060 | sip:admin@10.0.0.169:5060 | sip:122@10.0.0.162:5060 | sip:121@10.0.0.8 | cee7b3b9e425481250e22937f18fa52b@10.0.0.162 | 122 | 10.0.0.162 | d9c9373da9dfda5 | n/a | 2004-09-26 14:26:49 | 20040926162649 | | sip:122@10.0.0.162:5060;tag=d9c9373da9dfda5 | sip:121@10.0.0.8 | 200 | ACK | sip:admin@10.0.0.169:5060 | sip:admin@10.0.0.169:5060 | sip:122@10.0.0.162:5060 | sip:121@10.0.0.8 | cee7b3b9e425481250e22937f18fa52b@10.0.0.162 | 122 | 10.0.0.162 | d9c9373da9dfda5 | n/a | 2004-09-26 14:26:49 | 20040926162649 | | sip:121@10.0.0.8 | sip:122@10.0.0.162:5060;tag=d9c9373da9dfda5 | 200 | INVITE | sip:10.0.0.162:5060 | sip:10.0.0.162:5060 | sip:121@10.0.0.8 | sip:122@10.0.0.162:5060 | cee7b3b9e425481250e22937f18fa52b@10.0.0.162 | 121 | 10.0.0.8 | n/a | d9c9373da9dfda5 | 2004-09-26 14:27:14 | 20040926162714 | | sip:121@10.0.0.8 | sip:122@10.0.0.162:5060;tag=d9c9373da9dfda5 | 200 | INVITE | sip:10.0.0.162:5060 | sip:10.0.0.162:5060 | sip:121@10.0.0.8 | sip:122@10.0.0.162:5060 | cee7b3b9e425481250e22937f18fa52b@10.0.0.162 | 121 | 10.0.0.8 | n/a | d9c9373da9dfda5 | 2004-09-26 14:27:14 | 20040926162714 | | sip:121@10.0.0.8 | sip:122@10.0.0.162:5060;tag=d9c9373da9dfda5 | 200 | ACK | sip:10.0.0.162:5060 | sip:10.0.0.162:5060 | sip:121@10.0.0.8 | sip:122@10.0.0.162:5060 | cee7b3b9e425481250e22937f18fa52b@10.0.0.162 | 121 | 10.0.0.8 | n/a | d9c9373da9dfda5 | 2004-09-26 14:27:14 | 20040926162714 | | sip:121@10.0.0.8 | sip:122@10.0.0.162:5060;tag=d9c9373da9dfda5 | 200 | INVITE | sip:10.0.0.162:5060 | sip:10.0.0.162:5060 | sip:121@10.0.0.8 | sip:122@10.0.0.162:5060 | cee7b3b9e425481250e22937f18fa52b@10.0.0.162 | 121 | 10.0.0.8 | n/a | d9c9373da9dfda5 | 2004-09-26 14:27:20 | 20040926162720 | | sip:121@10.0.0.8 | sip:122@10.0.0.162:5060;tag=d9c9373da9dfda5 | 200 | INVITE | sip:10.0.0.162:5060 | sip:10.0.0.162:5060 | sip:121@10.0.0.8 | sip:122@10.0.0.162:5060 | cee7b3b9e425481250e22937f18fa52b@10.0.0.162 | 121 | 10.0.0.8 | n/a | d9c9373da9dfda5 | 2004-09-26 14:27:20 | 20040926162720 | | sip:121@10.0.0.8 | sip:122@10.0.0.162:5060;tag=d9c9373da9dfda5 | 200 | ACK | sip:10.0.0.162:5060 | sip:10.0.0.162:5060 | sip:121@10.0.0.8 | sip:122@10.0.0.162:5060 | cee7b3b9e425481250e22937f18fa52b@10.0.0.162 | 121 | 10.0.0.8 | n/a | d9c9373da9dfda5 | 2004-09-26 14:27:20 | 20040926162720 | | sip:121@10.0.0.8 | sip:122@10.0.0.162:5060;tag=d9c9373da9dfda5 | 200 | BYE | sip:10.0.0.162:5060 | sip:10.0.0.162:5060 | sip:121@10.0.0.8 | sip:122@10.0.0.162:5060 | cee7b3b9e425481250e22937f18fa52b@10.0.0.162 | 121 | 10.0.0.8 | n/a | d9c9373da9dfda5 | 2004-09-26 14:27:21 | 20040926162721 | | sip:121@10.0.0.8 | sip:122@10.0.0.162:5060;tag=d9c9373da9dfda5 | 200 | BYE | sip:10.0.0.162:5060 | sip:10.0.0.162:5060 | sip:121@10.0.0.8 | sip:122@10.0.0.162:5060 | cee7b3b9e425481250e22937f18fa52b@10.0.0.162 | 121 | 10.0.0.8 | n/a | d9c9373da9dfda5 | 2004-09-26 14:27:21 | 20040926162721 | | Miroslav Prikryl sip:admin@10.0.0.8;tag=930062863 | sip:122@10.0.0.8;tag=c0331448fad88a8 | 200 | INVITE | sip:pali@elephant.itsluzby | sip:pali@10.0.0.162:5060 | sip:admin@10.0.0.8 | sip:122@10.0.0.8 | 56900B3F-0596-4846-A1B9-2044C009BE20@10.0.0.169 | admin | 10.0.0.8 | 930062863 | c0331448fad88a8 | 2004-10-07 10:52:31 | 20041007125231 | | Miroslav Prikryl sip:admin@10.0.0.8;tag=930062863 | sip:122@10.0.0.8;tag=c0331448fad88a8 | 200 | INVITE | sip:122@10.0.0.8 | sip:pali@elephant.itsluzby | sip:admin@10.0.0.8 | sip:122@10.0.0.8 | 56900B3F-0596-4846-A1B9-2044C009BE20@10.0.0.169 | admin | 10.0.0.8 | 930062863 | c0331448fad88a8 | 2004-10-07 10:52:31 | 20041007125231 | | Miroslav Prikryl sip:admin@10.0.0.8;tag=930062863 | sip:122@10.0.0.8;tag=c0331448fad88a8 | 200 | ACK | sip:pali@10.0.0.162:5060 | sip:pali@10.0.0.162:5060 | sip:admin@10.0.0.8 | sip:122@10.0.0.8 | 56900B3F-0596-4846-A1B9-2044C009BE20@10.0.0.169 | admin | 10.0.0.8 | 930062863 | c0331448fad88a8 | 2004-10-07 10:52:31 | 20041007125231 | | sip:122@10.0.0.8;tag=c0331448fad88a8 | Miroslav Prikryl sip:admin@10.0.0.8;tag=930062863 | 200 | BYE | sip:admin@10.0.0.169:5060 | sip:admin@10.0.0.169:5060 | sip:122@10.0.0.8 | sip:admin@10.0.0.8 | 56900B3F-0596-4846-A1B9-2044C009BE20@10.0.0.169 | 122 | 10.0.0.8 | c0331448fad88a8 | 930062863 | 2004-10-07 10:52:39 | 20041007125239 | | sip:122@10.0.0.8;tag=c0331448fad88a8 | Miroslav Prikryl sip:admin@10.0.0.8;tag=930062863 | 200 | BYE | sip:admin@10.0.0.169:5060 | sip:admin@10.0.0.169:5060 | sip:122@10.0.0.8 | sip:admin@10.0.0.8 | 56900B3F-0596-4846-A1B9-2044C009BE20@10.0.0.169 | 122 | 10.0.0.8 | c0331448fad88a8 | 930062863 | 2004-10-07 10:52:39 | 20041007125239 | | Miroslav Prikryl sip:admin@10.0.0.8;tag=423861825 | sip:122@10.0.0.8;tag=e042d356547c81c | 200 | INVITE | sip:pali@elephant.itsluzby | sip:pali@10.0.0.162:5060 | sip:admin@10.0.0.8 | sip:122@10.0.0.8 | E6E54B48-D020-42D5-BBF5-7D24019DCF4B@10.0.0.169 | admin | 10.0.0.8 | 423861825 | e042d356547c81c | 2004-10-07 12:50:35 | 20041007145035 | | Miroslav Prikryl sip:admin@10.0.0.8;tag=423861825 | sip:122@10.0.0.8;tag=e042d356547c81c | 200 | INVITE | sip:122@10.0.0.8 | sip:pali@elephant.itsluzby | sip:admin@10.0.0.8 | sip:122@10.0.0.8 | E6E54B48-D020-42D5-BBF5-7D24019DCF4B@10.0.0.169 | admin | 10.0.0.8 | 423861825 | e042d356547c81c | 2004-10-07 12:50:35 | 20041007145035 | | Miroslav Prikryl sip:admin@10.0.0.8;tag=423861825 | sip:122@10.0.0.8;tag=e042d356547c81c | 200 | ACK | sip:pali@10.0.0.162:5060 | sip:pali@10.0.0.162:5060 | sip:admin@10.0.0.8 | sip:122@10.0.0.8 | E6E54B48-D020-42D5-BBF5-7D24019DCF4B@10.0.0.169 | admin | 10.0.0.8 | 423861825 | e042d356547c81c | 2004-10-07 12:50:35 | 20041007145035 | | sip:122@10.0.0.8;tag=e042d356547c81c | Miroslav Prikryl sip:admin@10.0.0.8;tag=423861825 | 200 | BYE | sip:admin@10.0.0.169:5060 | sip:admin@10.0.0.169:5060 | sip:122@10.0.0.8 | sip:admin@10.0.0.8 | E6E54B48-D020-42D5-BBF5-7D24019DCF4B@10.0.0.169 | 122 | 10.0.0.8 | e042d356547c81c | 423861825 | 2004-10-07 12:50:42 | 20041007145042 | | sip:122@10.0.0.8;tag=e042d356547c81c | Miroslav Prikryl sip:admin@10.0.0.8;tag=423861825 | 200 | BYE | sip:admin@10.0.0.169:5060 | sip:admin@10.0.0.169:5060 | sip:122@10.0.0.8 | sip:admin@10.0.0.8 | E6E54B48-D020-42D5-BBF5-7D24019DCF4B@10.0.0.169 | 122 | 10.0.0.8 | e042d356547c81c | 423861825 | 2004-10-07 12:50:42 | 20041007145042 | +------------------------------------------------------+------------------------------------------------------+------------+------------+-----------------------------+-----------------------------+-------------------------+-------------------------+-------------------------------------------------+----------+------------+-----------------+-----------------+---------------------+----------------+
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers