Search results

This module configures the database account name and users management (add, update, remove and retrieve queries '''Note:''' All database queries are done with PostgreSQL.

This module permit to configure the database account name and queries used to retrieve and update users' roster.<br> You can use database stored procedures to make sure that the update is done for the existing row

... mysqldb is used to make the connection between Yate and one or more MySQL databases. This module supports connection pool and maintains connection to database alive.

...ed from regexroute, for example to be routed via the register module / the database or other modules.

...rites in file, [[Register#Section_.5Bcall.cdr.5D|register]] that writes in database).<br/> ... are used to write them [[CDR_File_Module|in a file]] or in the [[Register|database]].

Caches can be loaded from database or saved to database. ; loadchunk: integer: The number of items to load in a database request

...euing of incoming calls and distribution of these calls to operators using database queries. ...u can use [[PostgreSQL]] or [[MySQL]]. Please see the requirements for the database module chosen.

This module makes multi routing from a database. The file used for configuration is: dbpbx.conf. ...u can use [[PostgreSQL]] or [[MySQL]]. Please see the requirements for the database module chosen.

* ''general'' - used to configure the account for the queries in database; ; account: string: The account used to query the database

* ''database'' keeps the database account name for connection purpose, and does the select, insert , update a [database]

; (e.g. disable the whole database status traps by adding database.*)

Starting with '''SVN Rev. 2433''' (2009-01-13) very long values (like database queries) can be broken over several lines by placing a backslash at the end

* database account [database]

...ither '''files''' using [[CDR File Module|cdrfile]], or inserted into a '''database''' using [[register]]. ...e, you will need to use '''cdrfile.conf'''. If you wish to store CDRs in a database you will need to edit either '''mysqldb.conf''' or '''pgsqldb.conf''', for

There is another way of adding users if you wish to use a database, the file to use is [[Register|register.conf]]. To register users in a database you can use [[Register|register.conf]]. And then make your route rules in [

* [[database]]

'''database''' is used by various modules to request a database query operation. : Name that identifies a connection to a database server.

...ieve. A query like name=databaseCount will ask for the number of monitored database accounts.

* [[How to access a database from Yate's Javascript module]] Accessing the database from javascript module.

:*If you want to register users in a database you need libraries like:

:*If you want to register users in a database you need libraries like:

:*If you want to register users in a database you need libraries like: If you wish to keep your users in PostgreSQL database use --with-libpq to give the path for the library because the default is /u

There is another way of adding users if you wish to use a database, the file to use is [[Register|register.conf]]. To register users in a database you can use [[Register|register.conf]]. And then make your route rules in [

* [[database]]

====Parameters for database module:==== '''database.'''

...sage with operation: '''delete'''.The user is removed from memory and from database.<br>

* [[How to access a database from Yate's Javascript module]] Accessing the database from javascript module.

To interact with databases the Javascript module uses Yate's database connections.<br> To make a query you must send a ''[[database]]'' message.<br>

In the script you can check the identity of the caller from the database and if he has a conference scheduled then send him to conference room, else

...ng applications based on it. Most of the applications require the use of a database. ...n file is register.conf. It also allows to write the cdr(call logs) in the database.

...assumed that you have set an account in Yate, if you write your CDR in the database. ====In database====

name=mysqldb,type=database,format=Total|Failed|Errors|AvgExecTime;conns=1,failed=0;my_database=1|0|0|1

... logs to a file|in a file]] or in the [[#Writing call logs to the database|database]]. ====Writing call logs to the database====

Naturally, instead of regfile.conf you can use the database module (register.conf), with the priorities set accordingly.

...t most of the time this won't be enough. The rules are usually stored in a database so routing would have to be implemented in [[register]] module or custom [[ ...euing of incoming calls and distribution of these calls to operators using database queries.

Follow this article to find what you should do if you suspect that yate's database connection is not opened.<br/> Your register.conf should include a reference to the database connection you are going to use (account=yateadmin).

...sire. The IVR concept can be used in more complex applications integrating databases, speech recognition and others. ===[[How to route and bill from a database|Prepaid and postpaid cards system]]===

...sides this you will need to add the logic that takes the messages from the database and sends them. In mysqldb.conf define the database account:

The Javascript db_client class eases work with a database. Thanks Ximik777 :) // db_client('use account name', 'database module, default pgsql');

Feature used in a routing module that allows Yate to query CNAM and LNP databases over the SIP protocol.

...tions, base stations, communication links, switching center(s) and network databases which can be linked to other systems and networks as you can see in the sc

...//en.wikipedia.org/wiki/Local_number_portability Local Number Portability] databases over the SIP protocol.