-
Notifications
You must be signed in to change notification settings - Fork 0
/
README.pgsql
32 lines (27 loc) · 929 Bytes
/
README.pgsql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
Now you can change sql queries for check password by md5 hash.
Example c2s.xml:
...
<authreg>
<path>/usr/lib/jabberd</path>
<module>pgsql</module>
<ssl-mechanisms>
<traditional>
<plain/>
</traditional>
<sasl>
<plain/>
<external/>
</sasl>
</ssl-mechanisms>
<pgsql>
...
<sql>
<!-- <create>INSERT INTO authreg ( username, realm ) VALUES ( '%s', '%s' )</create> -->
<!-- <select>SELECT password FROM authreg WHERE username = '%s' AND realm = '%s'</select> -->
>>> <login>SELECT count(*) FROM authreg WHERE username = '%s' AND realm = '%s' AND password = MD5('%s')</login>
>>> <setpassword>UPDATE authreg SET password = MD5('%s') WHERE username = '%s' AND realm = '%s'</setpassword>
<!-- <delete>DELETE FROM authreg WHERE username = '%s' AND realm = '%s'</delete> -->
</sql>
</pgsql>
</authreg>
...