gmane.network.jabber.ejabberd

Re: mysql connection failed

Hannibal Ndlovu — 2013-05-17T19:25:34

Hello
DB name, username and password in ejabberd.cfg are correct - it was working
correctly and then it stopped and started giving that error



On 17 May 2013 20:00, Ivan Osipov <ivanosipov< at >mail.ru> wrote:

_______________________________________________
ejabberd mailing list
ejabberd< at >jabber.ru
http://lists.jabber.ru/mailman/listinfo/ejabberd

Re: mysql connection failed

Ivan Osipov — 2013-05-17T18:00:51

Hello.
DB name, username and password in ejabberd.cfg are correct? Maybe some 
of this parameters was changed? Check this.

17.05.2013 21:31, Hannibal Ndlovu ?????:

mysql connection failed

Hannibal Ndlovu — 2013-05-17T17:31:58

I have ejabberd ejabberd-2.1.11 installed on debian 6 it was working fine
and then all of a sudden i started seeing this in my ejabberd log. am not
sure how to fix it - my Mysql seems to be working as all other databases
can be connected to and accessed with no problem.

=ERROR REPORT==== 2013-05-17 19:29:49 ===
E(<0.211.0>:ejabberd_odbc:552) : mysql_conn: post_start timeout


=INFO REPORT==== 2013-05-17 19:29:49 ===
I(<0.211.0>:ejabberd_odbc:226) : mysql connection failed:
** Reason: "timed out"
** Retry after: 30 seconds

=WARNING REPORT==== 2013-05-17 19:29:49 ===
W(<0.211.0>:ejabberd_odbc:291) : unexpected info in connecting: {mysql_conn,
                                                                 <0.626.0>,
                                                                 {error,

connect_failed}}

=ERROR REPORT==== 2013-05-17 19:29:49 ===
E(<0.207.0>:ejabberd_odbc:552) : mysql_conn: post_start timeout


=INFO REPORT==== 2013-05-17 19:29:49 ===
I(<0.207.0>:ejabberd_odbc:226) : mysql connection faile

Re: Getting started with ejabberd and Mysql -modules_odbc

Kirill Ratkin — 2013-05-17T10:48:39

Hi Tomas,
Many people here are not native english speakers.

Things you need are already in ejabberd repo or tar ball. You just need to
to several steps to get server up & running:
1. prepare config file
2. create database in your databases server. Note. when ejabberd works in
odbc mode it uses separate database per virtual host.
3. apply mysql.sql scheme to all databases (remember, one databases per
virtual host)
4. start jabbered

For example you can see my config file. There are two domains (example.com&
example.org) and two databases called 'examplecom' & 'exampleorg'. Database
user 'ejabberd' and his password 'pazzword'. Of course you need to create
this mysql user and grant him access on two these databases before.

Note, when you build ejabberd and erlang/otp you should be sure option
--enable-odbc is enabled.
And also when I started ejabberd with odbc support I got runtime message
about ... mysql driver is out or my system.
So I built & installed this driver:
https://github.com/deployfu/erlang-mysql-

Getting started with ejabberd and Mysql - modules_odbc

T.Prokopp — 2013-05-17T09:58:16

Hello List,

This is my first posting and i am not an native english speaker so 
please excuse my bad writing.
I started reading on ejabberd now for something some days and wanted to 
start testing.
I downloaded the latest stable source (2.1.12) from : 
http://www.ejabberd.im/ejabberd-2.1.12--13.03-beta1
and compiled it with the env needs on my server.

Everything went fine and i could start ejabberd with Mnesia as backend.
But my goal is to have it running with MySQL. So i read another 
"thousands" Post on the net to skill myself.
I know i need the "mod_MODNAME_odbc.erl" Sourcefiles to get it done but 
i do not find them in none of the repos.
I found some (only 2 or 3 odbc_modules), in old github/svn repos but i 
wanted to ask you , for a general place to fetch them.

Would you be so kind to provide me with some informations to get further 
with this project.

