Voir les tables sip.. dans la base de donnee Mysql

[ds3]

!

http://www.voip-info.org/wiki/view/A...k+RealTime+Sip "`qualify` char(3) default NULL"
http://www.voip-info.org/wiki/view/Asterisk+sip+qualify

[khadija]

le champs " 'qualify` char(3) default NULL" est bien dans la table sip. Je crois pas que ca soit le probleme car je pense avoir bien configurer les principaux fichiers.
Bon voici ci-joint la configuration des fichiers extconfig.conf et res_mysql.conf peut etre sa pourrait vous aider.
extconfig.conf

; Static and realtime external configuration
; engine configuration
;
; Please read doc/extconfig.txt for basic table
; formatting information.
;
[settings]
;
; Static configuration files:
;
;file.conf => driver,database[,table]

;sip.conf => mysql,general,sip
;iax.conf => mysql,general,iax
;extensions.conf => mysql,general,extensions
;voicemail.conf => mysql,general,voicemail
;
; maps a particular configuration file to the given
; database driver, database and table (or uses the
; name of the file as the table if not specified)
;
;uncomment to load queues.conf via the odbc engine.
;
;queues.conf => odbc,asterisk,ast_config
;extensions.conf => sqlite,asterisk,ast_config
;
; The following files CANNOT be loaded from Realtime storage:
;       asterisk.conf
;       extconfig.conf (this file)
;       logger.conf
;
; Additionally, the following files cannot be loaded from
; Realtime storage unless the storage driver is loaded
; early using 'preload' statements in modules.conf:
;       manager.conf
;       cdr.conf
;       rtp.conf
; Realtime configuration engine
;
; maps a particular family of realtime
; configuration to a given database driver,
; database and table (or uses the name of
; the family if the table is not specified
;
;example => odbc,asterisk,alttable
;example2 => ldap,"dc=oxymium,dc=net",example2
;
; "odbc" is shown in the examples below, but is not the only valid realtime
; engine.  There is:
;    odbc ... res_config_odbc
;    sqlite ... res_config_sqlite
;    pgsql ... res_config_pgsql
;
;iaxusers => odbc,asterisk
;iaxpeers => odbc,asterisk
;sipusers => odbc,asterisk
;sippeers => odbc,asterisk
;sipregs => odbc,asterisk
;voicemail => odbc,asterisk
;extensions => odbc,asterisk
;meetme => mysql,general
;queues => odbc,asterisk
;queue_members => odbc,asterisk
;musiconhold => mysql,general
;queue_log => mysql,general
;
;
; While most dynamic realtime engines are automatically used when defined in
; this file, 'extensions', distinctively, is not.  To activate dynamic realtime
; extensions, you must turn them on in each respective context within
; extensions.conf with a switch statement.  The syntax is:
;      switch => Realtime/[[db_context@]tablename]/<opts>
; The only option available currently is the 'p' option, which disallows
; extension pattern queries to the database.  If you have no patterns defined
; in a particular context, this will save quite a bit of CPU time.  However,
; note that using dynamic realtime extensions is not recommended anymore as a
; proper data abstraction via a tool like func_odbc.


sipusers => mysql,general,sip
sippeers => mysql,general,sip
iaxusers => mysql,general,iax
iaxpeers => mysql,general,iax
extensions => mysql,general,extensions
;voicemail => mysql,general,voicemail
;meetme => mysql,general
;queues => mysql,general
;musiconhold => mysql,general

res_mysql.conf

[general]
dbhost = 127.0.0.1
dbname = asterisk
dbuser = root
dbpass =******
dbport = 3306
dbsock = /opt/lampp/var/mysql/mysql.sock

Merci de votre aide!

[khadija]

Je tiens aussi a preciser que j'ai intalle xampp serveur! Donc j'utilise son mysql!

[ds3]

Le problème n'est pas là, car tu te connectes bien à la DB, en effet, l'uptime de connexion et l'enregistrement de tes postes le confirment.

Et cette resquette donne quoi comme réponse sur ta base asterisk

SELECT * FROM `sip` WHERE `sip`.`qualify` IS NOT NULL

[khadija]

la commande donne:

mysql> SELECT * FROM sip WHERE qualify IS NOT NULL ;
Empty set (0,00 sec)

[ds3]

C'est amusant,

UPDATE `asterisk`.`sip` SET `qualify` = '150';

ensuite tu relances la précédente requête. Et tu me donnes le résultat.

J'anticipe il sera supérieur à 0, tu pourras recharger ton asterisk, patienter qq minutes et effectuer un "sip show peers" depuis la cli asterisk.

[khadija]

Confirme! la commande donne le resultat atendu :tous les comptes sip. Mais quand je relance asterisk et que je fais 'sip show peers' ca me renvoi comme toujours:

ubuntu*CLI> sip show peers
Name/username              Host            Dyn Nat ACL Port     Status     
0 sip peers [Monitored: 0 online, 0 offline Unmonitored: 0 online, 0 offline]
ubuntu*CLI>

Y'a plus de comptes sip car j'ai commente tous les comptes sip que j'avais cree dans sip.conf pour y voir plus claire.