Building Jabber server using Yate - Revision history

Monica: /* Generating a certificate */

2013-11-04T09:24:48Z

‎Generating a certificate

2013-06-07T11:54:07Z

‎PostgreSQL example database dump

2013-06-05T10:14:33Z

‎Creating jabber users

2013-06-05T10:13:34Z

‎Creating jabber users

2013-06-05T10:13:00Z

‎Creating jabber users

2013-06-04T15:10:03Z

‎PostgreSQL example database dump

2013-06-04T15:01:43Z

‎PostgreSQL example database dump

2013-06-04T14:28:12Z

‎PostgreSQL example database dump

2013-06-04T13:04:03Z

‎Configure jabber server module

2013-06-04T12:19:51Z

← Older revision		Revision as of 09:24, 4 November 2013
Line 708:		Line 708:
	* [[Jabber Server Module]]		* [[Jabber Server Module]]
	* [[Telephony]]		* [[Telephony]]
		+
		+	[[Category:Jabber]] [[Category:Server]] [[Category:Users]] [[Category:Database]]

@@ Line 162: / Line 162: @@
 === PostgreSQL example database dump ===
-   '' ''
   --
   -- PostgreSQL database dump
@@ Line 262: / Line 262: @@
   	UPDATE privatedata SET xml=_xml WHERE username=_username AND tag=_tag AND xmlns=_xmlns;
       END IF;
-      return ' ' ' ';
+      return <nowiki>''''</nowiki>;
   END;
   $_$
@@ Line 298: / Line 298: @@
   	UPDATE lines SET location=_location WHERE line=_line;
       END IF;
-      return ' ' ' ';
+      return <nowiki>''''</nowiki>;
   END;
   $_$
@@ Line 410: / Line 410: @@
   	UPDATE roster SET subscription=_sub WHERE username=_username AND contact=_contact;
      END IF;
-     return ' ' ' ';
+     return <nowiki>''''</nowiki>;
   END;
   $_$
@@ Line 457: / Line 457: @@
   ALTER FUNCTION public.user_add(text, text) OWNER TO postgres;
-  SET default_tablespace = ' ';
+  SET default_tablespace = <nowiki>''</nowiki>;
   SET default_with_oids = true;

@@ Line 685: / Line 685: @@
   <users:ALL> Deleted user 'gigi@example.com'
   users delete succedded
-  <pgsqldb:ALL> Performing query "SELECT users.username, roster.* FROM users LEFT OUTER JOIN roster ON users.username=roster.username WHERE users.username='gigi@example.com'" for 'jabberserver'
+  <pgsqldb:ALL> Performing query "SELECT users.username, roster.* FROM users LEFT OUTER JOIN roster ON users.username=roster.username WHERE users.username='gigi@example.com'"
   <pgsqldb:ALL> Query for 'jabberserver.1' returned 0 rows, 0 affected [0x8152e18]
   <pgsqldb:ALL> Performing query "DELETE FROM privatedata WHERE username='gigi@example.com'" for 'jabberserver'

@@ Line 669: / Line 669: @@
   users add succedded
-** Change: users update gigi@example.com password=changed_password
+:* Change: users update gigi@example.com password=changed_password
   users update gigi@example.com password=changed_password
@@ Line 678: / Line 678: @@
   users update succedded
-** Delete: users delete gigi@example.com
+:* Delete: users delete gigi@example.com
   users delete gigi@example.com
   <users:ALL> parseParams((null))

@@ Line 659: / Line 659: @@
 * Connect to yate using telnet. Issue the following commands:
 ** Add: users add gigi@example.com password=some_password
-** Delete: users delete gigi@example.com
+ telnet 0 5038
 ** Change: users update gigi@example.com password=changed_password
 * Any other database access tools and scripts

← Older revision		Revision as of 13:04, 4 June 2013
Line 12:		Line 12:

	'''Note:''' All database queries were done with PostgreSQL.		'''Note:''' All database queries were done with PostgreSQL.
		+
		+	== Install Yate==
		+
		+	Go to [[Installation]] page and follow the steps to install Yate on your machine.

	== Configure jabber server module ==		== Configure jabber server module ==

@@ Line 11: / Line 11: @@
 * [[PostgreSQL]] or [[MySQL]] - Database access
-'''Note:''' All database queries were used with PostgreSQL
+ '''Note:''' All database queries were done with PostgreSQL.
 == Configure jabber server module ==