<HTML >
<HEAD>
<META http-equiv="Content-Type" content="text/html; charset=us-ascii">
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=UTF-16"><TITLE></TITLE>
<META http-equiv=EXPIRES content=0>
<META http-equiv=EXPIRESABSOLUTE content="Tue, 01 Jun 1999 12:00:00 GMT">
<META http-equiv=PRAGMA content=NO-CACHE>
<META http-equiv=CACHE-CONTROL content=PRIVATE>
<META http-equiv=CACHE-CONTROL content=NO-CACHE>
<META content="MSHTML 6.00.2900.2802" name=GENERATOR></HEAD>
<BODY >
<DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=248393509-17032006>Hi,</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=248393509-17032006></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=248393509-17032006>as you know, I</SPAN></FONT><FONT face=Arial
color=#0000ff size=2><SPAN class=248393509-17032006> had to change mysql
urls in the cfg to "mysql://ser:heslo@localhost:3306/ser" from
"mysql://ser:heslo@127.0.0.1:3306/ser"</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=248393509-17032006>(because ser daemon were dying with error "<FONT
face="Times New Roman" color=#000000>Mar 16 13:26:33 asterisk1 ./ser[19374]:
new_connection: Access denied for user: 'ser@asterisk1.local' (Using
password: YES)" )</FONT></SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face="Times New Roman" color=#000000 size=2><SPAN
class=248393509-17032006></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=248393509-17032006>could it be that, now ser can't query the db
?</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=248393509-17032006></SPAN></FONT> </DIV>
<DIV dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> serusers-bounces@lists.iptel.org
[mailto:serusers-bounces@lists.iptel.org] <B>On Behalf Of </B>İlker Aktuna
(Koç.net)<BR><B>Sent:</B> Friday, March 17, 2006 10:55 AM<BR><B>To:</B> Vaclav
Kubart<BR><B>Cc:</B> serusers@lists.iptel.org<BR><B>Subject:</B> RE: [Serusers]
Problem starting SER with Presence support<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><!-- Converted from text/plain format -->
<P><FONT size=2>Hi,<BR><BR>I see the domain in the table (output below). But my
user don't get registered (with or without password).<BR>Below is also a list of
my tables in the ser db. Is there any table I am missing ?<BR><BR>I still get
the following messages in /var/log/messages when I try to register
"3229@test-domain.com" :<BR><BR>Mar 17 10:53:14 asterisk1
/root/ser/sbin/ser[24777]: Unknown domain - message should be forwarded?<BR>Mar
17 10:53:16 asterisk1 /root/ser/sbin/ser[24777]: Unknown domain - message should
be forwarded?<BR><BR><BR>mysql> SELECT * FROM
domain;<BR>+------+-----------------+----------------+-------+<BR>| did |
domain |
last_modified | flags
|<BR>+------+-----------------+----------------+-------+<BR>| test |
test-domain.com | 20060316152632 | 37
|<BR>+------+-----------------+----------------+-------+<BR>1 row in set (0.01
sec)<BR><BR>mysql> show tables;<BR>+-----------------------+<BR>|
Tables_in_ser
|<BR>+-----------------------+<BR>|
acc
|<BR>|
attr_types
|<BR>| credentials
|<BR>|
customers
|<BR>|
domain
|<BR>| domain_attrs |<BR>|
global_attrs |<BR>|
grp
|<BR>|
gw
|<BR>|
gw_grp
|<BR>|
i18n
|<BR>|
lcr
|<BR>|
location
|<BR>| missed_calls |<BR>|
offline_winfo |<BR>|
pdt
|<BR>|
phonebook
|<BR>|
presentity
|<BR>| presentity_contact |<BR>|
presentity_notes |<BR>|
presentity_persons |<BR>|
rls_subscription |<BR>|
rls_vs
|<BR>| rls_vs_names |<BR>|
sd_attrs
|<BR>| server_monitoring |<BR>| server_monitoring_agg
|<BR>|
silo
|<BR>|
speed_dial
|<BR>|
trusted
|<BR>| tuple_notes
|<BR>|
uri
|<BR>|
user_attrs
|<BR>|
version
|<BR>| watcherinfo
|<BR>+-----------------------+<BR>35 rows in set (0.01 sec)<BR><BR><BR>Thanks
for any help & have a nice day,<BR>ilker<BR><BR><BR>-----Original
Message-----<BR>From: Vaclav Kubart [<A
href="mailto:vaclav.kubart@iptel.org">mailto:vaclav.kubart@iptel.org</A>]<BR>Sent:
Friday, March 17, 2006 9:24 AM<BR>To: İlker Aktuna (Koç.net)<BR>Cc: Steve Blair;
serusers@lists.iptel.org<BR>Subject: Re: [Serusers] Problem starting SER with Presence
support<BR><BR>Passwords are not needed for my config file, because there is no
authentication. Passwords can you give using ser_cred utility (from new
serctl).<BR><BR>The message about domain is strange - if you really use this
domain (in To URI), the request should be accepted - you can try to reinitialize
your database (run the initialization script). Then in mysql try to
run:<BR> SELECT * FROM domain;<BR>and you will see which domains are
accepted. There should be at least
"test-domain.com".<BR><BR>
Vaclav<BR><BR><BR></FONT></P></DIV>
<DIV style="FONT-SIZE: 7pt; COLOR: gray; FONT-FAMILY: verdana">
<DIV style="FONT-SIZE: 7pt; COLOR: gray; FONT-FAMILY: verdana">
<DIV
style="FONT-SIZE: 7pt; COLOR: gray; FONT-FAMILY: verdana">_____________________________________________________________________________________________________________________________________________</DIV>
<DIV style="FONT-SIZE: 7pt; COLOR: gray; FONT-FAMILY: verdana">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.
</DIV>
<DIV style="FONT-SIZE: 7pt; COLOR: gray; FONT-FAMILY: verdana">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.</DIV>
<DIV
style="FONT-SIZE: 7pt; COLOR: gray; FONT-FAMILY: verdana">_____________________________________________________________________________________________________________________________________________</DIV>
<DIV style="FONT-SIZE: 7pt; COLOR: gray; FONT-FAMILY: verdana"
align=justify></DIV></DIV></DIV>
<!--455254417B59-->
<br><br><a href="http://271570.sigclick.mailinfo.com/sigclick/0405020D/0E014F09/070B4F0A/16238913.jpg"><img src="http://271570.signature1.mailinfo.com/confirm2.6/0405020D/0E014F09/070B4F0A/16238913.jpg" border="0" nosend="1"></a><!--455254417B59//--></DIV>
<DIV STYLE="FONT-SIZE: 7pt; COLOR: gray; FONT-FAMILY: verdana">
<DIV STYLE="FONT-SIZE: 7pt; COLOR: gray; FONT-FAMILY: verdana">
<DIV STYLE="FONT-SIZE: 7pt; COLOR: gray; FONT-FAMILY: verdana">_____________________________________________________________________________________________________________________________________________</DIV>
<DIV STYLE="FONT-SIZE: 7pt; COLOR: gray; FONT-FAMILY: verdana">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. </DIV>
<DIV STYLE="FONT-SIZE: 7pt; COLOR: gray; FONT-FAMILY: verdana">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.</DIV>
<DIV STYLE="FONT-SIZE: 7pt; COLOR: gray; FONT-FAMILY: verdana">_____________________________________________________________________________________________________________________________________________</DIV>
<DIV STYLE="FONT-SIZE: 7pt; COLOR: gray; FONT-FAMILY: verdana" ALIGN="justify">
</DIV>
</DIV>
</DIV></BODY></HTML>