You have to look for DB_VERSION or something similar in usrloc module
and check wether this value corresponds to the one appearing in the
version table corresponding to the usrloc module.
If they are different, you have to modify the version table to match
the usrloc requirements...as Vaclav said maybe somebody forget to
update it in the module or in the database..
Great news about the NOTIFY!!!! Let's see if I can ceck it in the
coming weeks....
samuel.
2006/5/26, İlker Aktuna (Koç. net ) <ilkera(a)koc.net>et>:
Hi,
Thanks for your reply; but I've already tried dropping and creating with the
mysql scripts that are supplied.
Unfortunately they are not creating suitable database version for usrloc.
Have you tried using usrloc with db support ?
Btw, with the latest CVS sources presence is working fine. I have no problem
with sending notifications.
I just have the problem with usrloc db support now. And thus I need the db
structure for new CVS version.
Thanks,
ilker
-----Original Message-----
From: samuel [mailto:samu60@gmail.com]
Sent: Friday, May 26, 2006 12:17 PM
To: İlker Aktuna (
Koç.net)
Cc: Vaclav Kubart; serusers(a)iptel.org
Subject: Re: PA error sending notifies
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(a)koc.net>et>:
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@iptel.org]
Sent: Friday, May 26, 2006 8:18 AM
To: İlker Aktuna (
Koç.net)
Cc: serusers(a)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@iptel.org]
Sent: Thursday, May 25, 2006 4:26 PM
To: ?lker Aktuna (
Koç.net)
Cc: serusers(a)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(a)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@gmail.com]
> Sent: Tuesday, May 23, 2006 5:05 PM
> To: ?lker Aktuna (
Koç.net)
> Cc: Vaclav Kubart; serusers(a)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(a)koc.net>et>:
>
>
>
>
> > 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.
<http://387555.sigclick.mailinfo.com/sigclick/010C0605/07044406/0B044D
______________________________________________________________________
______________________________________________________________________
_ 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.
______________________________________________________________________
______________________________________________________________________
> _
_____________________________________________________________________________________________________________________________________________
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.
_____________________________________________________________________________________________________________________________________________