-
...div class="content"><font class="modules-title">[[Modules#Database Drivers|Database Drivers]]</font></div>
8 KB (1,086 words) - 09:08, 31 July 2018
-
* register.conf - the users will be set in a database
...egister is used for autentication, registration, and routing of users from database.
3 KB (452 words) - 12:06, 11 April 2013
-
Module used to write CDR(Call Detail Record) data in the database.
Example of how to register users from a database.
3 KB (433 words) - 09:01, 10 March 2016
-
Naturally, instead of regfile.conf you can use the database module (register.conf), with the priorities set accordingly. Note, if you h
; don't waste resources querying the database if no credentials are provided
20 KB (3,110 words) - 10:27, 4 November 2013
-
...{oformats}''' in routing either in regexroute or in [[Register|register]] (database routing) to set the formats parameter:
2 KB (301 words) - 11:06, 3 April 2013
-
* is used for authentication, registration, and routing users stored in a database
...wikipedia.org/wiki/Call_detail_record CDR](Call Detail Record) data in the database
14 KB (2,155 words) - 10:47, 11 January 2014
-
Below you can find the database schema for PostgreSQL and MySQL for using yate's [[register]] module.
====Database schema====
7 KB (1,027 words) - 13:28, 6 August 2020
-
A demo query to return same from a database would be:
12 KB (1,844 words) - 11:24, 5 June 2014
-
Example of how to register users from a database.
How to write call logs to a database
9 KB (1,376 words) - 10:01, 27 October 2017
-
...figuration can be done also, if instead of using regfile.conf, you use the database module (register.conf), with the priorities set accordingly.
1 KB (151 words) - 13:58, 31 October 2013
-
Suppose that you have this scenario: you want to register users from a database using PostgreSQL.
;Module used to make the connection between Yate and the PostgreSQL database.
3 KB (440 words) - 13:59, 31 October 2013
-
:::Run a query in the database from message's parameters.
773 B (112 words) - 10:46, 21 January 2013
-
* '''auth_register'''=false - Disables handling by the [[register]] database module
2 KB (250 words) - 21:15, 13 March 2014
-
Initializing module Register for database
12 KB (1,986 words) - 15:13, 31 October 2013
-
The line tracker is used to maintain the list of call legs in the database.<br>
...n be configured in [[Modules#Database_Drivers| mysqldb.conf]] or [[Modules#Database_Drivers|pgsqldb.conf]]<br>
3 KB (472 words) - 09:00, 4 November 2013
-
Play or record to a binary database record
Route from a database
12 KB (1,662 words) - 13:25, 1 October 2019
-
This module works with [[wavefile]] module and a database driver, currently only [[MySQL]].
... is used to play or record wave sounds. The wave sounds are kept in binary database records.
3 KB (409 words) - 10:10, 4 November 2013
-
==Database storage and access configuration==
...d to make the connection between Yate and one or more PostgreSQL(or MySQL) databases.
7 KB (1,026 words) - 09:22, 4 November 2013
-
* [[Register]] - Authenticate users and write users location to database
* [[PostgreSQL]] or [[MySQL]] - Database access
21 KB (3,052 words) - 09:24, 4 November 2013
-
...ldb is used to make the connection between Yate and one or more PostgreSQL databases.
...tGreSQL is loaded. It is required to be loaded so that Yate can connect to database.
5 KB (763 words) - 07:19, 10 June 2014
-
This module configures the database account name and users management (add, update, remove and retrieve queries
'''Note:''' All database queries are done with PostgreSQL.
3 KB (394 words) - 12:51, 5 June 2013
-
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
6 KB (835 words) - 15:05, 7 April 2015
-
... 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.
5 KB (810 words) - 11:18, 4 November 2013
-
...ed from regexroute, for example to be routed via the register module / the database or other modules.
3 KB (419 words) - 14:03, 31 October 2013
-
...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]].
10 KB (1,558 words) - 13:22, 13 January 2014
-
Caches can be loaded from database or saved to database.
; loadchunk: integer: The number of items to load in a database request
12 KB (1,922 words) - 10:32, 4 November 2013
-
...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.
4 KB (575 words) - 11:09, 4 November 2013
-
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.
2 KB (283 words) - 11:10, 4 November 2013
-
* ''general'' - used to configure the account for the queries in database;
; account: string: The account used to query the database
2 KB (269 words) - 11:20, 4 November 2013
-
* ''database'' keeps the database account name for connection purpose, and does the select, insert , update a
[database]
3 KB (448 words) - 11:20, 4 November 2013
-
; (e.g. disable the whole database status traps by adding database.*)
11 KB (1,779 words) - 11:28, 4 November 2013
-
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
4 KB (706 words) - 11:47, 19 December 2022
-
* database account
[database]
5 KB (817 words) - 11:29, 4 November 2013
-
...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
7 KB (1,094 words) - 12:55, 11 January 2014
-
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 [
5 KB (888 words) - 13:05, 10 March 2015
-
* [[database]]
3 KB (329 words) - 08:19, 25 May 2018
-
'''database''' is used by various modules to request a database query operation.
: Name that identifies a connection to a database server.
1 KB (163 words) - 10:58, 23 January 2013
-
...ieve. A query like name=databaseCount will ask for the number of monitored database accounts.
912 B (154 words) - 11:00, 23 January 2013
-
* [[How to access a database from Yate's Javascript module]]
Accessing the database from javascript module.
4 KB (524 words) - 09:01, 10 March 2016
-
:*If you want to register users in a database you need libraries like:
10 KB (1,738 words) - 12:55, 25 February 2014
-
:*If you want to register users in a database you need libraries like:
6 KB (962 words) - 11:10, 30 January 2014
-
:*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
3 KB (514 words) - 09:38, 4 November 2013
-
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 [
6 KB (967 words) - 14:56, 8 January 2014
-
* [[database]]
257 B (37 words) - 10:58, 23 January 2013
-
====Parameters for database module:====
'''database.'''
826 B (113 words) - 16:00, 18 January 2013
-
...sage with operation: '''delete'''.The user is removed from memory and from database.<br>
1,015 B (147 words) - 15:37, 18 January 2013
-
* [[How to access a database from Yate's Javascript module]]
Accessing the database from javascript module.
2 KB (323 words) - 09:50, 21 August 2017
-
To interact with databases the Javascript module uses Yate's database connections.<br>
To make a query you must send a ''[[database]]'' message.<br>
4 KB (563 words) - 13:35, 31 October 2013
-
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
3 KB (468 words) - 09:42, 20 May 2013
-
...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.
5 KB (887 words) - 14:05, 31 October 2013
-
...assumed that you have set an account in Yate, if you write your CDR in the database.
====In database====
3 KB (495 words) - 14:44, 31 October 2013
-
name=mysqldb,type=database,format=Total|Failed|Errors|AvgExecTime;conns=1,failed=0;my_database=1|0|0|1
7 KB (905 words) - 15:03, 14 October 2016
-
... logs to a file|in a file]] or in the [[#Writing call logs to the database|database]].
====Writing call logs to the database====
4 KB (501 words) - 15:47, 31 October 2013
-
Naturally, instead of regfile.conf you can use the database module (register.conf), with the priorities set accordingly.
6 KB (833 words) - 15:07, 31 October 2013
-
...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.
4 KB (715 words) - 15:20, 31 October 2013
-
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).
4 KB (587 words) - 08:36, 4 November 2013
-
...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]]===
19 KB (3,169 words) - 11:20, 16 September 2013
-
...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:
5 KB (739 words) - 15:42, 31 October 2013
-
The Javascript db_client class eases work with a database. Thanks Ximik777 :)
// db_client('use account name', 'database module, default pgsql');
7 KB (1,031 words) - 13:44, 26 February 2014
-
Feature used in a routing module that allows Yate to query CNAM and LNP databases over the SIP protocol.
8 KB (1,083 words) - 11:49, 27 October 2017
-
...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
4 KB (547 words) - 10:52, 20 March 2013
-
...//en.wikipedia.org/wiki/Local_number_portability Local Number Portability] databases over the SIP protocol.
5 KB (700 words) - 10:31, 4 November 2013
