How to register users from register

Suppose that you have this scenario: you want to register users from a database using PostgreSQL.

Startup configuration file

The main Yate startup configuration is stored in the file yate.conf.

Please notice that "yate.conf" under Windows has to be named "yate-service.conf" if you are running it as a service or "yate-console.conf" while running the console version.
In other words it has to match the executable file name or the file would not be loaded and default configuration will be applied.

Note: By default in Yate all modules are loaded at startup. By setting parameter modload to value no, the modules needed should be enabled by hand. 

File "yate.conf" controls the loading of modules in Yate. In your yate.conf these modules should be enabled by hand, only if you set modload=disable:

[default]
modload=disable

[modules]
;Module used to make the connection between Yate and the PostgreSQL database.
pgsqldb.yate=true 
;Module used do authenticate, register, route users in the database.  
register.yate=true

Create database

After creating your database with the tables that you need (here is an example of a database schema), you have to tell Yate what database to use.

Configure database in Yate

Set the name of the database

The module used is register.conf and in section [default] the name of the database connection must be set:

[default]
account=Database_Name

Set the connection information of database

In PostgreSQL configuration file: pgsqldb.conf we have to set the connection data for this database in a section that will have the same name as the account settled in register.conf:

[Database_Name]
host=
database=
user=
password=
  

After "=" you have to write your connection information.

Register users

See an example of database schema to keep the users.

In register.conf in section [general] the user.register must be enabled.

[general]
user.register=yes

[user.register]
query=UPDATE users SET location='${data}',expires=CURRENT_TIMESTAMP + INTERVAL '${expires} s' WHERE username='${username}'

See also

• Regfile
• MySQL