How to register users from register - Revision history

Monica at 13:59, 31 October 2013

2013-10-31T13:59:26Z

2013-05-27T14:20:38Z

‎Register users

2013-04-05T12:11:57Z

‎Register users

2013-04-05T12:05:58Z

2013-04-05T11:59:30Z

‎Create database

2013-04-05T11:52:17Z

‎Startup configuration file

2013-04-05T11:19:22Z

2013-04-05T11:18:03Z

2013-04-05T08:40:50Z

‎Enable modules

2012-12-11T10:39:55Z

‎Set the connection information of database

← Older revision		Revision as of 13:59, 31 October 2013
Line 70:		Line 70:
	* [[PostgreSQL]]		* [[PostgreSQL]]
	* [[Routing]]		* [[Routing]]
		+
		+	[[Category:Registration]] [[Category:Database]] [[Category:Users]]

← Older revision		Revision as of 14:20, 27 May 2013
Line 69:		Line 69:
	* [[Register\|Register module]] - authenticate, register and route users from database.		* [[Register\|Register module]] - authenticate, register and route users from database.
	* [[PostgreSQL]]		* [[PostgreSQL]]
		+	* [[Routing]]

@@ Line 66: / Line 66: @@
 '''See also'''
-* [[Regfile]]
+* [[Regfile|Regfile module]] - authenticate, register and route users from a file.
-* [[MySQL]]
+* [[Register|Register module]] - authenticate, register and route users from database.

@@ Line 1: / Line 1: @@
 Suppose that you have this scenario: you want to register users from a database using PostgreSQL.
 ===Startup configuration file===
@@ Line 24: / Line 23: @@
   register.yate=true
-=== Create database===
+===Configure database in Yate ===
 There are 3 steps to accomplish this task:
@@ Line 31: / Line 30: @@
 # 'tell' Yate which connection to use when users will be registered. This is done in register.conf file.
 ==== Set the connection information of database====
@@ Line 44: / Line 35: @@
 In PostgreSQL configuration file: [[PostgreSQL|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]
+  [yateadmin]
-  host=
+  host=localhost
-  database=
+ port=5432
-  user=
+  database=yateadmin
-  password=
+  user=postgres
 After "=" you have to write your connection information.
 ===Register users ===
-See an example of [[Register_Database_Schema|database schema]] to keep the users.
+See an example of a [[Register_Database_Schema|database schema]] to keep the users data.
 In [[Register|register.conf]] in section '''[general]''' the user.register must be enabled.
@@ Line 64: / Line 62: @@
   [user.register]
   query=UPDATE users SET location='${data}',expires=CURRENT_TIMESTAMP + INTERVAL '${expires} s' WHERE username='${username}'
 '''See also'''

@@ Line 26: / Line 26: @@
 === Create database===
-After creating your database with the tables that you need (here is an example of [[Register_Database_Schema|a database schema]]), you have to tell Yate what database to use.
+There are 3 steps to accomplish this task:
 === Configure database in Yate===

@@ Line 9: / Line 9: @@
   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=no''' in section [default], the modules needed should be enabled by hand.
+  Note: By default in Yate all modules are loaded at startup. By setting parameter '''modload=no''' in section [default], you have to enable modules by hand to load them.
 File "yate.conf" controls the loading of [[modules]] in Yate.
@@ Line 22: / Line 23: @@
   ;Module used do authenticate, register, route users in the database.
   register.yate=true
 === Create database===

← Older revision		Revision as of 08:40, 5 April 2013
Line 40:		Line 40:
	register.yate=true		register.yate=true

		+
		+	===Register users ===
		+
		+	See an example of [[Register_Database_Schema\|database schema]] to keep the users.
		+
		+	In [[Register\|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'''		'''See also'''