Best Regards from Germany

Thomas

Re: add_ and delete_rosteritem throughput

Steven Lehrburger — 2013-05-16T16:50:15

Hi David, thanks for the algorithm/questions. Answers below!

a.1) What are these roster pushes for?

I'm working on a chat product that feels more like real-life group social
situations (office, conference, party, coffee shop, etc). Users can see the
conversations their friends are having, but not what they're saying unless
they join that conversation. I've built it on top of XMPP so that it works
with existing clients, and this GIF shows the basics of what I've built so
far: https://dashdash.com/static/img/screencast.gif.

The roster displays for the user the active conversations that s/he can
see. I do a roster push when: a conversation starts, a conversation ends,
or the participants in a conversation change. That push needs to go to the
participants, as well as to each user who is a "friend" on the service of
any of the participants, so it's a potentially large number.

b.1) How are they grouped?

Each user has one roster group of contacts, and one roster group of
conversations. Contacts move from the f

Re: add_ and delete_rosteritem throughput

David Laban — 2013-05-16T14:06:56

Steven

Thinking laterally, let's go back a couple of steps.

My Dad's "Standard British Telecom Problem Solving Algorithm" has the 
following steps:

1) Where are we now?
2) Where did we come from?
3) Where Could we be?
4) Where Should we be?
5) How do we get there?

Can you give me a few more details about steps 1 and 2? Specifically:

a.1) What are these roster pushes for?
b.1) How are they grouped?
  b.3) Would something like http://www.ejabberd.im/shared-roster-all ?)
c.1) Is there any redundancy?
e.1) Do online clients *need* to be notified about them immediately?
  e.3) Could you inject the changes directly into the sql db and then inject a
       roster push in sideways (or "if not online: inject into sql")
f.1) Do you have control of the client software?
f.2) Do you need to support legacy versions of client software?
f.3) Can legacy versions be allowed to have known regressions (like e.1)?

David.

On Thursday 16 May 2013 08:48:09 Steven Lehrburger wrote:
<lehrburger< at >gmail.com>wrote:

Re: add_ and delete_rosteritem throughput

Steven Lehrburger — 2013-05-16T07:48:09

To answer the last of my questions: I can just call
ejabberdctl's connected_users_info instead of user_sessions_info to
efficiently get the information I need to further-prioritize roster changes.

That said, I'm still curious about how I might increase the overall
add_rosteritem and delete_rosteritem throughput, and, if I can't increase
throughput, whether my priority queue workaround sounds reasonable, and, if
it is reasonable, how to figure out how many requests the queue readers can
make simultaneously.

Thanks!

/~s


On Wed, May 15, 2013 at 1:37 PM, Steven Lehrburger <lehrburger< at >gmail.com>wrote:

_______________________________________________
ejabberd mailing list
ejabberd< at >jabber.ru
http://lists.jabber.ru/mailman/listinfo/ejabberd

Unable to see online status of users

o0beaner — 2013-05-15T18:13:57

I am attempting to configure my new ejabberd installation to display online
status of everyone else on the server. So far, this has been unsuccessful.
I am using a php file that talks to a phpbb3 forum installation via curl
for authentication and account creation. This piece, at least, is working.

Two test accounts login to the server, and neither can see the other as
being online. They can add each other as a contact, and they both show as
being offline.

I have installed mod_webpresence, and made the following changes to my
ejabberd.cfg file:

 {5280, ejabberd_http, [
                         {request_handlers,
                          [
                            {["presence"], mod_webpresence}
                          ]},
                         %%captcha,
                         http_bind,
                         http_poll,
                         web_admin
                        ]}

