[Ask]StarUp Failed freeradius 2.2.0 @ Ubuntu 12.04

Diskusi tentang Ubuntu Server baik webserver, database server, samba server dan service lainnya serta jaringan menggunakan Sistem Operasi Ubuntu.
User avatar
q_p
Posts: 3109
Joined: 14 Oct 2012, 13:01
Contact:

[Ask]StarUp Failed freeradius 2.2.0 @ Ubuntu 12.04

Postby q_p » 09 Dec 2012, 06:50

Selesai install yFi CaptivePortal di Ubuntu 12.04 menggunakan freeradius 2.2.0, mesin saya reboot. Berikut adalah isi file radius.log
Tampilkan
1. Selesai install lalu saya reboot u/ pertama-kalinya. Everything is OK.

Code: Select all

: rlm_sql (sql): Attempting to connect rlm_sql_mysql #2
: rlm_sql_mysql: Starting connect to MySQL server for #2
: rlm_sql (sql): Connected new DB handle, #2
: rlm_sql (sql): Attempting to connect rlm_sql_mysql #3
: rlm_sql_mysql: Starting connect to MySQL server for #3
: rlm_sql (sql): Connected new DB handle, #3
: rlm_sql (sql): Attempting to connect rlm_sql_mysql #4
: rlm_sql_mysql: Starting connect to MySQL server for #4
: rlm_sql (sql): Connected new DB handle, #4
: Loaded virtual server <default>
: Ready to process requests.
2. Mesin saya matikan maupun saya reboot lagi, radiusd tidak jalan. Ini log-nya

Code: Select all

: Signalled to terminate
: Exiting normally.
: rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked
: rlm_sql (sql): Attempting to connect to yfi@localhost:/yfi
: rlm_sql (sql): Attempting to connect rlm_sql_mysql #0
: rlm_sql_mysql: Starting connect to MySQL server for #0
: Error: rlm_sql_mysql: Couldn't connect socket to MySQL server yfi@localhost:yfi
: Error: rlm_sql_mysql: Mysql error 'Can't connect to local MySQL server through socket '/var/run/mysqld.sock' (2)'
: Error: rlm_sql (sql): Failed to connect DB handle #0
: Error: rlm_sql (sql): There are no DB handles to use! skipped 5, tried to connect 0
: Error: Failed to load clients from SQL.
: rlm_sql (sql): Closing sqlsocket 4
: rlm_sql (sql): Closing sqlsocket 3
: rlm_sql (sql): Closing sqlsocket 2
: rlm_sql (sql): Closing sqlsocket 1
: rlm_sql (sql): Closing sqlsocket 0
: Error: /usr/local/etc/raddb/sql.conf[22]: Instantiation failed for module "sql"
: Error: /usr/local/etc/raddb/sites-enabled/default[370]: Failed to find "sql" in the "modules" section.
: Error: /usr/local/etc/raddb/sites-enabled/default[342]: Errors parsing accounting section.
: Error: Failed to load virtual server <default>
3. Saya executed '/etc/init.d/radiusd start' radiusd berjalan normal

Code: Select all

: rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked
: rlm_sql (sql): Attempting to connect to yfi@localhost:/yfi
: rlm_sql (sql): Attempting to connect rlm_sql_mysql #0
: rlm_sql_mysql: Starting connect to MySQL server for #0
: rlm_sql (sql): Connected new DB handle, #0
: rlm_sql (sql): Attempting to connect rlm_sql_mysql #1
: rlm_sql_mysql: Starting connect to MySQL server for #1
: rlm_sql (sql): Connected new DB handle, #1
: rlm_sql (sql): Attempting to connect rlm_sql_mysql #2
: rlm_sql_mysql: Starting connect to MySQL server for #2
: rlm_sql (sql): Connected new DB handle, #2
: rlm_sql (sql): Attempting to connect rlm_sql_mysql #3
: rlm_sql_mysql: Starting connect to MySQL server for #3
: rlm_sql (sql): Connected new DB handle, #3
: rlm_sql (sql): Attempting to connect rlm_sql_mysql #4
: rlm_sql_mysql: Starting connect to MySQL server for #4
: rlm_sql (sql): Connected new DB handle, #4
: Loaded virtual server <default>
: Ready to process requests.
: rlm_radutmp: NAS localhost restarted (Accounting-On packet seen)
Karena tidak bisa ikut start-up, saya masukkan '/etc/init.d/radiusd restart' di file rc.local baru bisa berjalan normal setelah mesin shutdown/reboot. Dengan konfigurasi yang sama di Ubuntu 10.04 + freeradius 2.1.8 tidak ada masalah seperti ini. Kenapa ya bisa terjadi "error" seperti pada nomer 2 dalam spoiler di atas ?
User avatar
yudiarbi
Posts: 627
Joined: 22 Mar 2011, 09:31
Location: Probolinggo, Jawa Timur
Contact:

Re: [Ask]StarUp Failed freeradius 2.2.0 @ Ubuntu 12.04

Postby yudiarbi » 09 Dec 2012, 20:43

ada beberapa kemungkinan bro, kl menurutq
1. cek port mysql
2. cek kapasitas partisi mysql, udah penuh ato gak
4. cek konfigurasi
User avatar
q_p
Posts: 3109
Joined: 14 Oct 2012, 13:01
Contact:

Re: [Ask]StarUp Failed freeradius 2.2.0 @ Ubuntu 12.04

