Failed to find module "sql" Error
Hi all, I am newbie trying to make freeradius work with mysql and daloradius. First my system info: =================== OS: CentOS 5.3 mysql: 5.0.45 came with CentOS installation freeRadius: version freeradius2-2.1.6-2 (tried to install via yum but yum rejected telling that package is not signed so I went to rpm installation method, which worked fine daloRadius: version daloradius-0.9-8 I used the schema from daloradius : fr2-mysql-daloradius-and-freeradius.sql ==================== Tested freeradius in debug mode and went fine. Now there are few things which is not clear to me is: what conf files I need to modify? What I understand is if I am using user information in mysql database, I don't need to touch "users" right? This is what I did: changed the "sql.conf" to change the user, password and db settings plus made "readclients = yes" and modified the "sites-enabled/default" file and unchecked the sql sections in authorize, session and post-auth now when I try to start the radiusd -X, it won't start with following Error message ==================== /etc/raddb/sites-enabled/default[161]: Failed to find module "sql". /etc/raddb/sites-enabled/default[62]: Errors parsing authorize section. Errors initializing modules ==================== I check the modules directory and didn't find anything called "sql" At this point I don't know what I am doing. I am following a tutorial. So what is this sites-enabled thing is all about? plus What am I missing? Any suggestion highly appreciated ============================== Registered Linux User #460714 Currently Using Fedora 10, CentOS 5.3 ==============================
Deepak wrote:
Now there are few things which is not clear to me is: what conf files I need to modify?
The ones referencing SQL.
What I understand is if I am using user information in mysql database, I don't need to touch "users" right?
Yes.
This is what I did: changed the "sql.conf" to change the user, password and db settings plus made "readclients = yes"
You also need to edit radiusd.conf, and uncomment the line that includes sql.conf.
and modified the "sites-enabled/default" file and unchecked the sql sections in authorize, session and post-auth
That's good.
I check the modules directory and didn't find anything called "sql"
For historical reasons, the file is in raddb/sql.conf.
At this point I don't know what I am doing. I am following a tutorial. So what is this sites-enabled thing is all about?
See raddb/sites-available/README Alan DeKok.
Hi all,
I am newbie trying to make freeradius work with mysql and daloradius.
First my system info: =================== OS: CentOS 5.3 mysql: 5.0.45 came with CentOS installation freeRadius: version freeradius2-2.1.6-2 (tried to install via yum but yum rejected telling that package is not signed so I went to rpm installation method, which worked fine daloRadius: version daloradius-0.9-8
I used the schema from daloradius : fr2-mysql-daloradius-and-freeradius.sql ====================
Tested freeradius in debug mode and went fine.
Now there are few things which is not clear to me is: what conf files I need to modify? What I understand is if I am using user information in mysql database, I don't need to touch "users" right?
This is what I did: changed the "sql.conf" to change the user, password and db settings plus made "readclients = yes"
and modified the "sites-enabled/default" file and unchecked the sql sections in authorize, session and post-auth
now when I try to start the radiusd -X, it won't start with following Error message
==================== /etc/raddb/sites-enabled/default[161]: Failed to find module "sql". /etc/raddb/sites-enabled/default[62]: Errors parsing authorize section. Errors initializing modules ====================
I check the modules directory and didn't find anything called "sql"
At this point I don't know what I am doing. I am following a tutorial. So what is this sites-enabled thing is all about? plus
What am I missing?
Main distribution package doesn't have mysql support. Have you installed freeradius-mysql (or something like that)? Ivan Kalik Kalik Informatika ISP
Main distribution package doesn't have mysql support. Have you installed freeradius-mysql (or something like that)?
Ivan Kalik Kalik Informatika ISP
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Yes. I installed the rpm from http://people.redhat.com/jdennis/freeradius-rhel-centos freeradius freeradius-mysql freeradius-utils On Fri, Jul 10, 2009 at 4:15 PM, Alan DeKok<aland@deployingradius.com> wrote:
You also need to edit radiusd.conf, and uncomment the line that includes sql.conf.
I just did that and it works now. I have inserted also one user in the database and now testing with radtest. I am getting the error ======= (err=2)! (Shared secret is incorrect.) ======= what I need to do next (which file to look for and modify) to make this work? Sorry, its kind of confusing for first timers. :-) Thanks for the quick reply -- ============================== Registered Linux User #460714 Currently Using Fedora 10, CentOS 5.3 ==============================
You also need to edit radiusd.conf, and uncomment the line that includes sql.conf.
I just did that and it works now. I have inserted also one user in the database and now testing with radtest. I am getting the error
======= (err=2)! (Shared secret is incorrect.) =======
what I need to do next (which file to look for and modify) to make this work? Sorry, its kind of confusing for first timers. :-)
You need to use correct secret. Localhost is configured in proxy.conf by default. You can find/change the secret there. Ivan Kalik Kalik Informatika ISP
You need to use correct secret. Localhost is configured in proxy.conf by default. You can find/change the secret there.
Ivan Kalik Kalik Informatika ISP
I had a look at proxy.conf and the secrect is testing123. This is what I did. mysql> INSERT INTO radcheck (UserName, Attribute, Value) VALUES ('sqltest', 'Password', 'testpwd'); now tesing with radtest radtest sqltest testpwd localhost 1812 testing123 this still gives me the (err=2)! (Shared secret is incorrect.) error. what can be wrong?
PS. Is there an INSTALL file in that distribution?
As I mentioned earlier, I installed the rpm packages. Thanks for your time -- ============================== Registered Linux User #460714 Currently Using Fedora 10, CentOS 5.3 ==============================
On Fri, Jul 10, 2009 at 6:06 PM, Deepak<d88pak@gmail.com> wrote:
You need to use correct secret. Localhost is configured in proxy.conf by default. You can find/change the secret there.
Ivan Kalik Kalik Informatika ISP
I had a look at proxy.conf and the secrect is testing123.
This is what I did. mysql> INSERT INTO radcheck (UserName, Attribute, Value) VALUES ('sqltest', 'Password', 'testpwd');
now tesing with radtest
radtest sqltest testpwd localhost 1812 testing123
this still gives me the (err=2)! (Shared secret is incorrect.) error.
what can be wrong?
PS. Is there an INSTALL file in that distribution?
As I mentioned earlier, I installed the rpm packages.
Thanks for your time
Sorry my bad, I typed "tesing123" instead of "testing123" Thanks a lot for your valuable time. I will surely come back for more as I have yet to understand a lot about this stuff. Thanks again -- ============================== Registered Linux User #460714 Currently Using Fedora 10, CentOS 5.3 ==============================
Hi,
I had a look at proxy.conf and the secrect is testing123.
This is what I did. mysql> INSERT INTO radcheck (UserName, Attribute, Value) VALUES ('sqltest', 'Password', 'testpwd');
now tesing with radtest
radtest sqltest testpwd localhost 1812 testing123
this still gives me the (err=2)! (Shared secret is incorrect.) error.
in which case you are talking to the server directly as a client so you need to check your values in clients.conf alan
Main distribution package doesn't have mysql support. Have you installed freeradius-mysql (or something like that)?
Ivan Kalik Kalik Informatika ISP
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Yes. I installed the rpm from http://people.redhat.com/jdennis/freeradius-rhel-centos freeradius freeradius-mysql freeradius-utils
On Fri, Jul 10, 2009 at 4:15 PM, Alan DeKok<aland@deployingradius.com> wrote:
You also need to edit radiusd.conf, and uncomment the line that includes sql.conf.
I just did that and it works now. I have inserted also one user in the database and now testing with radtest. I am getting the error
======= (err=2)! (Shared secret is incorrect.) =======
what I need to do next (which file to look for and modify) to make this work? Sorry, its kind of confusing for first timers. :-)
Thanks for the quick reply
-- ============================== Registered Linux User #460714 Currently Using Fedora 10, CentOS 5.3 ============================== - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
PS. Is there an INSTALL file in that distribution? Ivan Kalik Kalik Informatika ISP
On 07/10/2009 05:57 AM, Ivan Kalik wrote:
PS. Is there an INSTALL file in that distribution?
No, there wasn't, in part because the INSTALL, README, etc. don't install as part of the doc install. However, I've fixed this now and those files will now be installed in the doc directory. -- John Dennis <jdennis@redhat.com> Looking to carve out IT costs? www.redhat.com/carveoutcosts/
No, there wasn't, in part because the INSTALL, README, etc. don't install as part of the doc install.
However, I've fixed this now and those files will now be installed in the doc directory.
-- John Dennis <jdennis@redhat.com>
Looking to carve out IT costs? www.redhat.com/carveoutcosts/ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Hi, I am wondering is there a way to install via yum directly. Somehow I am getting package not signed error and yum refuse to install. Thanks for your effort for these rpms. Regards -- ============================== Registered Linux User #460714 Currently Using Fedora 10, CentOS 5.3 ==============================
On 07/11/2009 03:37 AM, Deepak wrote:
No, there wasn't, in part because the INSTALL, README, etc. don't install as part of the doc install.
However, I've fixed this now and those files will now be installed in the doc directory.
-- John Dennis<jdennis@redhat.com>
Looking to carve out IT costs? www.redhat.com/carveoutcosts/ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Hi,
I am wondering is there a way to install via yum directly. Somehow I am getting package not signed error and yum refuse to install. Thanks for your effort for these rpms.
Regards
% man yum --nogpgcheck Run with gpg signature checking disabled. Configuration Option: gpgcheck I think that should do the trick. Because the packages I produced are not "official" they are not signed, nor to the best of my knowledge can I have them signed, so we'll have to live with defeating the signature check, at least for the time being. -- John Dennis <jdennis@redhat.com> Looking to carve out IT costs? www.redhat.com/carveoutcosts/
participants (5)
-
A.L.M.Buxey＠lboro.ac.uk -
Alan DeKok -
Deepak -
Ivan Kalik -
John Dennis