%% Web presence auto enrollment
{access, webpresence_auto, [{allow, local}]}.

 {mod_webpresence, [
    {access,

add_ and delete_rosteritem throughput

Steven Lehrburger — 2013-05-15T17:37:04

Hi,

I've been using ejabberd along with an XMPP component in an application
that requires regular changes to user rosters.

I often need to make as many as 150 of these changes at a time, and this
number will increase as the service grows. I've been doing this from my
component via XML-RPC, but get "[Errno 104] Connection reset by peer" on
some requests, while others take 20 seconds or more to return, even though
the timeout is set to 5 seconds and maxsessions is set to infinity.

I've just been retrying the requests that fail, but the slow requests cause
user experience problems. Furthermore, some of the requests are more urgent
than others, and if ejabberd is still busy churning through one batch of
150 when a second comes in, then things get really clogged up. I'm running
ejabberd on an m1.small Amazon EC2 instance.

Does anyone have any suggestions on how I might increase throughput?

A few other thoughts/ideas/questions:


1) I considered switching from Mnesia to MySQL so that I could modify the
roster

/etc/mail/virtusertable, with Sender Rewrite Scheme,for XMPP?

Constantine A. Murenin — 2013-05-05T18:12:20

Hello,

I have an OpenBSD server, and I'm looking for a way to make several of
my domain-names be jabber-aware; however, I have a requirement of not
having any actual local accounts into which one must login to receive
and send messages -- everything should be forwarded to, say, a
gmail.com account, with mostly transparent address rewriting.

Basically, say, I have "example.su"; I give someone an address of
"me< at >example.su", they message it from "them< at >example.com", my server at
"example.su" receives it, and rewrites the the from and to addresses
(similar to how ~/.forward or /etc/mail/virtualusertable with Sender
Rewrite Scheme would work), and forwards it to my < at >gmail.com account,
with the from address of something like "them%example.com< at >example.su",
or, maybe even "them%example.com%me< at >example.su".  Or if I need to
contact "them< at >example.com" myself, I'd simply initiate a conversation
with "them%example.com%me< at >example.su" from my gmail.

In email / sendmail terms, I'm looking for an
`/etc/mail/virtusertable`

SCRAM password for MySQL

Kirill Ratkin — 2013-05-05T13:02:02

Guy,
One more question ...
Jira issue says SCRAM password for ODBC should work properly.
But I can't configure it.

When I add subscriber his password is in plain text in sql table.

Here is my config file attached ....
_______________________________________________
ejabberd mailing list
ejabberd< at >jabber.ru
http://lists.jabber.ru/mailman/listinfo/ejabberd

Re: Different users for different domains

Kirill Ratkin — 2013-05-05T08:41:16

Hi Mickaël.
Yes, that what I do.
It works ... excepting scram password.
Yesterday I wrote about it.

And I actually hope odbc modules are free from serious bugs. I'm going to
use it in production.



2013/5/5 Mickaël Rémond <mremond< at >process-one.net>

_______________________________________________
ejabberd mailing list
ejabberd< at >jabber.ru
http://lists.jabber.ru/mailman/listinfo/ejabberd

Re: Different users for different domains

Mickaël Rémond — 2013-05-04T20:16:04

Hello,

ODBC module is not buggy. You must configure the a database per domain.
Le 4 mai 2013 19:26, "Kirill Ratkin" <kirill.v.ratkin< at >gmail.com> a écrit :

_______________________________________________
ejabberd mailing list
ejabberd< at >jabber.ru
http://lists.jabber.ru/mailman/listinfo/ejabberd

Re: Different users for different domains

Bzzz — 2013-05-04T17:36:02

On Sat, 4 May 2013 21:25:59 +0400
Kirill Ratkin <kirill.v.ratkin< at >gmail.com> wrote:


Please, report your whole mod'op here for others!
 

This is unfortunately often the case…
[troll mode] not to mention mysql isn't a real RDBMS [/troll mode]

JY

Re: Different users for different domains

Kirill Ratkin — 2013-05-04T17:25:59

Hi

I do same tests using ejabberd configured by default (Mnesia instead MySQL).
And I wonder! It works! There are different users for different domains. I
create two users named 'u2' for example.com and example.org and there are
different users with different rosters.

It seems  odbc modules are buggy .... :(



2013/5/4 Bzzz <lazyvirus< at >gmx.com>

_______________________________________________
ejabberd mailing list
ejabberd< at >jabber.ru
http://lists.jabber.ru/mailman/listinfo/ejabberd

Re: Different users for different domains

Kirill Ratkin — 2013-05-04T16:19:30

Yes. it's idea but this is not so common ...
it's just two domains for example ... it could be three, four, five domains
...

What I configure now and ... it seems it works ...

I create two DB in my MySQL ... each DB for each domain.
There are DB excom for example.com and exorg for example.org

And comment line with odic_server:
%%{odbc_server, {mysql, "192.168.1.106", "ejabberdb", "ejabberd", "pass"}}.

But I change odbc_server lines for virtual hosts

{host_config, "example.com", [{auth_method, odbc},
        {odbc_server, {mysql, "192.168.1.106", "excom", "ejabberd",
"pass"}}]}.
{host_config, "example.org", [{auth_method, odbc},
        {odbc_server, {mysql, "192.168.1.106", "exorg", "ejabberd",
"pass"}}]}.

Then I create user 'u2' in both domains. And 'select * from users' returns
'u2' in both databases;
After I create user 'uu' in example.com and add him as friend to u2 in
example.com domain.

Then I do 'select * from rosterusers' for both domain and I see records in
example.com and no records in examp

Re: Different users for different domains

Bzzz — 2013-05-04T15:58:39

On Sat, 4 May 2013 19:34:01 +0400
Kirill Ratkin <kirill.v.ratkin< at >gmail.com> wrote:


Perhaps this is not the answer you're looking after, but why not
using 2 servers and have them talking to each other?

This way, you have the wanted result plus a security: if one of
the server is down for any reason, the other continues to work
and only one half of the users wants to kill you painfully ;-)

JY

Different users for different domains

Kirill Ratkin — 2013-05-04T15:34:01

Hi,

I want to configure ejabberd for two domains but I want users were in
different domains.
For example I have two domains: example.com and example.org
and user Bob.
I want Bob can to login using JID bob< at >example.com but he can not login as
bob< at >example.org with same password.
In other words I want to have two 'different Bobs' (no no, I'm not about
Superstring Theory) (just one Bob is in example.com and another one is in
example.org).

What I'm trying now is to configure virtual hosts :

{host_config, "example.com", [{auth_method, odbc},
        {odbc_server, "DSN=excom;UID=ejabberd;PWD=pass"}]}.
{host_config, "example.org", [{auth_method, odbc},
        {odbc_server, "DSN=exorg;UID=ejabberd;PWD=pass"}]}.

But is doesn't work because below in cfg file I have settings for MySQL
connection ...
{odbc_server, {mysql, "192.168.1.106", "ejabberdb", "ejabberd", "pass"}}.

And ejabberd connects to this database (ejabberdb) instead DSN in
host_config ...

So gentlemen, I need your help ... maybe I go to wrong way ...

disco#info get maxusers

Michael Holm — 2013-05-01T09:26:58

Hi,

Im about to build a tool where i am able to see how many users is in a
room, and if the room is filled, i will create a new room..

Also i will be able to list how many free places in a room is left, I
cannot find a way :/

I read this post, which is about the subject, and it should be possible
some how..
http://stackoverflow.com/questions/11805102/xmpp-muc-max-users

I can send a disco#info request to the room, but it seems like ejabberd
only supply me with:

description and current occupants

are there any way i can get the maxusers number too?
Best regards,
Michael Holm
_______________________________________________
ejabberd mailing list
ejabberd< at >jabber.ru
http://lists.jabber.ru/mailman/listinfo/ejabberd

Re: XEP-0313

Mickaël Rémond — 2013-04-30T16:36:44

Hello,

If you want to be future proof, I would advise you to make sure you have it
working with the master ejabberd branch:
https://github.com/processone/ejabberd

A lot is happening in there right now.