I tried ser_mysql.sh create with password heslo but it keeps saying Access
denied for user root@localhost. I am really confused. Please help!
Onyx
> Wildguess, you have'nt made your mysql database... ser_mysql.sh :)
>
> - _Atle
>
> * onyeka d ezenwoye <oezen001(a)cs.fiu.edu> [040403 07:22]:
>> Hi, i tried to create an aliase and i got an error message:
>>
>> 400 Table 'aliases' not found in memory...
>>
>> what do i do now? Thanks.
>>
>> regards,
>>
>> Onyeka
>>
>>
>>
>> _______________________________________________
>> Serusers mailing list
>> serusers(a)lists.iptel.org
>> http://lists.iptel.org/mailman/listinfo/serusers
Hello Everyone.
I am trying to configure my SER with freeradius and i followed the document which is available at iptel.org.doc and everything works fine. Now i want to port freeradius to mysql and i have made changces according the tips provided at http://www.frontios.com/freeradius.html , after that freeradius has stated the problems it is working fine with radtest but it is giving problem when i try to run radclient with digest option. here i am giving the radius dump
I have given the following entry in radroupcheck table.
dynamic Auth-Type := Digest
table raddcheck values:
jeeth Password == jeeth
I dont know where i am doing mistake.
Hope some one might have come across this, Please send some tips on configuring SER , freeradius with mysql support.
Thanks in advance
----------------------
rad_recv: Access-Request packet from host 127.0.0.1:32903, id=78, length=141
User-Name = "jeeth@localhost"
Digest-Response = "631d6d73147add2f9e437f59bbc3aeb7"
Digest-Attributes = "\001\013testrealm"
Digest-Attributes = "\002\007jeeth"
Digest-Attributes = "\003\010INVITE"
Digest-Attributes = "\004\025sip:jeeth@localhost"
Digest-Attributes = "\006\005MD5"
Digest-Attributes = "\n\006test"
modcall: entering group authorize for request 25
modcall[authorize]: module "preprocess" returns ok for request 25
modcall[authorize]: module "chap" returns noop for request 25
modcall[authorize]: module "mschap" returns noop for request 25
rlm_realm: Looking up realm "localhost" for User-Name = "jeeth@localhost"
rlm_realm: Found realm "DEFAULT"
rlm_realm: Adding Stripped-User-Name = "jeeth"
rlm_realm: Proxying request from user jeeth to realm DEFAULT
rlm_realm: Adding Realm = "DEFAULT"
rlm_realm: Authentication realm is LOCAL.
modcall[authorize]: module "suffix" returns noop for request 25
radius_xlat: 'jeeth'
rlm_sql (sql): sql_set_user escaped user --> 'jeeth'
radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'jeeth' ORDER BY id'
rlm_sql (sql): Reserving sql socket id: 4
radius_xlat: 'SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE usergroup.Username = 'jeeth' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id'
radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = 'jeeth' ORDER BY id'
radius_xlat: 'SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE usergroup.Username = 'jeeth' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id'
rlm_sql (sql): Released sql socket id: 4
modcall[authorize]: module "sql" returns ok for request 25
modcall: group authorize returns ok for request 25
auth: type Local
auth: No User-Password or CHAP-Password attribute in the request
auth: Failed to validate the user.
------
When I check the ser.cfg file, which is set up according Chapter 3.1 of
the Dan Austin SER Howto I got this error:
0(6666) loading module /usr/lib/ser/modules/mysql.so
0(6666) ERROR: load_module: could not open module
</usr/lib/ser/modules/mysql.so>: /usr/lib/ser/modules/mysq
so: cannot open shared object file: No such file or directory
0(6666) parse error (29,13-43): failed to load module
Sure enough the mysql.so module is not in /usr/lib/ser/modules/
I read through the mailing list and find a number of references to this
sort of problem but nothing that seems directly relevant. I have
installed mysql using apt-get install mysql-server mysql-client. Mysql
installed ok and I was also able to run ser_mysql.sh successfully. Two
users set up and also the ser database was set up successfully. I note
that the tables created were a bit different to that shown in the howto
ie 19 rows not 14 as shown. Didn't bother to check why there was a
difference though.
I have used the stable debian version of SER.
Best regards Martin Coggin
Information in this message is confidential and may be legally
privileged. It is intended solely for the person to whom it is
addressed. If you have received this email in error please delete it
immediately and also reply to me to let me know. Thank you for your
help.
Hello friends,
question is simple and straight: what would you suggest as isdn pri
telco gw for outside dialing from sip equipment ?
We are experimenting with asterisk, works fine but misses radius
accounting.
We tried to do accounting on ser side but this does not correctly handle calls
status, example:
a call is routed from ser to asterisk, and from asterisk to the pstn.
Invite and bye are recorded by ser in radius but if call is answered
or not it does not make any difference, just an invite and a bye are
logged.
I'm I missing something or maybe the only way to go is "gw
accounting" and "big money Cisco equipment" ?
Please help, if you can ! :)
--
Best regards,
Alessio mailto:afoc@interconnessioni.it
Tried that, ie put the "" around the 192.168.0.100 and get the same
response ie Error: bad config file (2 errors).
The report doesn't specify what the errors are Im afraid.
Re naming of server. I don't use DNS on my network just ip addresses.
Im providing access to the server to the outside world by using port
forwarding. So Im assuming that I can use the ip address instead of the
name in the config file. Is this acceptable to SER??
Best regards Martin Coggin
Information in this message is confidential and may be legally
privileged. It is intended solely for the person to whom it is
addressed. If you have received this email in error please delete it
immediately and also reply to me to let me know. Thank you for your
help.
-----Original Message-----
From: Atle Samuelsen [mailto:clona@cyberhouse.no]
Sent: 29 March 2004 09:12
To: Martin Coggin
Subject: Re: [Serusers] Quick start SER Too much shared memory
Hey Martin
* Martin Coggin <martin(a)mc2-consulting.co.uk> [040329 10:04]:
> Tks. Got through to point 6 of the section on adding my sql ser.
>
> I edited the ser.cfg file see the attached file. However I got 2
errors
> reported as per extract below and sorry I cant find them in the file.
>
> hattie:/etc/init.d# ser restart
> ERROR: bad config file (2 errors)
> hattie:/etc/init.d#
>
> Note that I don't have DNS server on my network so Im using my
internal
# Uncomment this if you want to use digest authentication
if (!www_authorize(192.168.0.100, "subscriber"))
{
www_challenge(192.168.0.100, "0");
break;
};
Im guessing without seeing the erros that you are hitting are that you
are missing some " in the block I pasted erly'er..
try to change it to !www_authorize("192.168.0.100",
and www_channenge("192.168.0.100", ..
tho. remeber that your domain must now be 192.168.0.100...
> ip address, I assume that hence the entry for the ip address is
> acceptable. My hosts file does include the host name. Is this ok.
Ill
> be doing a forward on my firewall from my ip address to my internal ip
> address of the server.
>
> Im a little concerned that I didn't do step 3 completely. Ie creation
> of MySQL tables. I used the /usr/sbin/ser_mysql.sh creation process.
I
> entered a blank password for root, I entered ser as the domain: I got
a
> creating database ... message, then got another "Enter password:"
> request, entered blank and then returned to the command line.
>
>
>
> You've been very patient with your help tks Martin
>
>
- Atle
> _______________________________________________
> Serusers mailing list
> serusers(a)lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
Jason Penton wrote:
>
>>>>>Yes - I have. BUT I was under the impression that the 180 RINGING
>>>>>response is not REQUIRED to have a to-tag i.e. to set up an
>>>>early dialog.
>>>>
>>>>>Is this understanding correct?
>>>>
>>>>indeed, to-tags serve the purpose if establishing a dialog.
>>>>180 does not establish any, only 183 does.
I disagree. The only difference between 180 and 183 is that 180
signifies that the callee is being alerted. Either may establish a
dialog, or not.
>>>So then to fix the problem I am having - I could
>>theoretically remove
>>>the to-tags from all incoming 180 RINGING responses before
>>forwarding
>>>them to the UAC and my problem should be solved.
You could also remove the call-id header too, but I wouldn't recommend
it. The to-tag can validly be there. You can start playing games to work
around bugs in devices you encounter, but that will be dangerous.
Paul
Hi All
Sorry about the last post - I have attached the call flow as an image this
time :-)
I have a question about the CORRECT operation of UA when making a call via a
forking proxy:
(see attached image for call flow)
Lets say UA1 calls 7000(a)sip.com and user 7000(a)sip.com is available at UA2
and UA3 i.e. the Proxy forks the request.
* UA1 is using the to-tag of the first 180 RINGING it received (frame 5) no
matter what the to-tag in the 200 OK is
* My question here is: who is in the wrong???? The proxy or UA1?
* Should the proxy change the to-tag of the ACK before forewarding it to
UA3???
Jason Penton
Rhodes University
Grahamstown
South Africa
Hi,
could someone please help harry out?
Thanks,
Uli.
On Friday 02 April 2004 15:18, gaillac harry wrote:
> Hello,
>
> I would prefer to use mysql DB instead of DBtext for sems isdngw plugin.
> Telephones numbers have to register to dbtext. How may I use mysql table
> location with usrloc module (if possible ??).
> which modparams ?
>
> Anybody could look at my ser.cfg
>
> Regards
> Harry
Hello,
As I understood I need to choice between mediaproxy or nathelper to deal
with NATed sip clients. Who is better, mediaproxy or nathelper ?
Thanks in advance,
Carlo Pires