We recently had a chat (pun not intended) amongst the team to discuss some of the ways we could cut costs during these financially challenged times. One area identified was around inter-office calling charges. We have three stores: one in Onehunga (local), one in Tawa (national) and one in Hamilton (national). All of which are subject to charges when they call us here at head office (and vice versa).<\/p>\n
We use Fonality’s HUD client<\/a> here at head office (actually HUDlite<\/a> to be exact because it’s free) for call management, presence management and IM.<\/p>\n So a thought was born that maybe we could link the remote sites to the HUDLite server on our VoIP system, and they could IM rather than calling. But alas, it all seemed a little too hard and we could foresee a few problems, so we opted instead to make our own Jabber server (using the XMPP<\/a> protocol) and give the sites access to that.<\/p>\n This turned out to be a great compromise. Now staff at the remote sites IM rather than calling – they can see if the person they want to talk to is available and can get answers immediately. Even better, what would have been a calling cost is absorbed as part of our data charges.<\/p>\n I already knew I was going to use Ubuntu server for this project, but I had to decide between Jabber or IRC (why? because those were the two mentioned in the Ubuntu server guide…*snigger*). For reasons like clients, setup, the name (I do like Jabber over IRC) I went with Jabber, or to be more precise an XMPP server.<\/p>\n The start was a basic build using Ubuntu 10.04 LTS (there are newer versions at the time of writing this but I prefer their Long Term Support version – until the next one does…). Near the end of the install (when prompted if you want additional software installed) I selected OpenSSH server so I can log in remotely to administer the system and install the components – it’s handy if you need to copy-and-paste.<\/p>\n After the first reboot make sure that universe<\/strong> and multiverse<\/strong> are present in the sources.list<\/strong> file (add them if they are not…)<\/p>\n Once that’s done, I make sure everything is up-to-date<\/p>\n Then one more reboot for good luck and we’re on our way.<\/p>\n The XMPP server can support a number of db backends. By default it uses MySQL so that was how I left it for our server. Preliminary testing was unsuccessfully using the “Berkeley DB” as the user authentication database, however jabberd2 can be configured to use LDAP, MySQL, Postgresql, etc.<\/p>\n For this HOW-TO we’ll be using MySQL, so…<\/p>\n When prompted, type in a password for the MySQL ‘root<\/strong>‘ user and note it down for use later.<\/p>\n Now we install the engine of our communication server: jabberd2<\/strong>…<\/p>\n Once installed we may as well stop the services since they’re not configured properly yet.<\/p>\n The jabberd2<\/strong> package has a script to do all the setup work for you.<\/p>\n Log into MySQL as the “root<\/strong>” user and execute the script.<\/p>\n Replace the password<\/em> above with one of your own choice.<\/p>\n The sm.xml<\/strong> file configures the session manager component of jabberd2<\/strong>. The session manager acts as a layer between the router and the externally available components. We need to configure a few settings like id, and database connection details.<\/p>\n Change\/update the following tags:<\/p>\n Now we edit the c2s.xml<\/strong> file. This configures the client-to-server component of the jabberd2<\/strong> server. The c2s<\/strong> component handles communications with Jabber clients, and the settings in c2s.xml<\/strong> are primarily concerned with client communication.<\/p>\n IT’S DESCISION TIME: Do you want to have encrypted connections<\/strong>? Your choice effects the settings in the first part of the c2s.xml<\/strong> file.<\/p>\n The first step of this process is to create either a self-signed certificate or obtain one from a certificate authority.<\/p>\n Once you’ve created your certificate, you can copy it into \/etc\/jabberd2\/<\/strong>your.domain.com<\/em>.pem<\/strong><\/span><\/p>\n Now we edit the c2s.xml<\/strong> file.<\/p>\n part way down add\/update the following lines<\/p>\n This setting will allow users to be automatically created<\/strong>, and will use the defined certificate for encryption.<\/p>\n part way down add\/update the following lines<\/p>\n Continue editing the c2s.xml<\/strong> file<\/p>\n By default, jabberd2<\/strong> looks for the MySQL sock in the \/tmp directory<\/strong>. We can create a link to the actual MySQL sock file in \/var\/run\/mysqld<\/strong>, but the “tmp<\/strong>” directory is emptied during each reboot. The easy fix for me was to alter the jabberd2 boot script so the symbolic link was created as jabberd2 was started.<\/p>\n add this line near the top with the other variable declarations<\/p>\n then just before the section that executes the ‘start<\/strong>‘ options add…<\/p>\n This first checks to see if the sock file is there, and if it’s not creates the link to the right place for you!<\/p>\n Now start the Jabber server…<\/p>\n and if we’ve done everything right, the server should be running ready for clients to connect to.<\/p>\n There are a number of clients to choose from regardless of what platform your using. For a list of clients vs. platform you can visit http:\/\/xmpp.org\/xmpp-software\/clients\/<\/a> and work your way through the list to select one based on your own criteria.<\/p>\n I had the best results with Miranda<\/a>, Pidgin<\/a>, OneTeam<\/a>, Empathy<\/a> (on Linux), iChat<\/a> (on Mac OSX), and Citron<\/a>, finally settling for Pidgin to rollout with our organisation on Windows PCs. It was as much about the look and feel as it was about it actually working – in an ideal world I would have liked a Windows version of “iChat” because i love the look and feel as well as the chat bubbles.<\/p>\n In Jabber you are able to log in several client programs simultaneously. You don’t need to have different Jabber accounts for different locations (e.g. work and home). You can chat in one location, then go to another, log in again with the same JID<\/strong> and the previous Jabber client will not go offline.<\/p>\n This is because Jabber has a thing called “resources”. When you log in, you are usually asked for for the “Resource Name”. Some programs like to use their program names as the resource name (e.g. “iChat” or “Miranda”).<\/p>\n For more information you can visit here<\/a>.<\/p>\n It’s probably a wise decision to back up the data stored in the MySQL database so that it can be restored if you have to rebuild the server.<\/p>\n For my particular setup, I have a cron<\/strong> script which dumps the schema and data and Bacula archives it as part of daily site-wide unattended backup procedure.<\/p>\n Fundamentally the steps can be performed manually or via a script. Here’s what I did.<\/p>\n Now add it to cron, so it can be automated daily (in this case at 01:30 each day)…<\/p>\n and restart cron<\/p>\n These could also just be entered as manual commands individually…<\/p>\n Setting up an XMPP server “XMPP by any other name would…” We recently had a chat (pun not intended) amongst the team to discuss some of the ways we could cut costs during these financially challenged times. One area identified was around inter-office calling charges. We have three stores: one in Onehunga (local), one in… Read more »<\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[78,75,34,22,77,76,33,74],"class_list":["post-91","post","type-post","status-publish","format-standard","hentry","category-technical-resource","tag-c2s-xml","tag-jabber","tag-multiverse","tag-mysql","tag-sm-xml","tag-sources-list","tag-universe","tag-xmpp"],"_links":{"self":[{"href":"https:\/\/templesoft.co.nz\/journal\/index.php?rest_route=\/wp\/v2\/posts\/91","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/templesoft.co.nz\/journal\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/templesoft.co.nz\/journal\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/templesoft.co.nz\/journal\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/templesoft.co.nz\/journal\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=91"}],"version-history":[{"count":8,"href":"https:\/\/templesoft.co.nz\/journal\/index.php?rest_route=\/wp\/v2\/posts\/91\/revisions"}],"predecessor-version":[{"id":172,"href":"https:\/\/templesoft.co.nz\/journal\/index.php?rest_route=\/wp\/v2\/posts\/91\/revisions\/172"}],"wp:attachment":[{"href":"https:\/\/templesoft.co.nz\/journal\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=91"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/templesoft.co.nz\/journal\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=91"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/templesoft.co.nz\/journal\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=91"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}So how did I do it?<\/h3>\n
sudo vi \/etc\/apt\/sources.list<\/pre>\n
sudo aptitude update\r\nsudo aptitude safe-upgrade<\/pre>\n
sudo shutdown -r now<\/pre>\n
Basic install<\/h2>\n
sudo aptitude install mysql-server<\/pre>\n
sudo aptitude install jabberd2<\/pre>\n
sudo \/etc\/init.d\/jabberd2 stop<\/pre>\n
Configuring MySQL<\/h3>\n
sudo gzip -d \/usr\/share\/doc\/jabberd2\/db-setup.mysql.gz<\/pre>\n
mysql -u root -p\r\n\r\nmysql>SOURCE<\/strong> \/usr\/share\/doc\/jabberd2\/db-setup.mysql<\/span>\r\nmysql>GRANT<\/strong> select,insert,delete,update ON<\/strong> jabberd2.* to jabberd2@localhost IDENTIFIED<\/strong> by 'password<\/strong><\/em><\/span>';<\/span>\r\nmysql>quit<\/strong><\/span><\/pre>\nConfiguring jabberd2<\/h3>\n
sudo vi \/etc\/jabberd2\/sm.xml<\/pre>\n
<id>your.domain.com<\/strong><\/em><\/id><\/span>\r\n<driver>mysql<\/strong><\/driver><\/span>\r\n<user>jabberd2<\/strong><\/em><\/user><\/span>\r\n<pass>password<\/strong><\/em><\/pass><\/span><\/pre>\nYES, I would like encrypted connections…<\/h4>\n
sudo vi \/etc\/jabberd2\/c2s.xml<\/pre>\n
<id register-enable='true'<\/strong> pemfile='\/etc\/jabberd2\/your.domain.com<\/em>.pem<\/strong>'><\/span>\r\n your.domain.com<\/strong><\/em><\/span>\r\n<\/id><\/span><\/pre>\nNO, I don’t want encrypted connections…<\/h4>\n
sudo vi \/etc\/jabberd2\/c2s.xml<\/pre>\n
<id register-enable='true'<\/strong>>your.domain.com<\/strong><\/em><\/id><\/span><\/pre>\nOther changes regardless of connection type<\/h4>\n
<module>mysql<\/strong><\/module><\/span>\r\n\r\n<user>jabberd2<\/strong><\/user><\/span>\r\n<pass>password<\/strong><\/em><\/span><\/pass><\/span><\/pre>\nsudo vi \/etc\/init.d\/jabberd2<\/pre>\n
LINK2MYSQLSOCK=\"\/tmp\/mysql.sock\"<\/span><\/pre>\nif [ ! -e \"${LINK2MYSQLSOCK}\" ]; then\r\n echo -n \"Recreating Jabber's lost MySQL socket link...\\n\"\r\n ln -s \/var\/run\/mysqld\/mysqld.sock \/tmp\/mysql.sock\r\nfi<\/span><\/pre>\nsudo \/etc\/init.d\/jabberd2 start<\/pre>\n
The client<\/h2>\n
A note on “Resource names”<\/h3>\n
Backing up data<\/h2>\n
sudo mkdir \/var\/spool\/mysql\r\nsudo vi \/var\/lib\/mysql\/jabberd2-backup-db\r\nmysqldump -u root -ppassword<\/em> -d jabberd2 > \/var\/spool\/mysql\/schema.sql\r\nmysqldump -u root -ppassword<\/em> -t jabberd2 > \/var\/spool\/mysql\/data.sql\r\nsudo chmod +x \/var\/lib\/mysql\/jabberd2-backup-db<\/pre>\n
sudo vi \/etc\/crontab\r\n\r\n30 1 * * * root \/var\/lib\/mysql\/jabberd2-backup-db<\/span><\/pre>\nsudo service cron restart<\/pre>\n
sudo mysqldump -u root -ppassword<\/em> -d jabberd2 > \/var\/spool\/mysql\/schema.sql\r\nsudo mysqldump -u root -ppassword<\/em> -t jabberd2 > \/var\/spool\/mysql\/data.sql<\/pre>\n<\/div>\n","protected":false},"excerpt":{"rendered":"