[Serusers] SERweb accounting displays "No calls"

Jan Janak jan at iptel.org
Fri Oct 8 11:24:31 CEST 2004


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 at 10.0.0.8>;tag=1174671694 | <sip:122 at 10.0.0.8>;tag=baaa69c833d77d3               | 200        | INVITE     | sip:pali at elephant.itsluzby  | sip:pali at 10.0.0.162:5060    | sip:admin at 10.0.0.8      | sip:122 at 10.0.0.8        | 07B8186D-175F-4943-8A04-C9418041F927 at 10.0.0.169 | admin    | 10.0.0.8   | 1174671694      | baaa69c833d77d3 | 2004-09-26 11:35:25 | 20040926133525 |
> | Miroslav Prikryl <sip:admin at 10.0.0.8>;tag=1174671694 | <sip:122 at 10.0.0.8>;tag=baaa69c833d77d3               | 200        | INVITE     | sip:122 at 10.0.0.8            | sip:pali at elephant.itsluzby  | sip:admin at 10.0.0.8      | sip:122 at 10.0.0.8        | 07B8186D-175F-4943-8A04-C9418041F927 at 10.0.0.169 | admin    | 10.0.0.8   | 1174671694      | baaa69c833d77d3 | 2004-09-26 11:35:25 | 20040926133525 |
> | Miroslav Prikryl <sip:admin at 10.0.0.8>;tag=1174671694 | <sip:122 at 10.0.0.8>;tag=baaa69c833d77d3               | 200        | ACK        | sip:pali at 10.0.0.162:5060    | sip:pali at 10.0.0.162:5060    | sip:admin at 10.0.0.8      | sip:122 at 10.0.0.8        | 07B8186D-175F-4943-8A04-C9418041F927 at 10.0.0.169 | admin    | 10.0.0.8   | 1174671694      | baaa69c833d77d3 | 2004-09-26 11:35:25 | 20040926133525 |
> | <sip:122 at 10.0.0.8>;tag=baaa69c833d77d3               | Miroslav Prikryl <sip:admin at 10.0.0.8>;tag=1174671694 | 200        | BYE        | sip:admin at 10.0.0.169:5060   | sip:admin at 10.0.0.169:5060   | sip:122 at 10.0.0.8        | sip:admin at 10.0.0.8      | 07B8186D-175F-4943-8A04-C9418041F927 at 10.0.0.169 | 122      | 10.0.0.8   | baaa69c833d77d3 | 1174671694      | 2004-09-26 11:35:40 | 20040926133540 |
> | <sip:122 at 10.0.0.8>;tag=baaa69c833d77d3               | Miroslav Prikryl <sip:admin at 10.0.0.8>;tag=1174671694 | 200        | BYE        | sip:admin at 10.0.0.169:5060   | sip:admin at 10.0.0.169:5060   | sip:122 at 10.0.0.8        | sip:admin at 10.0.0.8      | 07B8186D-175F-4943-8A04-C9418041F927 at 10.0.0.169 | 122      | 10.0.0.8   | baaa69c833d77d3 | 1174671694      | 2004-09-26 11:35:40 | 20040926133540 |
> | Miroslav Prikryl <sip:admin at 10.0.0.8>;tag=985609223  | <sip:122 at 10.0.0.8>;tag=1b91bcfcfb2a7f7               | 200        | INVITE     | sip:pali at elephant.itsluzby  | sip:pali at 10.0.0.162:5060    | sip:admin at 10.0.0.8      | sip:122 at 10.0.0.8        | 35345F88-0BDE-4921-B785-A14FFF8320F9 at 10.0.0.169 | admin    | 10.0.0.8   | 985609223       | 1b91bcfcfb2a7f7 | 2004-09-26 14:24:31 | 20040926162431 |
> | Miroslav Prikryl <sip:admin at 10.0.0.8>;tag=985609223  | <sip:122 at 10.0.0.8>;tag=1b91bcfcfb2a7f7               | 200        | INVITE     | sip:122 at 10.0.0.8            | sip:pali at elephant.itsluzby  | sip:admin at 10.0.0.8      | sip:122 at 10.0.0.8        | 35345F88-0BDE-4921-B785-A14FFF8320F9 at 10.0.0.169 | admin    | 10.0.0.8   | 985609223       | 1b91bcfcfb2a7f7 | 2004-09-26 14:24:31 | 20040926162431 |
> | Miroslav Prikryl <sip:admin at 10.0.0.8>;tag=985609223  | <sip:122 at 10.0.0.8>;tag=1b91bcfcfb2a7f7               | 200        | ACK        | sip:pali at 10.0.0.162:5060    | sip:pali at 10.0.0.162:5060    | sip:admin at 10.0.0.8      | sip:122 at 10.0.0.8        | 35345F88-0BDE-4921-B785-A14FFF8320F9 at 10.0.0.169 | admin    | 10.0.0.8   | 985609223       | 1b91bcfcfb2a7f7 | 2004-09-26 14:24:31 | 20040926162431 |
> | <sip:122 at 10.0.0.8>;tag=1b91bcfcfb2a7f7               | Miroslav Prikryl <sip:admin at 10.0.0.8>;tag=985609223  | 200        | BYE        | sip:admin at 10.0.0.169:5060   | sip:admin at 10.0.0.169:5060   | sip:122 at 10.0.0.8        | sip:admin at 10.0.0.8      | 35345F88-0BDE-4921-B785-A14FFF8320F9 at 10.0.0.169 | 122      | 10.0.0.8   | 1b91bcfcfb2a7f7 | 985609223       | 2004-09-26 14:24:52 | 20040926162452 |
> | <sip:122 at 10.0.0.8>;tag=1b91bcfcfb2a7f7               | Miroslav Prikryl <sip:admin at 10.0.0.8>;tag=985609223  | 200        | BYE        | sip:admin at 10.0.0.169:5060   | sip:admin at 10.0.0.169:5060   | sip:122 at 10.0.0.8        | sip:admin at 10.0.0.8      | 35345F88-0BDE-4921-B785-A14FFF8320F9 at 10.0.0.169 | 122      | 10.0.0.8   | 1b91bcfcfb2a7f7 | 985609223       | 2004-09-26 14:24:52 | 20040926162452 |
> | sip:122 at 10.0.0.162:5060;tag=d9c9373da9dfda5          | sip:121 at 10.0.0.8                                     | 200        | INVITE     | sip:admin at elephant.itsluzby | sip:admin at 10.0.0.169:5060   | sip:122 at 10.0.0.162:5060 | sip:121 at 10.0.0.8        | cee7b3b9e425481250e22937f18fa52b at 10.0.0.162     | 122      | 10.0.0.162 | d9c9373da9dfda5 | n/a             | 2004-09-26 14:26:49 | 20040926162649 |
> | sip:122 at 10.0.0.162:5060;tag=d9c9373da9dfda5          | sip:121 at 10.0.0.8                                     | 200        | INVITE     | sip:121 at 10.0.0.8            | sip:admin at elephant.itsluzby | sip:122 at 10.0.0.162:5060 | sip:121 at 10.0.0.8        | cee7b3b9e425481250e22937f18fa52b at 10.0.0.162     | 122      | 10.0.0.162 | d9c9373da9dfda5 | n/a             | 2004-09-26 14:26:49 | 20040926162649 |
> | sip:122 at 10.0.0.162:5060;tag=d9c9373da9dfda5          | sip:121 at 10.0.0.8                                     | 200        | ACK        | sip:admin at 10.0.0.169:5060   | sip:admin at 10.0.0.169:5060   | sip:122 at 10.0.0.162:5060 | sip:121 at 10.0.0.8        | cee7b3b9e425481250e22937f18fa52b at 10.0.0.162     | 122      | 10.0.0.162 | d9c9373da9dfda5 | n/a             | 2004-09-26 14:26:49 | 20040926162649 |
> | sip:122 at 10.0.0.162:5060;tag=d9c9373da9dfda5          | sip:121 at 10.0.0.8                                     | 200        | ACK        | sip:admin at 10.0.0.169:5060   | sip:admin at 10.0.0.169:5060   | sip:122 at 10.0.0.162:5060 | sip:121 at 10.0.0.8        | cee7b3b9e425481250e22937f18fa52b at 10.0.0.162     | 122      | 10.0.0.162 | d9c9373da9dfda5 | n/a             | 2004-09-26 14:26:49 | 20040926162649 |
> | sip:121 at 10.0.0.8                                     | sip:122 at 10.0.0.162:5060;tag=d9c9373da9dfda5          | 200        | INVITE     | sip:10.0.0.162:5060         | sip:10.0.0.162:5060         | sip:121 at 10.0.0.8        | sip:122 at 10.0.0.162:5060 | cee7b3b9e425481250e22937f18fa52b at 10.0.0.162     | 121      | 10.0.0.8   | n/a             | d9c9373da9dfda5 | 2004-09-26 14:27:14 | 20040926162714 |
> | sip:121 at 10.0.0.8                                     | sip:122 at 10.0.0.162:5060;tag=d9c9373da9dfda5          | 200        | INVITE     | sip:10.0.0.162:5060         | sip:10.0.0.162:5060         | sip:121 at 10.0.0.8        | sip:122 at 10.0.0.162:5060 | cee7b3b9e425481250e22937f18fa52b at 10.0.0.162     | 121      | 10.0.0.8   | n/a             | d9c9373da9dfda5 | 2004-09-26 14:27:14 | 20040926162714 |
> | sip:121 at 10.0.0.8                                     | sip:122 at 10.0.0.162:5060;tag=d9c9373da9dfda5          | 200        | ACK        | sip:10.0.0.162:5060         | sip:10.0.0.162:5060         | sip:121 at 10.0.0.8        | sip:122 at 10.0.0.162:5060 | cee7b3b9e425481250e22937f18fa52b at 10.0.0.162     | 121      | 10.0.0.8   | n/a             | d9c9373da9dfda5 | 2004-09-26 14:27:14 | 20040926162714 |
> | sip:121 at 10.0.0.8                                     | sip:122 at 10.0.0.162:5060;tag=d9c9373da9dfda5          | 200        | INVITE     | sip:10.0.0.162:5060         | sip:10.0.0.162:5060         | sip:121 at 10.0.0.8        | sip:122 at 10.0.0.162:5060 | cee7b3b9e425481250e22937f18fa52b at 10.0.0.162     | 121      | 10.0.0.8   | n/a             | d9c9373da9dfda5 | 2004-09-26 14:27:20 | 20040926162720 |
> | sip:121 at 10.0.0.8                                     | sip:122 at 10.0.0.162:5060;tag=d9c9373da9dfda5          | 200        | INVITE     | sip:10.0.0.162:5060         | sip:10.0.0.162:5060         | sip:121 at 10.0.0.8        | sip:122 at 10.0.0.162:5060 | cee7b3b9e425481250e22937f18fa52b at 10.0.0.162     | 121      | 10.0.0.8   | n/a             | d9c9373da9dfda5 | 2004-09-26 14:27:20 | 20040926162720 |
> | sip:121 at 10.0.0.8                                     | sip:122 at 10.0.0.162:5060;tag=d9c9373da9dfda5          | 200        | ACK        | sip:10.0.0.162:5060         | sip:10.0.0.162:5060         | sip:121 at 10.0.0.8        | sip:122 at 10.0.0.162:5060 | cee7b3b9e425481250e22937f18fa52b at 10.0.0.162     | 121      | 10.0.0.8   | n/a             | d9c9373da9dfda5 | 2004-09-26 14:27:20 | 20040926162720 |
> | sip:121 at 10.0.0.8                                     | sip:122 at 10.0.0.162:5060;tag=d9c9373da9dfda5          | 200        | BYE        | sip:10.0.0.162:5060         | sip:10.0.0.162:5060         | sip:121 at 10.0.0.8        | sip:122 at 10.0.0.162:5060 | cee7b3b9e425481250e22937f18fa52b at 10.0.0.162     | 121      | 10.0.0.8   | n/a             | d9c9373da9dfda5 | 2004-09-26 14:27:21 | 20040926162721 |
> | sip:121 at 10.0.0.8                                     | sip:122 at 10.0.0.162:5060;tag=d9c9373da9dfda5          | 200        | BYE        | sip:10.0.0.162:5060         | sip:10.0.0.162:5060         | sip:121 at 10.0.0.8        | sip:122 at 10.0.0.162:5060 | cee7b3b9e425481250e22937f18fa52b at 10.0.0.162     | 121      | 10.0.0.8   | n/a             | d9c9373da9dfda5 | 2004-09-26 14:27:21 | 20040926162721 |
> | Miroslav Prikryl <sip:admin at 10.0.0.8>;tag=930062863  | <sip:122 at 10.0.0.8>;tag=c0331448fad88a8               | 200        | INVITE     | sip:pali at elephant.itsluzby  | sip:pali at 10.0.0.162:5060    | sip:admin at 10.0.0.8      | sip:122 at 10.0.0.8        | 56900B3F-0596-4846-A1B9-2044C009BE20 at 10.0.0.169 | admin    | 10.0.0.8   | 930062863       | c0331448fad88a8 | 2004-10-07 10:52:31 | 20041007125231 |
> | Miroslav Prikryl <sip:admin at 10.0.0.8>;tag=930062863  | <sip:122 at 10.0.0.8>;tag=c0331448fad88a8               | 200        | INVITE     | sip:122 at 10.0.0.8            | sip:pali at elephant.itsluzby  | sip:admin at 10.0.0.8      | sip:122 at 10.0.0.8        | 56900B3F-0596-4846-A1B9-2044C009BE20 at 10.0.0.169 | admin    | 10.0.0.8   | 930062863       | c0331448fad88a8 | 2004-10-07 10:52:31 | 20041007125231 |
> | Miroslav Prikryl <sip:admin at 10.0.0.8>;tag=930062863  | <sip:122 at 10.0.0.8>;tag=c0331448fad88a8               | 200        | ACK        | sip:pali at 10.0.0.162:5060    | sip:pali at 10.0.0.162:5060    | sip:admin at 10.0.0.8      | sip:122 at 10.0.0.8        | 56900B3F-0596-4846-A1B9-2044C009BE20 at 10.0.0.169 | admin    | 10.0.0.8   | 930062863       | c0331448fad88a8 | 2004-10-07 10:52:31 | 20041007125231 |
> | <sip:122 at 10.0.0.8>;tag=c0331448fad88a8               | Miroslav Prikryl <sip:admin at 10.0.0.8>;tag=930062863  | 200        | BYE        | sip:admin at 10.0.0.169:5060   | sip:admin at 10.0.0.169:5060   | sip:122 at 10.0.0.8        | sip:admin at 10.0.0.8      | 56900B3F-0596-4846-A1B9-2044C009BE20 at 10.0.0.169 | 122      | 10.0.0.8   | c0331448fad88a8 | 930062863       | 2004-10-07 10:52:39 | 20041007125239 |
> | <sip:122 at 10.0.0.8>;tag=c0331448fad88a8               | Miroslav Prikryl <sip:admin at 10.0.0.8>;tag=930062863  | 200        | BYE        | sip:admin at 10.0.0.169:5060   | sip:admin at 10.0.0.169:5060   | sip:122 at 10.0.0.8        | sip:admin at 10.0.0.8      | 56900B3F-0596-4846-A1B9-2044C009BE20 at 10.0.0.169 | 122      | 10.0.0.8   | c0331448fad88a8 | 930062863       | 2004-10-07 10:52:39 | 20041007125239 |
> | Miroslav Prikryl <sip:admin at 10.0.0.8>;tag=423861825  | <sip:122 at 10.0.0.8>;tag=e042d356547c81c               | 200        | INVITE     | sip:pali at elephant.itsluzby  | sip:pali at 10.0.0.162:5060    | sip:admin at 10.0.0.8      | sip:122 at 10.0.0.8        | E6E54B48-D020-42D5-BBF5-7D24019DCF4B at 10.0.0.169 | admin    | 10.0.0.8   | 423861825       | e042d356547c81c | 2004-10-07 12:50:35 | 20041007145035 |
> | Miroslav Prikryl <sip:admin at 10.0.0.8>;tag=423861825  | <sip:122 at 10.0.0.8>;tag=e042d356547c81c               | 200        | INVITE     | sip:122 at 10.0.0.8            | sip:pali at elephant.itsluzby  | sip:admin at 10.0.0.8      | sip:122 at 10.0.0.8        | E6E54B48-D020-42D5-BBF5-7D24019DCF4B at 10.0.0.169 | admin    | 10.0.0.8   | 423861825       | e042d356547c81c | 2004-10-07 12:50:35 | 20041007145035 |
> | Miroslav Prikryl <sip:admin at 10.0.0.8>;tag=423861825  | <sip:122 at 10.0.0.8>;tag=e042d356547c81c               | 200        | ACK        | sip:pali at 10.0.0.162:5060    | sip:pali at 10.0.0.162:5060    | sip:admin at 10.0.0.8      | sip:122 at 10.0.0.8        | E6E54B48-D020-42D5-BBF5-7D24019DCF4B at 10.0.0.169 | admin    | 10.0.0.8   | 423861825       | e042d356547c81c | 2004-10-07 12:50:35 | 20041007145035 |
> | <sip:122 at 10.0.0.8>;tag=e042d356547c81c               | Miroslav Prikryl <sip:admin at 10.0.0.8>;tag=423861825  | 200        | BYE        | sip:admin at 10.0.0.169:5060   | sip:admin at 10.0.0.169:5060   | sip:122 at 10.0.0.8        | sip:admin at 10.0.0.8      | E6E54B48-D020-42D5-BBF5-7D24019DCF4B at 10.0.0.169 | 122      | 10.0.0.8   | e042d356547c81c | 423861825       | 2004-10-07 12:50:42 | 20041007145042 |
> | <sip:122 at 10.0.0.8>;tag=e042d356547c81c               | Miroslav Prikryl <sip:admin at 10.0.0.8>;tag=423861825  | 200        | BYE        | sip:admin at 10.0.0.169:5060   | sip:admin at 10.0.0.169:5060   | sip:122 at 10.0.0.8        | sip:admin at 10.0.0.8      | E6E54B48-D020-42D5-BBF5-7D24019DCF4B at 10.0.0.169 | 122      | 10.0.0.8   | e042d356547c81c | 423861825       | 2004-10-07 12:50:42 | 20041007145042 |
> +------------------------------------------------------+------------------------------------------------------+------------+------------+-----------------------------+-----------------------------+-------------------------+-------------------------+-------------------------------------------------+----------+------------+-----------------+-----------------+---------------------+----------------+

> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers




More information about the sr-users mailing list