Postby q_p » 09 Dec 2012, 20:53

Maslahnya tidak bisa start-up pakai init script, tapi radiusd bisa berjalan normal kalau '/etc/init.d/radiusd' dijalankan secara manual atau dimasukkan ke rc.local. YFI dan Ubuntu 12.04 kondisinya fresh-install menggunalan database lama. Bedanya dengan server lama (Ubuntu 10.04 + freeradius 2.1.8), sedangkan yang sekarang (Ubuntu 12.04) pakai freeradius 2.2. Semua konfigurasi sama. TQ Cak atas attensinya.
User avatar
sr_aja
Posts: 603
Joined: 10 Dec 2012, 11:21
Location: Jakarta

Re: [Ask]StarUp Failed freeradius 2.2.0 @ Ubuntu 12.04

Postby sr_aja » 10 Dec 2012, 11:29

[quote=PragolaPati]Selesai install yFi CaptivePortal di Ubuntu 12.04 menggunakan freeradius 2.2.0, mesin saya reboot. Berikut adalah isi file radius.log
Tampilkan
1. Selesai install lalu saya reboot u/ pertama-kalinya. Everything is OK.

Code: Select all

: rlm_sql (sql): Attempting to connect rlm_sql_mysql #2
: rlm_sql_mysql: Starting connect to MySQL server for #2
: rlm_sql (sql): Connected new DB handle, #2
: rlm_sql (sql): Attempting to connect rlm_sql_mysql #3
: rlm_sql_mysql: Starting connect to MySQL server for #3
: rlm_sql (sql): Connected new DB handle, #3
: rlm_sql (sql): Attempting to connect rlm_sql_mysql #4
: rlm_sql_mysql: Starting connect to MySQL server for #4
: rlm_sql (sql): Connected new DB handle, #4
: Loaded virtual server <default>
: Ready to process requests.
2. Mesin saya matikan maupun saya reboot lagi, radiusd tidak jalan. Ini log-nya

Code: Select all

: Signalled to terminate
: Exiting normally.
: rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked
: rlm_sql (sql): Attempting to connect to yfi@localhost:/yfi
: rlm_sql (sql): Attempting to connect rlm_sql_mysql #0
: rlm_sql_mysql: Starting connect to MySQL server for #0
: Error: rlm_sql_mysql: Couldn't connect socket to MySQL server yfi@localhost:yfi
: Error: rlm_sql_mysql: Mysql error 'Can't connect to local MySQL server through socket '/var/run/mysqld.sock' (2)'
: Error: rlm_sql (sql): Failed to connect DB handle #0
: Error: rlm_sql (sql): There are no DB handles to use! skipped 5, tried to connect 0
: Error: Failed to load clients from SQL.
: rlm_sql (sql): Closing sqlsocket 4
: rlm_sql (sql): Closing sqlsocket 3
: rlm_sql (sql): Closing sqlsocket 2
: rlm_sql (sql): Closing sqlsocket 1
: rlm_sql (sql): Closing sqlsocket 0
: Error: /usr/local/etc/raddb/sql.conf[22]: Instantiation failed for module "sql"
: Error: /usr/local/etc/raddb/sites-enabled/default[370]: Failed to find "sql" in the "modules" section.
: Error: /usr/local/etc/raddb/sites-enabled/default[342]: Errors parsing accounting section.
: Error: Failed to load virtual server <default>
3. Saya executed '/etc/init.d/radiusd start' radiusd berjalan normal

Code: Select all

: rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked
: rlm_sql (sql): Attempting to connect to yfi@localhost:/yfi
: rlm_sql (sql): Attempting to connect rlm_sql_mysql #0
: rlm_sql_mysql: Starting connect to MySQL server for #0
: rlm_sql (sql): Connected new DB handle, #0
: rlm_sql (sql): Attempting to connect rlm_sql_mysql #1
: rlm_sql_mysql: Starting connect to MySQL server for #1
: rlm_sql (sql): Connected new DB handle, #1
: rlm_sql (sql): Attempting to connect rlm_sql_mysql #2
: rlm_sql_mysql: Starting connect to MySQL server for #2
: rlm_sql (sql): Connected new DB handle, #2
: rlm_sql (sql): Attempting to connect rlm_sql_mysql #3
: rlm_sql_mysql: Starting connect to MySQL server for #3
: rlm_sql (sql): Connected new DB handle, #3
: rlm_sql (sql): Attempting to connect rlm_sql_mysql #4
: rlm_sql_mysql: Starting connect to MySQL server for #4
: rlm_sql (sql): Connected new DB handle, #4
: Loaded virtual server <default>
: Ready to process requests.
: rlm_radutmp: NAS localhost restarted (Accounting-On packet seen)
Karena tidak bisa ikut start-up, saya masukkan '/etc/init.d/radiusd restart' di file rc.local baru bisa berjalan normal setelah mesin shutdown/reboot. Dengan konfigurasi yang sama di Ubuntu 10.04 + freeradius 2.1.8 tidak ada masalah seperti ini. Kenapa ya bisa terjadi "error" seperti pada nomer 2 dalam spoiler di atas ?


bukan nya kalau pada saat mesin boot semua file yg ada di /etc/init.d/* akan otomatis di run??

tapi ngak tau juga seh.,,.. :D
bisa di postingkah file /etc/init.d/radiusd nya??

kalau mau simple seh coba pakai "rcconf"

semoga membantu ;)