Users - Revision history

Dana at 12:51, 5 June 2013

2013-06-05T12:51:50Z

Dana: /* Commands */

2013-06-05T12:44:45Z

‎Commands

Dana at 14:48, 4 June 2013

2013-06-04T14:48:31Z

Dana at 14:47, 4 June 2013

2013-06-04T14:47:56Z

Dana at 14:44, 4 June 2013

2013-06-04T14:44:44Z

Dana: /* Commands */

2013-05-13T13:41:59Z

‎Commands

Dana at 13:40, 13 May 2013

2013-05-13T13:40:45Z

Dana: Created page with " This module configures the database account name and users management (add, update, remove and retrieve queries). === Configuration === File users.conf ; This file config..."

2012-10-17T12:10:56Z

Created page with " This module configures the database account name and users management (add, update, remove and retrieve queries). === Configuration === File users.conf ; This file config..."

New page

This module configures the database account name and users management (add, update, remove and retrieve queries).

=== Configuration ===

File users.conf

; This file configures the users management module

[database]
; This section configures user management database access

; account: string: The name of the database account
;account=

; add_user: string: Database query used to add a new user
; The query should fail if the user already exists
; Extra care must be taken when building this query: undesirable things may happen
; like replacing an existing user's password or adding a duplicate, unreachable,
; entry in the users table
;add_user=SELECT * FROM user_add('${user}','${password}')

; update_user: string: Database query used to update an existing user
;update_user=UPDATE users SET password='${password}' WHERE username='${user}'

; remove_user: string: Database query used to delete an existing user
;remove_user=DELETE FROM users WHERE username='${user}'

; select_user: string: Database query used to retrieve user's data
;select_user=SELECT * FROM users WHERE username='${user}'

← Older revision		Revision as of 12:51, 5 June 2013
Line 42:		Line 42:


−	===Example ~~for add_user~~ procedure===	+	===Example of a stored procedure to add a user===

	This is an example of creating a stored procedure for adding a user:		This is an example of creating a stored procedure for adding a user:

← Older revision		Revision as of 12:44, 5 June 2013
Line 70:		Line 70:

	users {add user [parameter=value...]\|delete user\|update user [parameter=value...]}		users {add user [parameter=value...]\|delete user\|update user [parameter=value...]}
		+
		+	Example of adding a user with password:
		+	telnet 0 5038
		+	users add gigi@example.com password=pass1
		+	<users:ALL> parseParams(password=pass1)
		+	<pgsqldb:ALL> Performing query "SELECT * FROM users WHERE username='gigi@example.com'" for 'jabberserver'
		+	<pgsqldb:ALL> Query for 'jabberserver.1' returned 0 rows, 0 affected [0x95d6e10]
		+	<pgsqldb:ALL> Performing query "SELECT * FROM user_add('gigi@example.com','pass1')" for 'jabberserver'
		+	<pgsqldb:ALL> Query for 'jabberserver.1' returned 1 rows, 0 affected [0x95d6e10]
		+	<users:ALL> Added user 'gigi@example.com'
		+	users add succedded

← Older revision		Revision as of 14:48, 4 June 2013
Line 1:		Line 1:

−	This module configures the database account name and users management (add, update, remove and retrieve queries) ~~kept~~ in configuration file: users.conf.	+	This module configures the database account name and users management (add, update, remove and retrieve queries). This is done in configuration file: users.conf.

	'''Note:''' All database queries are done with PostgreSQL.		'''Note:''' All database queries are done with PostgreSQL.

@@ Line 1: / Line 1: @@
-This module configures the database account name and users management (add, update, remove and retrieve queries).
+This module configures the database account name and users management (add, update, remove and retrieve queries) kept in configuration file: users.conf.
   '''Note:''' All database queries are done with PostgreSQL.
 ===Example of create table users ===
   CREATE TABLE users (
@@ Line 10: / Line 12: @@
        password text,
   );
-  ALTER TABLE public.users OWNER TO postgres;
+=== Configuration file ===
-===Example of stored procedure for add_user===
-−
- CREATE FUNCTION user_add(text, text) RETURNS integer
-    AS $_$
- DECLARE
-    _username ALIAS FOR $1;
-    _password ALIAS FOR $2;
-    n integer;
- BEGIN
-    SELECT INTO n COUNT(*) FROM users WHERE username=_username;
-    IF n > 0 THEN
- 	n := 0;
-    ELSE
- 	INSERT INTO users (username,password) VALUES (_username,_password);
- 	n := 1;
-    END IF;
-    RETURN n;
- END;
- $_$
-    LANGUAGE plpgsql;
-−
 === Configuration ===
 File users.conf
@@ Line 60: / Line 40: @@
   ; select_user: string: Database query used to retrieve user's data
   ;select_user=SELECT * FROM users WHERE username='${user}'
 ===Commands===

← Older revision		Revision as of 13:41, 13 May 2013
Line 36:		Line 36:

	users {add user [parameter=value...]\|delete user\|update user [parameter=value...]}		users {add user [parameter=value...]\|delete user\|update user [parameter=value...]}
		+
		+
		+	'''See also'''
		+
		+	* [[Modules]]

← Older revision		Revision as of 13:40, 13 May 2013
Line 29:		Line 29:
	; select_user: string: Database query used to retrieve user's data		; select_user: string: Database query used to retrieve user's data
	;select_user=SELECT * FROM users WHERE username='${user}'		;select_user=SELECT * FROM users WHERE username='${user}'
		+
		+
		+	===Commands===
		+
		+	From telnet the command can be used to add/delete/update a user:
		+
		+	users {add user [parameter=value...]\|delete user\|update user [parameter=value...]}