Your message dated Fri, 04 Dec 2009 18:39:40 +0000 with message-id <[email protected]> and subject line Bug#540915: fixed in ejabberd 2.1.0-1 has caused the Debian Bug report #540915, regarding ejabberd in debian could'n be used with postgresql to be marked as done.
This means that you claim that the problem has been dealt with. If this is not the case it is now your responsibility to reopen the Bug report if necessary, and/or fix the problem forthwith. (NB: If you are a system administrator and have no idea what this message is talking about, this may indicate a serious mail system misconfiguration somewhere. Please contact [email protected] immediately.) -- 540915: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=540915 Debian Bug Tracking System Contact [email protected] with problems
--- Begin Message ---Package: ejabberd Version: 2.0.1-6 The point: When you install ejabberd package in lenny or in sid ( 2009.08.11 ) it work's fine until you try to use postgresql as a backend for any module you get an error message in /var/log/ejabberd/ejabberd.log: =ERROR REPORT==== 2009-08-10 17:37:33 === E(<0.38.0>:ejabberd_rdbms:67) : Start of supervisor 'ejabberd_odbc_sup_ruscobank.ru' failed: {error,{shutdown,{child,undefined,'ejabberd_odbc_sup_ruscobank.ru', {ejabberd_odbc_sup,start_link,["ruscobank.ru"]}, transient,infinity,supervisor, [ejabberd_odbc_sup]}}} Retrying... this message continues to appear in log file. ejabberd seems working fine, except the functions, that depend on the backend, that uses postgresql. My ejabberd.cfg: taiga:~# cat /etc/ejabberd/ejabberd.cfg| grep -v '%%'| grep -v '^$' {acl, admin, {user, "rakul", "ruscobank.ru"}}. {acl, admin, {user, "al", "ruscobank.ru"}}. {acl, admin, {user, "muzelin", "ruscobank.ru"}}. {hosts, ["ruscobank.ru"]}. {loglevel, 2}. {route_subdomains, s2s}. {listen, [ {5222, ejabberd_c2s, [ {access, c2s}, {shaper, c2s_shaper}, {max_stanza_size, 65536}, starttls, {certfile, "/etc/ejabberd/ejabberd.pem"} ]}, {5269, ejabberd_s2s_in, [ {shaper, s2s_shaper}, {max_stanza_size, 131072} ]}, {5280, ejabberd_http, [ http_poll, web_admin ]} ]}. {s2s_use_starttls, true}. {s2s_certfile, "/etc/ejabberd/ejabberd.pem"}. {auth_method, internal}. {auth_method, ldap}. {ldap_servers, ["rbpost.ruscobank.ru"]}. {ldap_rootdn, "cn=admin,dc=ruscobank,dc=ru"}. {ldap_password, "xxxxxxxx"}. {ldap_base, "dc=ruscobank,dc=ru"}. {ldap_uids, [{"uid", "%u"}]}. {ldap_filter, "(objectClass=ruscobankPerson)"}. {odbc_server, {pgsql, "172.16.116.12", "ejabberd", "postgres", "xxxxxxx"}}. {pgsql_users_number_estimate, true}. {odbc_pool_size, 10}. {odbc_keepalive_interval, undefined}. {shaper, normal, {maxrate, 1000}}. {shaper, fast, {maxrate, 50000}}. {acl, local, {user_regexp, ""}}. {access, max_user_sessions, [{10, all}]}. {access, local, [{allow, local}]}. {access, c2s, [{deny, blocked}, {allow, all}]}. {access, c2s_shaper, [{none, admin}, {normal, all}]}. {access, s2s_shaper, [{fast, all}]}. {access, announce, [{allow, admin}]}. {access, configure, [{allow, admin}]}. {access, muc_admin, [{allow, admin}]}. {access, muc, [{allow, all}]}. % (note that if you remove mod_register from modules list then users will not % be able to change their password as well as register). % This setting is default because it's more safe. {access, register, [{deny, all}]}. {access, pubsub_createnode, [{allow, all}]}. {language, "en"}. {modules, [ {mod_adhoc, []}, {mod_announce, [{access, announce}]}, % requires mod_adhoc {mod_caps, []}, {mod_configure,[]}, % requires mod_adhoc {mod_ctlextra, []}, {mod_disco, []}, {mod_irc, []}, {mod_last_odbc, []}, {mod_muc, [ {host, "ch...@host@"}, {access, muc}, {access_create, muc}, {access_persistent, muc}, {access_admin, muc_admin}, {max_users, 500} ]}, {mod_offline_odbc, []}, {mod_privacy, []}, {mod_private, []}, {mod_proxy65, [ {access, local}, {shaper, c2s_shaper} ]}, {mod_pubsub, [ % requires mod_caps {access_createnode, pubsub_createnode}, {plugins, ["default", "pep"]} ]}, {mod_roster_odbc, []}, {mod_vcard_ldap, [ {ldap_vcard_map, [{"NICKNAME", "%u", []}, % just use user's part of JID as his nickname {"LAST", "%s", ["sn"]}, {"FN", "%s", ["cn"]}, % example: "Smith, John" {"TEL", "%s", ["telephoneNumber"]}, {"ORGUNIT", "%s", ["ou"]}, {"TITLE", "%s", ["title"]}, {"ORGNAME", "%s", ["o"]}, {"LOCALITY", "%s", ["l"]}, {"STREET", "%s", ["street"]}, {"EMAIL", "%s", ["mail"]}]}, {ldap_search_fields, [{"User", "%u"}, {"Family Name", "sn"}, {"Full Name", "cn"}, % example: "Smith, John" {"Email", "mail"}]}, {ldap_search_reported, [{"Full Name", "FN"}, {"Nickname", "NICKNAME"}]} ]}, {mod_stats, []}, {mod_time, []}, {mod_version, []} ]}. as you can see i use ldap for authentification and pgsql for rouster, offline and other backends. i read different erlang manuals and got, that you need pgsql.beam pgsql_proto.beam pgsql_tcp.beam pgsql_util.beam files somewhere in your ebin path.there is an rpm package for fedora9, which contains this files: http://rpm.pbone.net/index.php3/stat/4/idpl/8873534/com/erlang-pgsql-0-2.20080825svn.fc9.i386.rpm.htmli converted it using alien, installed and everything works now.perhaps we need some similar package in debian, because otherwise it is unreal to useejabberd with postgres in debian normal way. taiga:~# uname -aLinux taiga 2.6.26-2-xen-686 #1 SMP Sun Jun 21 09:15:17 UTC 2009 i686 GNU/Linuxtaiga:~# dpkg --list| grep ejabberii ejabberd 2.0.1-6+lenny1 Distributed, fault-tolerant Jabber/XMPP servtaiga:~# cat /etc/debian_version 5.0.2
--- End Message ---
--- Begin Message ---Source: ejabberd Source-Version: 2.1.0-1 We believe that the bug you reported is fixed in the latest version of ejabberd, which is due to be installed in the Debian FTP archive: ejabberd_2.1.0-1.diff.gz to main/e/ejabberd/ejabberd_2.1.0-1.diff.gz ejabberd_2.1.0-1.dsc to main/e/ejabberd/ejabberd_2.1.0-1.dsc ejabberd_2.1.0-1_powerpc.deb to main/e/ejabberd/ejabberd_2.1.0-1_powerpc.deb ejabberd_2.1.0.orig.tar.gz to main/e/ejabberd/ejabberd_2.1.0.orig.tar.gz A summary of the changes between this version and the previous one is attached. Thank you for reporting the bug, which will now be closed. If you have further comments please address them to [email protected], and the maintainer will reopen the bug report if appropriate. Debian distribution maintenance software pp. Gerfried Fuchs <[email protected]> (supplier of updated ejabberd package) (This message was generated automatically at their request; if you believe that there is a problem with it please contact the archive administrators by mailing [email protected]) -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Format: 1.8 Date: Fri, 04 Dec 2009 18:22:49 +0100 Source: ejabberd Binary: ejabberd Architecture: source powerpc Version: 2.1.0-1 Distribution: unstable Urgency: low Maintainer: Torsten Werner <[email protected]> Changed-By: Gerfried Fuchs <[email protected]> Description: ejabberd - Distributed, fault-tolerant Jabber/XMPP server written in Erlang Closes: 502791 507144 519858 526145 540915 558071 Changes: ejabberd (2.1.0-1) unstable; urgency=low . [ Konstantin Khomoutov ] * New upstream release (Closes: #519858). This also adds support for LDAPS upstream (Closes: #526145). * Do not depend on cdbs anymore, port debian/rules to dh+quilt, remove build dependency on patchutils, use erlang-depends. * Bump debhelper version to 7, standards base to 3.8.3 * Depend on erlang R13B. * Recommend imagemagick (for captcha support). * Remove deprecated patches (ssl.patch patch, dynamic_compile_loglevel.patch, ldaps.patch, update.patch, proxy.patch, caps.patch, convert.patch, s2s.patch). * Replace mod_ctlextra with mod_admin_extra. * Use upstream inetrc file. * Bring debian/ejabberd.cfg and ejabberdctl in sync with upstream. * Update ejabberdctl manual page. * Provide NEWS file. * Rework README.Debian: * Group all information into sections. * Describe issues with epam binary (Closes: #502791). * Discuss how to use DBMS backends (Closes: #540915, #507144). * Discuss upgrading from 2.0.x series. * Implement PID file management (Closes: #519858). * Make logrotate process all files matching "*.log". * Improve init script: * Make init script LSB-compliant. * Implement "live" target which allows to run ejabberd in foreground. * Make captcha.sh use bash explicitly. * Rework node-generation for ejabberdctl to fix ejabberd's atom table overflows while preserving the possibility to run several versions of ejabberdctl concurrently as before. * Add webadmin patch restoring compatibility with Erlang/OTP <= R12B-4. * Integrate upstream patch for EJAB-1106. * Add upstream patch for EJAB-1098. * Add upstream patch for EJAB-1045. * Add Konstantin Khomoutov to uploaders. * Add Japanese debconf translation (thanks to Hideki Yamane) (Closes: #558071). . [ Gerfried Fuchs ] * Build-Depend on po-debconf so po2debconf can be called. Checksums-Sha1: d16f0b11e8f4007484889d04be05df84f8048020 1376 ejabberd_2.1.0-1.dsc 003d921d98b16ac1f9b750e700d0e1ceb5f8ce1d 2219822 ejabberd_2.1.0.orig.tar.gz e31cae8d36a035c64688ac2eb150918ee319603a 66255 ejabberd_2.1.0-1.diff.gz b351a9dfdeb4bcba7995abb488512a995ea80475 1331136 ejabberd_2.1.0-1_powerpc.deb Checksums-Sha256: ad29b9be4bc7f96fdc4ed2da88ff9ffa2c53c1dd1df009992ae91f0cb21bb21f 1376 ejabberd_2.1.0-1.dsc b8dcecdb7c29dfd7b16dc717e57aa02f7836022523fc85173a65fb3f9e2af699 2219822 ejabberd_2.1.0.orig.tar.gz 76b3d69bc0eded11cf45699f2c47c3931e786bed47a6b106312d8eb626f6fb43 66255 ejabberd_2.1.0-1.diff.gz 4110c2ebcf13bc7ffa0101de7395296816d07d34de7208122ace81d2d9889079 1331136 ejabberd_2.1.0-1_powerpc.deb Files: 96a058345a29955f43e2fdf6e201e449 1376 net optional ejabberd_2.1.0-1.dsc 373be6e99acf7c930ab85531489c63c4 2219822 net optional ejabberd_2.1.0.orig.tar.gz 4152ec3ee9a0d739c5f6933095ac5ec7 66255 net optional ejabberd_2.1.0-1.diff.gz 2e9fda8bf3f7fcb9e2d105c789a6af7f 1331136 net optional ejabberd_2.1.0-1_powerpc.deb -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) iEYEARECAAYFAksZUQoACgkQELuA/Ba9d8YaDwCcCTAaQ0BkqLRDiC99rXRk3QOd dioAn17XVEGRL3mQvDg5gFUMW3WTeEV1 =eT1s -----END PGP SIGNATURE-----
--- End Message ---
