asterisk users - Feb 2008 - Asterisk reltime mode with Postgresql

Hi

I am having problems with Asterisk 1.4.18 and realtime architecture. I use
Postgresql-8.3 as the database.
Everything works OK; all sip phones (their configs are in the database) are
able to register to the server and I can make calls (dialplan is in the
database), but each time Asterisk reads the information from the database it
shows me this on the console:

[Feb 17 12:32:50] WARNING[620]: res_config_pgsql.c:207 realtime_pgsql:
Postgresql RealTime: Could not find any rows in table extensions_conf.
[Feb 17 12:32:50] WARNING[604]: res_config_pgsql.c:207 realtime_pgsql:
Postgresql RealTime: Could not find any rows in table sip_conf.
[Feb 17 12:32:50] WARNING[604]: res_config_pgsql.c:207 realtime_pgsql:
Postgresql RealTime: Could not find any rows in table sip_conf.
[Feb 17 12:32:50] WARNING[9219]: res_config_pgsql.c:207 realtime_pgsql:
Postgresql RealTime: Could not find any rows in table extensions_conf.
[Feb 17 12:32:50] WARNING[9219]: res_config_pgsql.c:207 realtime_pgsql:
Postgresql RealTime: Could not find any rows in table extensions_conf.
[Feb 17 12:32:51] WARNING[9219]: res_config_pgsql.c:207 realtime_pgsql:
Postgresql RealTime: Could not find any rows in table extensions_conf.
[Feb 17 12:32:51] WARNING[9219]: res_config_pgsql.c:207 realtime_pgsql:
Postgresql RealTime: Could not find any rows in table extensions_conf.

Like I said before everything seems to work fine, but why I get this
warnings. Is it a bug or I configure my server in a wrong way?

Cheers
Andrew
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20080217/521887b5/attachment.htm

Hello,

If you activate debug you will see that you get those warnings because 
Asterisk is trying to check users that only exist in the "sip.conf"
file.

PLL.

-------- Original Message --------
Subject: [asterisk-users] Asterisk reltime mode with Postgresql
From: Andrew Nowrot <andrew.nowrot at gmail.com>
To: Asterisk Users Mailing List - Non-Commercial Discussion 
<asterisk-users at lists.digium.com>
Date: 17/02/2008 07:16 a.m.
> Hi
>
> I am having problems with Asterisk 1.4.18 and realtime architecture. I 
> use Postgresql-8.3 as the database.
> Everything works OK; all sip phones (their configs are in the 
> database) are able to register to the server and I can make calls 
> (dialplan is in the database), but each time Asterisk reads the 
> information from the database it shows me this on the console:
>
> [Feb 17 12:32:50] WARNING[620]: res_config_pgsql.c:207 realtime_pgsql: 
> Postgresql RealTime: Could not find any rows in table extensions_conf.
> [Feb 17 12:32:50] WARNING[604]: res_config_pgsql.c:207 realtime_pgsql: 
> Postgresql RealTime: Could not find any rows in table sip_conf.
> [Feb 17 12:32:50] WARNING[604]: res_config_pgsql.c:207 realtime_pgsql: 
> Postgresql RealTime: Could not find any rows in table sip_conf.
> [Feb 17 12:32:50] WARNING[9219]: res_config_pgsql.c:207 
> realtime_pgsql: Postgresql RealTime: Could not find any rows in table 
> extensions_conf.
> [Feb 17 12:32:50] WARNING[9219]: res_config_pgsql.c:207 
> realtime_pgsql: Postgresql RealTime: Could not find any rows in table 
> extensions_conf.
> [Feb 17 12:32:51] WARNING[9219]: res_config_pgsql.c:207 
> realtime_pgsql: Postgresql RealTime: Could not find any rows in table 
> extensions_conf.
> [Feb 17 12:32:51] WARNING[9219]: res_config_pgsql.c:207 
> realtime_pgsql: Postgresql RealTime: Could not find any rows in table 
> extensions_conf.
>
> Like I said before everything seems to work fine, but why I get this 
> warnings. Is it a bug or I configure my server in a wrong way?
>
> Cheers
> Andrew
> ------------------------------------------------------------------------
>
> _______________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users

HI

Thanks for the reply

If you activate debug you will see that you get those warnings
because
> Asterisk is trying to check users that only exist in the
"sip.conf" file.
>
> OK, but could you be more specific. My sip.conf despite the general config
is completely empty. So what do you mean by "check users that only exist in
the sip.conf".
And what about the rows that can not be found in extensions_conf and iax
tables?

Cheers
Andrew
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20080218/6e0782eb/attachment.htm