localhost jabberd14 server A Jabber Server using jabberd14! http://jabberd.org/ jabberd14-Server Ein Jabber-Server, der jabberd14 benutzt. http://jabberd.org/ Choose a username and password to register with this server. Welcome! Welcome to the Jabber server at localhost -- we hope you enjoy this service! Herzlich Willkommen! Willkommen auf dem Jabberserver auf localhost -- wir hoffen Sie mögen diesen Dienst! Auto Reply This is a special administrative address. Your message was received and forwarded to server administrators. Automatische Antwort Dies ist eine spezielle Administrationsadresse. Ihre Nachricht wurde empfangen und an die Server-Administratoren weitergeleitet. jabber:iq:search jabber:iq:register admin administrator chatmaster hostmaster jabbermaster postmaster root support system webmaster xmpp 3 16 @libdir@/libjabberdsm.so @libdir@/libjabberdsm.so @libdir@/libjabberdsm.so @libdir@/libjabberdsm.so @libdir@/libjabberdsm.so @libdir@/libjabberdsm.so @libdir@/libjabberdsm.so @libdir@/libjabberdsm.so @libdir@/libjabberdsm.so @libdir@/libjabberdsm.so @libdir@/libjabberdsm.so @libdir@/libjabberdsm.so @libdir@/libjabberdsm.so @libdir@/libjabberdsm.so @libdir@/libjabberdsm.so @libdir@/libjabberdsm.so @libdir@/libjabberdsm.so @libdir@/libjabberdsm.so @libdir@/libjabberdsm.so @libdir@/libjabberdsm.so @libdir@/libjabberdsm.so @libdir@/libjabberdsm.so @libdir@/libjabberdsm.so @libdir@/libjabberdxdbsql.so mysql jabber secret localhost jabber user=jabber password=secret jabber:server jabber:iq:auth jabber:iq:last jabber:iq:register jabber:iq:roster jabber:iq:browse vcard-temp http://jabberd.org/ns/storedsubscriptionrequest jabber:iq:private jabber:iq:privacy http://jabberd.org/ns/wrapper SET NAMES utf8 SELECT xml FROM last WHERE realm=SUBSTRING('{attribute::to}', INSTR('{attribute::to}', '@')+1) AND user=SUBSTRING('{attribute::to}', 1, INSTR('{attribute::to}', '@')-1) INSERT INTO last (user, realm, last, text, xml) VALUES (SUBSTRING('{attribute::to}', 1, INSTR('{attribute::to}', '@')-1), SUBSTRING('{attribute::to}', INSTR('{attribute::to}', '@')+1), '{last:query/attribute::last}', '{last:query/text()}', '{last:query}') DELETE FROM last WHERE realm=SUBSTRING('{attribute::to}', INSTR('{attribute::to}', '@')+1) AND user=SUBSTRING('{attribute::to}', 1, INSTR('{attribute::to}', '@')-1) SELECT password FROM users WHERE realm=SUBSTRING('{attribute::to}', INSTR('{attribute::to}', '@')+1) AND user=SUBSTRING('{attribute::to}', 1, INSTR('{attribute::to}', '@')-1) INSERT INTO users (user,realm,password) VALUES (SUBSTRING('{attribute::to}', 1, INSTR('{attribute::to}', '@')-1), SUBSTRING('{attribute::to}', INSTR('{attribute::to}', '@')+1), '{auth:password/text()}') DELETE FROM users WHERE realm=SUBSTRING('{attribute::to}', INSTR('{attribute::to}', '@')+1) AND user=SUBSTRING('{attribute::to}', 1, INSTR('{attribute::to}', '@')-1) SELECT xml FROM storedsubscriptionrequests WHERE realm=SUBSTRING('{attribute::to}', INSTR('{attribute::to}', '@')+1) AND user=SUBSTRING('{attribute::to}', 1, INSTR('{attribute::to}', '@')-1) INSERT INTO storedsubscriptionrequests (user, realm, fromjid, xml) VALUES (SUBSTRING('{attribute::to}', 1, INSTR('{attribute::to}', '@')-1), SUBSTRING('{attribute::to}', INSTR('{attribute::to}', '@')+1), '{presence/attribute::from}', '{presence}') DELETE FROM storedsubscriptionrequests WHERE realm=SUBSTRING('{attribute::to}', INSTR('{attribute::to}', '@')+1) AND user=SUBSTRING('{attribute::to}', 1, INSTR('{attribute::to}', '@')-1) AND IF ('{attribute::matchpath}'='', 1=1, fromjid=SUBSTRING(SUBSTRING('{attribute::matchpath}', 1, LENGTH('{attribute::matchpath}')-2), 17) AND SUBSTRING('{attribute::matchpath}', 1, 15)='presence[@from=') SELECT xml FROM messages WHERE realm=SUBSTRING('{attribute::to}', INSTR('{attribute::to}', '@')+1) AND user=SUBSTRING('{attribute::to}', 1, INSTR('{attribute::to}', '@')-1) AND type='offline' ORDER BY storetime INSERT INTO messages (user, realm, node, correspondent, type, storetime, subject, body, xml) VALUES (SUBSTRING('{attribute::to}', 1, INSTR('{attribute::to}', '@')-1), SUBSTRING('{attribute::to}', INSTR('{attribute::to}', '@')+1), IF('{message/attribute::node}'='', NULL, '{message/attribute::node}'), SUBSTRING('{message/attribute::from}/', 1, INSTR('{message/attribute::from}/', '/')-1), 'offline', now(), IF ('{message/subject}'='', NULL, '{message/subject/text()}'), '{message/body/text()}', '{message}') DELETE FROM messages WHERE realm=SUBSTRING('{attribute::to}', INSTR('{attribute::to}', '@')+1) AND user=SUBSTRING('{attribute::to}', 1, INSTR('{attribute::to}', '@')-1) AND type='offline' AND IF ('{attribute::matchpath}'='', 1=1, node=SUBSTRING(SUBSTRING('{attribute::matchpath}', 1, LENGTH('{attribute::matchpath}')-2), 16) AND SUBSTRING('{attribute::matchpath}', 1, 14)='message[@node=') SELECT xml FROM messages WHERE realm=SUBSTRING('{attribute::to}', INSTR('{attribute::to}', '@')+1) AND user=SUBSTRING('{attribute::to}', 1, INSTR('{attribute::to}', '@')-1) AND type!='offline' INSERT INTO messages (user, realm, correspondent, type, storetime, delivertime, subject, body, xml) VALUES (SUBSTRING('{attribute::to}', 1, INSTR('{attribute::to}', '@')-1), SUBSTRING('{attribute::to}', INSTR('{attribute::to}', '@')+1), IF ('{message/attribute::direction}'='sent', SUBSTRING('{message/attribute::to}/', 1, INSTR('{message/attribute::to}/', '/')-1), SUBSTRING('{message/attribute::from}/', 1, INSTR('{message/attribute::from}/', '/')-1)), IF ('{message/attribute::direction}'='sent', 'sent', 'recv'), now(), IF ('{message/attribute::direction}'='sent', NULL, now()), '{message/subject/text()}', '{message/body/text()}', '{message}') DELETE FROM messages WHERE realm=SUBSTRING('{attribute::to}', INSTR('{attribute::to}', '@')+1) AND user=SUBSTRING('{attribute::to}', 1, INSTR('{attribute::to}', '@')-1) SELECT xml FROM peerpresence WHERE realm=SUBSTRING('{attribute::to}', INSTR('{attribute::to}', '@')+1) AND user=SUBSTRING('{attribute::to}', 1, INSTR('{attribute::to}', '@')-1) ORDER BY peerrealm, peeruser, peerresource INSERT INTO peerpresence (user, realm, peeruser, peerrealm, peerresource, presence, priority, status, timestamp, xml) VALUES (SUBSTRING('{attribute::to}', 1, INSTR('{attribute::to}', '@')-1), SUBSTRING('{attribute::to}', INSTR('{attribute::to}', '@')+1), SUBSTRING('{presence/attribute::from}', 1, INSTR('{presence/attribute::from}', '@')-1), IF(INSTR('{presence/attribute::from}', '/')=0, SUBSTRING('{presence/attribute::from}', INSTR('{presence/attribute::from}', '@')+1), SUBSTRING('{presence/attribute::from}', INSTR('{presence/attribute::from}', '@')+1, INSTR('{presence/attribute::from}', '/')-1-INSTR('{presence/attribute::from}', '@'))), IF(INSTR('{presence/attribute::from}', '/')=0, NULL, SUBSTRING('{presence/attribute::from}', INSTR('{presence/attribute::from}', '/')+1)), IF ('{presence}'='','unavailable', IF ('{presence/attribute::type}'='unavailable', 'unavailable', IF ('{presence/show/text()}'='','available', '{presence/show/text()}'))), IF ('{presence/priority/text()}'='', '0', '{presence/priority/text()}'), '{presence/status/text()}', now(), '{presence}') DELETE FROM peerpresence WHERE realm=SUBSTRING('{attribute::to}', INSTR('{attribute::to}', '@')+1) AND user=SUBSTRING('{attribute::to}', 1, INSTR('{attribute::to}', '@')-1) AND IF ('{attribute::matchpath}'='', 1=1, CONCAT(peeruser, '@', peerrealm, IF(peerresource IS NULL, '', CONCAT('/', peerresource)))=SUBSTRING(SUBSTRING('{attribute::matchpath}', 1, LENGTH('{attribute::matchpath}')-2), 17) AND SUBSTRING('{attribute::matchpath}', 1, 15)='presence[@from=') SELECT 'this namespace is never selected' INSERT INTO presence (user,realm,presence,priority,status,timestamp) VALUES (SUBSTRING('{attribute::to}', 1, INSTR('{attribute::to}', '@')-1), SUBSTRING('{attribute::to}', INSTR('{attribute::to}', '@')+1), IF ('{presence}'='','unavailable', IF ('{presence/show/text()}'='','available', '{presence/show/text()}')), IF ('{presence/priority/text()}'='', '0', '{presence/priority/text()}'), '{presence/status/text()}', now()) DELETE FROM presence WHERE realm=SUBSTRING('{attribute::to}', INSTR('{attribute::to}', '@')+1) AND user=SUBSTRING('{attribute::to}', 1, INSTR('{attribute::to}', '@')-1) SELECT xml FROM private WHERE realm=SUBSTRING('{attribute::to}', INSTR('{attribute::to}', '@')+1) AND user=SUBSTRING('{attribute::to}', 1, INSTR('{attribute::to}', '@')-1) ORDER BY last_modified INSERT INTO private (user,realm,ns,xml,last_modified) VALUES (SUBSTRING('{attribute::to}', 1, INSTR('{attribute::to}', '@')-1), SUBSTRING('{attribute::to}', INSTR('{attribute::to}', '@')+1), '{*/attribute::jabberd:ns}', '{private:query}', NOW()) DELETE FROM private WHERE realm=SUBSTRING('{attribute::to}', INSTR('{attribute::to}', '@')+1) AND user=SUBSTRING('{attribute::to}', 1, INSTR('{attribute::to}', '@')-1) AND IF ('{attribute::matchpath}'='', 1=1, ns=SUBSTRING(SUBSTRING('{attribute::matchpath}', 1, LENGTH('{attribute::matchpath}')-2), 28) AND SUBSTRING('{attribute::matchpath}', 1, 26)='private:query[@jabberd:ns=') SELECT xml FROM privacy WHERE realm=SUBSTRING('{attribute::to}', INSTR('{attribute::to}', '@')+1) AND user=SUBSTRING('{attribute::to}', 1, INSTR('{attribute::to}', '@')-1) ORDER BY last_modified INSERT INTO privacy (user,realm,name,xml,last_modified,isdefault) VALUES (SUBSTRING('{attribute::to}', 1, INSTR('{attribute::to}', '@')-1), SUBSTRING('{attribute::to}', INSTR('{attribute::to}', '@')+1), SUBSTRING(SUBSTRING('{attribute::matchpath}', 1, LENGTH('{attribute::matchpath}')-2), 21), '{privacy:list}', NOW(), IF('{*/attribute::jabberd:default}' = '', NULL, 'default')) DELETE FROM privacy WHERE realm=SUBSTRING('{attribute::to}', INSTR('{attribute::to}', '@')+1) AND user=SUBSTRING('{attribute::to}', 1, INSTR('{attribute::to}', '@')-1) AND IF ('{attribute::matchpath}'='', 1=1, name=SUBSTRING(SUBSTRING('{attribute::matchpath}', 1, LENGTH('{attribute::matchpath}')-2), 21) AND SUBSTRING('{attribute::matchpath}', 1, 19)='privacy:list[@name=') SELECT user,mailaddress FROM mailaddresses WHERE realm=SUBSTRING('{attribute::to}', INSTR('{attribute::to}', '@')+1) AND user=SUBSTRING('{attribute::to}', 1, INSTR('{attribute::to}', '@')-1) INSERT INTO mailaddresses (user, realm, mailaddress, lastmodified) VALUES (SUBSTRING('{attribute::to}', 1, INSTR('{attribute::to}', '@')-1), SUBSTRING('{attribute::to}', INSTR('{attribute::to}', '@')+1), IF('{register:query/register:email/text()}'='', NULL, '{register:query/register:email/text()}'), now()) DELETE FROM mailaddresses WHERE realm=SUBSTRING('{attribute::to}', INSTR('{attribute::to}', '@')+1) AND user=SUBSTRING('{attribute::to}', 1, INSTR('{attribute::to}', '@')-1) SELECT xml FROM roster WHERE realm=SUBSTRING('{attribute::to}', INSTR('{attribute::to}', '@')+1) AND user=SUBSTRING('{attribute::to}', 1, INSTR('{attribute::to}', '@')-1) INSERT INTO roster (user, realm, xml) VALUES (SUBSTRING('{attribute::to}', 1, INSTR('{attribute::to}', '@')-1), SUBSTRING('{attribute::to}', INSTR('{attribute::to}', '@')+1), '{roster:query}') DELETE FROM roster WHERE realm=SUBSTRING('{attribute::to}', INSTR('{attribute::to}', '@')+1) AND user=SUBSTRING('{attribute::to}', 1, INSTR('{attribute::to}', '@')-1) SELECT xml FROM browse WHERE realm=SUBSTRING('{attribute::to}', INSTR('{attribute::to}', '@')+1) AND user=SUBSTRING('{attribute::to}', 1, INSTR('{attribute::to}', '@')-1) INSERT INTO browse (user, realm, xml) VALUES (SUBSTRING('{attribute::to}', 1, INSTR('{attribute::to}', '@')-1), SUBSTRING('{attribute::to}', INSTR('{attribute::to}', '@')+1), '{*}') DELETE FROM browse WHERE realm=SUBSTRING('{attribute::to}', INSTR('{attribute::to}', '@')+1) AND user=SUBSTRING('{attribute::to}', 1, INSTR('{attribute::to}', '@')-1) SELECT xml FROM vcard WHERE realm=SUBSTRING('{attribute::to}', INSTR('{attribute::to}', '@')+1) AND user=SUBSTRING('{attribute::to}', 1, INSTR('{attribute::to}', '@')-1) INSERT INTO vcard (user, realm, name, email, nickname, birthday, photo, xml) VALUES (SUBSTRING('{attribute::to}', 1, INSTR('{attribute::to}', '@')-1), SUBSTRING('{attribute::to}', INSTR('{attribute::to}', '@')+1), IF('{vcard:vCard/vcard:FN/text()}'='', IF('{vcard:vCard/vcard:N/vcard:GIVEN/text()}'!='' AND '{vcard:vCard/vcard:N/vcard:MIDDLE/text()}'!='' AND '{vcard:vCard/vcard:N/vcard:FAMILY/text()}'!='', '{vcard:vCard/vcard:N/vcard:GIVEN/text()} {vcard:vCard/vcard:N/vcard:MIDDLE/text()} {vcard:vCard/vcard:N/vcard:FAMILY/text()}', IF('{vcard:vCard/vcard:N/vcard:GIVEN/text()}'!='' AND '{vcard:vCard/vcard:N/vcard:FAMILY/text()}'!='', '{vcard:vCard/vcard:N/vcard:GIVEN/text()} {vcard:vCard/vcard:N/vcard:FAMILY/text()}', IF('{vcard:vCard/vcard:N/vcard:FAMILY/text()}'!='','{vcard:vCard/vcard:N/vcard:FAMILY/text()}',IF('{vcard:vCard/vcard:N/vcard:GIVEN/text()}'!='', '{vcard:vCard/vcard:N/vcard:GIVEN/text()}', NULL)))), '{vcard:vCard/vcard:FN/text()}'), IF('{vcard:vCard/vcard:EMAIL/vcard:USERID/text()}'='', NULL, '{vcard:vCard/vcard:EMAIL/vcard:USERID/text()}'), IF('{vcard:vCard/vcard:NICKNAME/text()}'='', NULL, '{vcard:vCard/vcard:NICKNAME/text()}'), IF('{vcard:vCard/vcard:BDAY/text()}'='', NULL, '{vcard:vCard/vcard:BDAY/text()}'), IF('{vcard:vCard/vcard:PHOTO/vcard:BINVAL/text()}'='', IF('{vcard:vCard/vcard:PHOTO/text()}'='', NULL, '{vcard:vCard/vcard:PHOTO/text()}'), '{vcard:vCard/vcard:PHOTO/vcard:BINVAL/text()}'), '{vcard:vCard}') DELETE FROM vcard WHERE realm=SUBSTRING('{attribute::to}', INSTR('{attribute::to}', '@')+1) AND user=SUBSTRING('{attribute::to}', 1, INSTR('{attribute::to}', '@')-1) @libdir@/libjabberdpthsock.so 120 60 10 10 1 1 -6 10 [%t] (%h): %s local0 @libdir@/libjabberddnsrv.so s2s.localhost s2s.localhost s2s.localhost @libdir@/libjabberddialback.so 50 50 4 1 -5 50 @libdir@/libjabberdproxy65.so :: @localstatedir@/spool/jabberd/inject.localhost @sysconfdir@/dhparams.pem @sysconfdir@/cacerts.pem @localstatedir@/run/jabberd/jabber.pid