[Serusers] Re: PA error sending notifies

[samuel]

The HEAD CVS version has a completely different database structure
than the stable version. You have to drop the older version and use
the new one. Next is a SIMPLIFICATION of a possible way to drop the
old structure and create the new one:

The simple way to do it is with the script ser_mysql.sh, which uses
my_create.sql and my_drop.sql so be sure you've got the three scripts
in /usr/local/sbin. When you type form the shell:

#ser_mysql.sh

you'll see which are the possible options, being the most relevant
drop and create

typing

#ser_mysql.sh drop

and later

#ser_mysql.sh create


You'll have in the local machine the SER database.


Hope it helps,

Samuel

2006/5/26, İlker Aktuna   (Koç. net  ) <ilkera at koc.net>:
>
>
>
>
> Hi vaclav,
>
> How can I get help for the usrloc db problem ?
> I don't know the necessary db structure for usrloc. Does it need a table
> named usrloc ?
> Please point me to the correct  address for help on the db structure.
>
> Btw, I'm downloading the new cvs sources now and I'll try it. I hope the
> sending notifies problem is solved for my case too.
>
> Thanks,
> ilker
>
> -----Original Message-----
> From: Vaclav Kubart [mailto:vaclav.kubart at iptel.org]
> Sent: Friday, May 26, 2006 8:18 AM
> To: İlker Aktuna (Koç.net)
> Cc: serusers at iptel.org; samuel
> Subject: Re: PA error sending notifies
>
> It was something forgotten in modules/tm/ut.h, now it is corrected on CVS.
>
> I have no such DB error, but I'm not using usrloc/registrar with DB.
> May be that somebody increments the version number in code and forgot
> increment the table version number in DB initialization or something like
> that.
>
>         Vaclav
>
> On Thu, May 25, 2006 at 04:35:26PM +0300, ?lker Aktuna (Koç.net) wrote:
> > Great :)
> > That's good nes for me, because I couldn't make you believe that there
> > was a serious problem :) Now how shall we proceed ?
> >
> > Btw, you'll also have the following error in latest CVS, can you check ?
> >
> > May 25 16:44:57 sesapp /root/ser/sbin/ser[3173]: register_udomain():
> > Invalid table version (use ser_mysql.sh reinstall) May 25 16:44:57
> > sesapp /root/ser/sbin/ser[3173]: register_udomain(): Invalid table
> > version (use ser_mysql.sh reinstall)
> >
> > Regards,
> > ilker
> >
> > -----Original Message-----
> > From: Vaclav Kubart [mailto:vaclav.kubart at iptel.org]
> > Sent: Thursday, May 25, 2006 4:26 PM
> > To: ?lker Aktuna (Koç.net)
> > Cc: serusers at iptel.org; samuel
> > Subject: Re: PA error sending notifies
> >
> > I updated to latest CVS sources and I have the same problem now!
> > [Can't send watcherinfo notification (-7)]
> >
> >         Vaclav
> >
> > On Wed, May 24, 2006 at 10:45:42AM +0300, ?lker Aktuna (Koç.net) wrote:
> > > Hi Vaclav,
> > >
> > > I want to install and run Ser on an identical linux setup with you
> > > to overcome the notification sending issue (thus presence) That's why I
> need the library versions that you use.
> > > Also I need to know which version of Debian Sarge you are using.
> > > And your ser snapshot version.
> > >
> > > Can you supply me these information please ?
> > >
> > > Thanks,
> > > ilker
> > >
> > >
> > > ________________________________
> > >
> > > From: ?lker Aktuna (Koç.net)
> > > Sent: Tuesday, May 23, 2006 5:44 PM
> > > To: 'samuel'
> > > Cc: Vaclav Kubart; serusers at iptel.org
> > > Subject: RE: PA error sending notifies
> > >
> > >
> > >
> > > So you are not able to use presence but other traffic (IM, voice etc.)
> is fine ?
> > > Do you know the xml parser library that your system has installed ?
> > > Vaclav, which library version do you use ?
> > >
> > > Thanks,
> > > ilker
> > >
> > > -----Original Message-----
> > > From: samuel [mailto:samu60 at gmail.com]
> > > Sent: Tuesday, May 23, 2006 5:05 PM
> > > To: ?lker Aktuna (Koç.net)
> > > Cc: Vaclav Kubart; serusers at iptel.org
> > > Subject: Re: PA error sending notifies
> > >
> > > Unfortunately I had no more time to look into it, so I have no more
> progress..I just saw that the contact header was not properly parsed and
> there were problems when selecting the local socket where to send the
> notifies from...I hope in the following weeks I find some more time to spend
> on it.
> > >
> > > Samuel.
> > >
> > >
> > > 2006/5/23, ?lker Aktuna   (Koç. net  ) <ilkera at koc.net>:
> > > >
> > > >
> > > >
> > > >
> > > > Hi Samuel,
> > > >
> > > > Did you solve the issue where sending notifies would fail with
> > > > error code -7 ?
> > > >
> > > > "Can't send watcherinfo notification (-7)"
> > > >
> > > > If you solved it can you tell me how ?
> > > >
> > > > I believe the problem is occuring while creating the headers.
> > > > Because in "notify.c" I see that -7 is returned only while creating
> headers.
> > > >
> > > > Regards,
> > > > ilker
> > > >
> >
> >
> >
> >
> >
> <http://387555.sigclick.mailinfo.com/sigclick/010C0605/07044406/0B044D
> > 02/12410218.jpg>
> >
> ______________________________________________________________________
> >
> ______________________________________________________________________
> > _ Bu e-posta mesaji kisiye ozel olup, gizli bilgiler iceriyor
> > olabilir. Eger bu e-posta mesaji size yanlislikla ulasmissa,  icerigini
> hic bir sekilde kullanmayiniz ve ekli dosyalari acmayiniz. Bu durumda lutfen
> e-posta mesajini kullaniciya hemen geri gonderiniz  ve  tum kopyalarini
> mesaj kutunuzdan siliniz. Bu e-posta mesaji, hic bir sekilde, herhangi bir
> amac icin cogaltilamaz, yayinlanamaz ve para karsiligi satilamaz.  Bu
> e-posta mesaji viruslere karsi anti-virus sistemleri tarafindan taranmistir.
> Ancak yollayici, bu e-posta mesajinin - virus koruma sistemleri ile kontrol
> ediliyor olsa bile - virus icermedigini garanti etmez ve meydana gelebilecek
> zararlardan dogacak hicbir sorumlulugu kabul etmez.
> > This message is intended solely for the use of the individual or entity to
> whom it is addressed , and may contain confidential  information. If you are
> not the intended recipient of this message or you receive this mail in
> error, you should refrain from making any use of the contents and from
> opening any attachment. In that case, please notify the sender immediately
> and return the message to the sender, then, delete and destroy all copies.
> This e-mail message, can not be copied, published or sold for any reason.
> This e-mail message has been swept by anti-virus systems for the presence of
> computer viruses. In doing so, however,  sender  cannot warrant that virus
> or other forms of data corruption may not be present and do not take any
> responsibility in any occurrence.
> >
> ______________________________________________________________________
> >
> ______________________________________________________________________
> > _
>
>
>
>
>
> _____________________________________________________________________________________________________________________________________________
> Bu e-posta mesaji kisiye ozel olup, gizli bilgiler iceriyor olabilir. Eger
> bu e-posta mesaji size yanlislikla ulasmissa,  icerigini hic bir sekilde
> kullanmayiniz ve ekli dosyalari acmayiniz. Bu durumda lutfen e-posta
> mesajini kullaniciya hemen geri gonderiniz  ve  tum kopyalarini mesaj
> kutunuzdan siliniz. Bu e-posta mesaji, hic bir sekilde, herhangi bir amac
> icin cogaltilamaz, yayinlanamaz ve para karsiligi satilamaz.  Bu e-posta
> mesaji viruslere karsi anti-virus sistemleri tarafindan taranmistir. Ancak
> yollayici, bu e-posta mesajinin - virus koruma sistemleri ile kontrol
> ediliyor olsa bile - virus icermedigini garanti etmez ve meydana gelebilecek
> zararlardan dogacak hicbir sorumlulugu kabul etmez.
> This message is intended solely for the use of the individual or entity to
> whom it is addressed , and may contain confidential  information. If you are
> not the intended recipient of this message or you receive this mail in
> error, you should refrain from making any use of the contents and from
> opening any attachment. In that case, please notify the sender immediately
> and return the message to the sender, then, delete and destroy all copies.
> This e-mail message, can not be copied, published or sold for any reason.
> This e-mail message has been swept by anti-virus systems for the presence of
> computer viruses. In doing so, however,  sender  cannot warrant that virus
> or other forms of data corruption may not be present and do not take any
> responsibility in any occurrence.
> _____________________________________________________________________________________________________________________________________________
>