#1  
Old 6th January 2010, 14:09
ahsan.altaf ahsan.altaf is offline
Junior Member
 
Join Date: Jan 2010
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default Daloradius problem

i used this thread to set up radius server and daloradius on my system
http://www.howtoforge.com/authentica...ith-daloradius

now the problem i m facing is , im getting this error when i tried to login through Daloradius.

Database connection error
Error Message: DB Error: connect failed
Debug: [nativecode=Can't connect to MySQL server on '127.0.0.1' (13)] ** mysql://root:@127.0.0.1/radius

Kindly help me in this regard..

Thanks alot
Reply With Quote
Sponsored Links
  #2  
Old 7th January 2010, 15:14
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

What's the output of
Code:
netstat -tap
and
Code:
ps aux | grep mysql
?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 8th January 2010, 11:32
ahsan.altaf ahsan.altaf is offline
Junior Member
 
Join Date: Jan 2010
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

The result of

netstat -tap

Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 *:48419 *:* LISTEN 998/rpc.statd
tcp 0 0 *:mysql *:* LISTEN 1858/mysqld
tcp 0 0 *:sunrpc *:* LISTEN 773/rpcbind
tcp 0 0 *:ssh *:* LISTEN 1048/sshd
tcp 0 0 localhost:ipp *:* LISTEN 807/cupsd
tcp 0 0 localhost:smtp *:* LISTEN 2413/sendmail: acce
tcp 0 0 *:sunrpc *:* LISTEN 773/rpcbind
tcp 0 0 *:http *:* LISTEN 2002/httpd
tcp 0 0 *:ssh *:* LISTEN 1048/sshd
tcp 0 0 localhost:ipp *:* LISTEN 807/cupsd

ps aux | grep mysql

root 1772 0.0 0.2 4964 1348 pts/0 S 16:43 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --pid-file=/var/run/mysqld/mysqld.pid --user=mysql
mysql 1858 0.0 3.3 127268 16964 pts/0 Sl 16:43 0:07 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock
root 2311 0.0 0.5 11884 3016 pts/0 T 18:40 0:00 mysql -u root -p
root 2518 0.0 0.1 4204 700 pts/0 S+ 21:19 0:00 grep mysql



Also i had to use 127.0.0.1/myradius to login to Daloradius. As localhost/myradius doesn't work for me. Also another thing i m running Fedora 12 through Vmware.

Last edited by ahsan.altaf; 8th January 2010 at 11:36.
Reply With Quote
  #4  
Old 9th January 2010, 11:09
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

Looks ok. Maybe you need to switch off SELinux? What's the output of
Code:
getenforce
?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #5  
Old 10th January 2010, 20:02
ahsan.altaf ahsan.altaf is offline
Junior Member
 
Join Date: Jan 2010
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

it says

enforcing

Now wat to do???

also if you could help me in Authenticating a wireless client through this setup.It would be very help full to me.
If you can post some steps same as like this link
Reply With Quote
  #6  
Old 11th January 2010, 10:54
ahsan.altaf ahsan.altaf is offline
Junior Member
 
Join Date: Jan 2010
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default more info

After turning off the selinux. when i tried yto log in to Daloradius i get this error..

Database connection error
Error Message: DB Error: connect failed
Debug: [nativecode=Access denied for user 'root'@'localhost' (using password: NO)] ** mysql://root:@127.0.0.1/radius

Kindly help me in this regard.
Also if you can post steps invloved in mac based wifi authentication through radius server,
Reply With Quote
  #7  
Old 11th January 2010, 14:13
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

Did you reboot the system after disabling SELinux?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #8  
Old 11th January 2010, 15:28
ahsan.altaf ahsan.altaf is offline
Junior Member
 
Join Date: Jan 2010
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

the problem solved...... the issue was that i had to change daloradius.conf.php file instead of daloradius.conf................. which was mantioned in the how to forge page........................

anywayz thanks alot for your help and concern that selinux thing helped alot................

also if you can post some link about my 2nd query than ill b very thank full to you....
Reply With Quote
  #9  
Old 18th January 2011, 23:53
luke240778 luke240778 is offline
Junior Member
 
Join Date: Jan 2011
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Help please!!

I also followed that tutorial and had problems until i read the last post about needing to edit the daloradius.conf.php file.

I have done this and am not able to login to Daloradius. My problem is this and i hope someone can help me.. i can test freeradius from the shell and see the accept message, so it should be working. in the tutorial we add the sqltest user, but when i go to users in Daloradius, there are no users, and when i try to add one, i get the following:

Database error
Error Message: DB Error: no such field
Debug info: INSERT INTO userinfo (id, username, firstname, lastname, email, department, company, workphone, homephone, mobilephone, address, city, state, zip, notes, changeuserinfo, creationdate, creationby, updatedate, updateby) VALUES (0, 'luke', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', '2011-01-18 20:32:35', 'administrator', NULL, NULL) [nativecode=1054 ** Unknown column 'address' in 'field list']

Database error
Error Message: DB Error: no such table
Debug info: SELECT * FROM userbillinfo WHERE username='luke' [nativecode=1146 ** Table 'radiusdb.userbillinfo' doesn't exist]

So, whats going on? Why would that tale be missing if i have followed that tutorial all the way through?

Second question: I want to use this server as an authentication for wifi users to have to login.. when a user connects to the network, and tries to browse, i want them to get a login page that they have to login to.. to have that, does Freeradius already do that (if yes where is that login page so i can edit it) and if not what other software do i have to use?

Looking forward to some responses from you guys, i am pretty green when it comes to linux and these softwares.. oh and i am using the following:

Centos 5.5
Freeradius2
Daloradius 0.9.8
Reply With Quote
  #10  
Old 26th February 2013, 15:05
Hannachi7 Hannachi7 is offline
Junior Member
 
Join Date: Feb 2013
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default Hallo

Quote:
Originally Posted by ahsan.altaf View Post
the problem solved...... the issue was that i had to change daloradius.conf.php file instead of daloradius.conf................. which was mantioned in the how to forge page........................

anywayz thanks alot for your help and concern that selinux thing helped alot................

also if you can post some link about my 2nd query than ill b very thank full to you....
Hallo What didi you change and how . Im newbi
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Strange email problem for one of my domains... any help appreciated paulrobert_a Installation/Configuration 5 9th August 2010 14:15
ISPConfig3 Mail Warn Errors reason8 General 3 25th November 2009 13:58
BIG Problem Postfix issue admins Installation/Configuration 11 13th November 2009 10:05
postfix mysql on fedora core5 igongora Installation/Configuration 7 17th April 2007 04:40
SMTP TLS Problem with Mail Client dschmid Installation/Configuration 1 9th December 2005 01:56


All times are GMT +2. The time now is 06:51.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.