Several years ago a challenge was given to technology instructor Rick A. Morelan. Take downsized workers with little or no experience with computers or technology and turn them into industry certified technology experts. The proven material from this venture is now available to you as the Joes 2 Pros series of books and videos. This new approach has vivid pictures on almost every page that shows what you should see on your computer screen as you work through the material, and downloadable multi-
Introducing Microsoft® SQL Server® 2012 explores the exciting enhancements and new capabilities engineered into SQL Server, ranging from improvements in operation to those in reporting and management. This book is for anyone who has an interest in SQL Server 2012 and wants to understand its capabilities, including database administrators, application developers, and technical decision makers.
List Price: $ 14.99
Price: [wpramaprice asin="073566515X"]
Oracle PL/SQL Language Pocket Reference, Second Edition
US $5.83 End Date: Sunday May-20-2012 9:17:44 PDT Buy It Now for only: US $5.83 Buy it now | Add to watch list
NEW - Microsoft SQL Server 2000 Programming by Example
US $10.14 End Date: Sunday May-20-2012 9:19:27 PDT Buy It Now for only: US $10.14 Buy it now | Add to watch list
This guide will give you instructions to install FreeRADIUS 2.1.8 on Ubuntu 10.04.2 LTS. Database for the FreeRADIUS in this guide is MySQL.
I/ Steps to install freeRADIUS on Ubuntu machine:
To install FreeRADIUS on Ubuntu and do some basic testings, you should follow the steps below:
1) Install lamp-server:
Actually, install MySQL and PHP are enough already. But to make sure that there are no dependencies errors later,
I prefer installing the whole package (lamp-server stands for Linux-Apache-MySQL-PHP server).
We install lamp-server using the command below:
sudo tasksel install lamp-server
(you will need to enter root password, which is “setupRADIUS” by default, to continue the installation)
2) Install freeradius package
sudo apt-get install freeradius
(Enter password when asked. When you are asked to continue, type ‘y’, then press Enter)
3) Install freeradius with ldap authentication
sudo apt-get install freeradius-ldap
4) Install freeradius to run with mysql
sudo apt-get install freeradius-mysql
5) After finishing the above installations, restart the FreeRADIUS service
sudo /etc/init.d/freeradius restart
6) Now, you can test the Radius Server using radtest, the command will be as below:
radius @ RadiusServer: -$ radtest radius setupRADIUS localhost 1812 testing123At this stage, you will get an error as follow:
radclient: socket: cannot initialize udpfromto: Function not implementedIf that’s the case, you can do the steps in part II.1/ to fix the error. The correct result should be as follow:
Sending Access-Request of id 177 to 127.0.0.1 port 1812 User-Name = “radius” User-Password = “setupRADIUS” NAS-IP-Address = 127.0.1.1 NAS-Port = 1812 rad_recv: Access-Accept_packet from host 127.0.0.1 port 1812, id=177, length=207) Now, we create the database for FreeRADIUS and an user account which will be used by FreeRADIUS to access into database. We run the following command:
Login MySQL Database
radius @ RadiusServer: ~$ mysql -u root -p Enter password:(Enter the password for root user)
Then you can create user, database, and set permissions as follow:
mysql> create user ‘radius’@'localhost’ identified by ‘setupRADIUS’; Query OK, 0 rows affected (0.00sec)
mysql> grant all privileges on radius. * to ‘radius’@'localhost’; Query OK, 1 row affected (0.00sec)
mysql> exit
Then, you copy the folder sql (comes along with this document in the folder “necessary setup files”) into the folder /etc/freeradius/
radius @ RadiusServer: ~$ sudo cp -r /home/radius/Desktop/sql /etc/freeradius/ Enter password:9) Import current schema of the database for FreeRADIUS into the “radius” database (the current Radius database schema for our project can be found in the file radius.sql, which comes along with this document in the folder “necessary setup files”)
radius @ RadiusServer: ~$ mysql -u radius -p radius < /home/radius/Desktop/radius.sql Enter password:10) Configure the file /etc/freeradius/sites-enabled/default so that the FreeRADIUS can startup, creates a default virtual host, and connects to MySQL Database. We follow the below steps:
Run the command:
sudo gedit /etc/freeradius/sites-enabled/default
In the file “default”, you check if the following settings are correct or not (the settings in the below pictures are correct settings):
In the authorize{} module
# Look in an SQL database. The schema of the database # is meant to mirror the “users” file. # # See “Authorization Queries” in sql.conf sql(uncomment the sql setting)
In the accounting{} module
# Log traffic to an SQL database # # See “Accounting queries” in sql.conf sqlIn the session{} module
session {
radutmp
#
# See “Simultaneous Use Checking Queries” in sql.conf
sql }
In the post-auth{} module
# After authenticating the user, do another SQL query. # # See “Authentication Logging Queries” in sql.conf sql11) Now, we configure the “radiusd.conf”. This file contains general settings for the Radius Server. We follow the below steps:
sudo gedit /etc/freeradius/radiusd.conf
Then, we check if the settings in the file radiusd.conf are correct or not.
The port for radius server to listen for authentication request is 1812
# Port on which to listen. # Allowed values are: # integer port number) # 0 means “use /etc/services for the proper port ” port = 1812Port for accounting is 1813
# This second “listen” section is for listening on the accounting # port, too # listen {
# Log the full User-Name attribute, as it was found in the request. # # allowed values: {no, yes} # stripped_names = yes
# Log authentication requests to the log file. # # allowed values: {no, yes} # auth = yes
# Log passwords with the authentication requests. # auth_badpass – logs password if it’s rejected # auth_goodpass – logs password if it’s correct # # allowed values: {no, yes} # auth_badpass = yes auth_goodpass = no
12) Now, we configure the file “sql.conf”. This file contains information about how to connect to database, database tables that are used by the FreeRADIUS server, etc
Run the command:
sudo gedit /etc/freeradius/sql.conf
Then, you should check the following settings:
sql {
#
# Set the database to one of:
# mysql, mssql, oracle, postgresql
#
database = “mysql”
#
# Which FreeRADIUS driver to use.
#
driver = “rlm_sql_$ {database}”
# Connection info:
server = “localhost”
# post =3306
login = “radius”
password = “setupRADIUS”
# Database table coniguration for everyt
radius_db = “radius” }
Check the setting that allow FreeRADIUS to read Radius Clients from database
# Set to ‘yes’ to read radius clients from the database (‘nas’ table) # Clients will ONLY be read on erver startup. For performance # and security reasons, finding clients via SQL queries CANNOT # be done “live” vhile the server is running. # readclients = yesIn the module modules{}
# Include another file that has the SQL-related configuration. # This is another file only because it tends to be big. # $ INCLUDE sql.conf13) Now, you clear all contents in the file /etc/freeradius/clients.conf because when radius server start running, it will read Radius Clients from both clients.conf and database (current settings). So, we clear the file clients.conf so that radius server only load Radius Clients from database (and to avoid conflicts like clients.conf and database contain the same Radius Client)
14) Now, the installation is finished. You can start using the Radius Server.
Please indicate the source reference, the original address: http://www.mydeveloperblog.com/radius/radius-servers-installation-guide-freeradius-ubuntu-mysql/
This guide will give you instructions to install FreeRADIUS 2.1.8 on Ubuntu 10.04.2 LTS. Database for the FreeRADIUS in this guide is MySQL.
Treasure Hunt party game with pirate theme suitable for all ages
Established, successful ebook, now open to affiliates. Easy To Organise Party Games For The Whole Family / Church / Corporate / Celebration Etc. Longtail Keywords, Cross Sell And Upsell. More Info At www.TreasureHuntBook.com/affiliatehelp.htm Treasure Hunt party game with pirate theme suitable for all ages
Find tips for creating efficient PL/SQL codeIf you know a bit about SQL, this book will make PL/SQL programming painless!The Oracle has spoken—you need to get up to speed on PL/SQL programming, right? We predict it’ll be a breeze with this book! You’ll find out about code structures, best practices, and code naming standards, how to use conditions and loops, where to place PL/SQL code in system projects, ways to manipulate data, and more.Discover how toWrite efficient, easy-to-maintain codeTes
Then, you copy the fo