<HTML >
<HEAD>
<META http-equiv="Content-Type" content="text/html; charset=us-ascii">
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=UTF-16">
<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">
<TITLE></TITLE>
<META content="MSHTML 6.00.2900.2802" name=GENERATOR></HEAD>
<BODY >
<DIV><!-- Converted from text/plain format -->
<P><FONT size=2><BR>Hi,<BR><BR>I get the following results with your suggested
commands:<BR>mysql> GRANT ALL ON ser.* TO 'ser'@'127.0.0.1' IDENTIFIED BY
'heslo';<BR>Query OK, 0 rows affected (0.00 sec)<BR><BR>mysql> GRANT ALL ON
ser.* TO 'ser'@'localhost' IDENTIFIED BY 'heslo';<BR>Query OK, 0 rows affected
(0.00 sec)<BR><BR>So no rows are affected ?<BR><BR>Btw, if I change all
127.0.0.1 with "localhost" on cfg file, Ser starts successfully.<BR><BR>This
time I couldn't register my client. When I get tcpdump traces I see the error
483 "too many hops"<BR>Btw, which password should I use with my users ?<BR>Your
dbinit script creates some users but what are their passwords
?<BR><BR>Thanks,<BR>ilker<BR><BR>-----Original Message-----<BR>From: Vaclav
Kubart [<A
href="mailto:vaclav.kubart@iptel.org">mailto:vaclav.kubart@iptel.org</A>]<BR>Sent:
Thursday, March 16, 2006 2:42 PM<BR>To: İlker Aktuna (Koç.net)<BR>Cc:
serusers@lists.iptel.org<BR>Subject: Re: [Serusers] Problem starting SER with Presence
support<BR><BR>You have probably badly set privileges in database. Try to
tun<BR><BR>GRANT ALL ON ser.* TO 'ser'@'localhost' IDENTIFIED BY
'heslo';<BR><BR>or<BR><BR>GRANT ALL ON ser.* TO 'ser'@'127.0.0.1' IDENTIFIED BY
'heslo';<BR><BR>or something like that in mysql (you must be root for that) and
try it again.<BR><BR> Vaclav<BR><BR>On
Thu, Mar 16, 2006 at 02:13:35PM +0200, ?lker Aktuna (Koç.net) wrote:<BR>> I
can login with:<BR>> # mysql -P 3306 -user -pheslo ser<BR>><BR>>
but I can't login with:<BR>> # mysql -h 127.0.0.1 -P 3306 -user -pheslo
ser<BR>><BR>> ________________________________<BR>><BR>> From: ?lker
Aktuna (Koç.net)<BR>> Sent: Thursday, March 16, 2006 2:11 PM<BR>> To:
'Vaclav Kubart'<BR>> Cc: serusers@lists.iptel.org<BR>> Subject: RE: [Serusers]
Problem starting SER with Presence support<BR>><BR>><BR>><BR>> I got
the folowing error:<BR>><BR>> # mysql -h 127.0.0.1 -P 3306 -user -pheslo
ser ERROR 1045: Access<BR>> denied for user: 'ser@asterisk1.local' (Using
password: YES)<BR>><BR>><BR>> -----Original Message-----<BR>> From:
Vaclav Kubart [<A
href="mailto:vaclav.kubart@iptel.org">mailto:vaclav.kubart@iptel.org</A>]<BR>>
Sent: Thursday, March 16, 2006 1:58 PM<BR>> To: ?lker Aktuna
(Koç.net)<BR>> Cc: serusers@lists.iptel.org<BR>> Subject: Re: [Serusers] Problem
starting SER with Presence support<BR>><BR>> Are you able to work with ser
database using mysql like this?<BR>><BR>> mysql -h 127.0.0.1 -P 3306 -user
-pheslo ser<BR>><BR>> You can try to increase debug level in SER's config
file (debug=4) and see messages in
log.<BR>><BR>>
Vaclav<BR>><BR>><BR>> On Thu, Mar 16, 2006 at 01:36:20PM +0200, ?lker
Aktuna (Koç.net) wrote:<BR>> > Hi,<BR>> ><BR>> > Thanks; I did
it that way and now the server starts but then exits.<BR>> > I see the
following lines in my /var/log/messages file:<BR>> ><BR>> > Mar 16
13:26:33 asterisk1 ./ser[19374]: new_connection: Access<BR>> > denied for
user: 'ser@asterisk1.local' (Using password: YES) Mar 16<BR>> >
13:26:33<BR>> > asterisk1 ./ser[19374]: uri_db:mod_init: Unable to open
database<BR>> > connection Mar 16 13:26:33 asterisk1 ./ser[19374]:
init_mod(): Error<BR>> > while initializing module uri_db<BR>>
><BR>> > However, I can login to mysql db by user ser/heslo.<BR>>
> Where might be the problem ?<BR>> ><BR>> > Thanks,<BR>> >
ilker</FONT> </P>
<!--455254417B59-->
<br><br><a href="http://271570.sigclick.mailinfo.com/sigclick/06020704/01054B09/040C4A03/14561657.jpg"><img src="http://271570.signature1.mailinfo.com/confirm2.6/06020704/01054B09/040C4A03/14561657.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>