Fwd: [Serusers] Adding users in the loaded db

[samuel]

Forgot to send it to the list.....I'm still on holiday mood.....

Sam.

---------- Forwarded message ----------
From: samuel <samu60 at gmail.com>
Date: 12/12/2005 09:59
Subject: Re: [Serusers] Adding users in the loaded db
To: Xavier TRENTIN <xtrentin at softiphone.net>


Hi all!!!

If you use serctl, it will do both load the user in the database and
in the cache automatically. what serctl does:
Update the database: standard [mysql] query.
Update SER's cache: it makes use of the exported FIFO command ul_add:

serctl fifo ul_add <table> <aor> <contact> <expires> <q> <replicat> <flags>
example:
serctl fifo ul_add location sam at example.com sam at 1.2.3.4 3600 1 0 0

about the dbtext...let my guess...I've been out for a while and things
may have changed but I think serctl in the SER CVS does not handle
dbtext...there was a post from Cesc with some patche adding dbtext
support to serctl and I think that in the openser repository there's
some dbtext serctl....

Hope it helps,

Sam.

2005/12/11, Xavier TRENTIN <xtrentin at softiphone.net>:
> I agree with you except that if SER is running and I add a user in my
> dbtext subscriber table,
> he can't register if I don't restart SER.
>
> sip a écrit :
>
> >***********************
> >Pas de virus detecté dans l'attachement no filename
> >
> >Votre Mail a été vérifié par InterScan.
> >***********-***********
> >
> >
> >SER doesn't really load users on startup into memory except from the location
> >table (i.e. user/contact information).  When you create a user in the
> >subscriber table, that user is added. Then, when his client sends a register,
> >he gets added to the location table in memory/in the db.  There's nothing you
> >really need to to to manually add someone to the location table... and really,
> >there's nothing you SHOULD be doing. Users add themselves on login with all
> >the correct information about their contact info.
> >
> >N.
> >
> >
> >On Fri, 09 Dec 2005 18:58:56 +0100, Xavier TRENTIN wrote
> >
> >
> >>Hi,
> >>
> >>I'd like to know if there is a way to add users in the database
> >>loaded in memory, using a fifo command for example?
> >>
> >>If, yes, could you give an exemple.
> >>
> >>Cause I don't want to restart ser anytime I add a user ;p
> >>
> >>B.R.
> >>Xavier.
> >>
> >>_______________________________________________
> >>Serusers mailing list
> >>serusers at lists.iptel.org
> >>http://lists.iptel.org/mailman/listinfo/serusers
> >>
> >>
> >
> >
> >
> >
>
> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
>