On Wed, 12 Mar 2003 15:02:38 -0500
"Matt Simpson" <[EMAIL PROTECTED]> wrote:
> What operating system and what version are you using. I ran into a
> similar problem with a fresh install of RedHat 8.0 and MySQL with
> glibc. Aparently when you connect to MySQL via anything but localhost
> it crashes, so in your/etc/my.cnf file make sure you set your thread
> stack set to 256K in your[mysqld] section. An example of mine is
> below.
>
> [mysqld]
> datadir=/var/lib/mysql
> innodb_data_file_path = ibdata1:10M:autoextend
> socket=/var/lib/mysql/mysql.sock
> server-id=1
> log-bin
> set-variable = thread_stack=256K
>
> This could be your problem...
Hi,
both the radius-server and the database server is Solaris 8. The client-side
mysql-version is 3.23.43 and the server side is 4.04:
db/mysql-max-4.0.4-beta-sun-solaris2.8-sparc/bin/mysqld
I can connect and read the database when using the mysql client on my radius-server
machine, but not when radiusd tries. Is it obvious that my problems will be solved if
I upgrade the client side?
radius-server> /local/db/mysql/3.23.43/bin/mysql -P15022 -h10.122.95.163 -uradius
-pradius radius
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 68700 to server version: 4.0.4-beta-max-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show tables;
+------------------+
| Tables_in_radius |
+------------------+
| radacct |
| radcheck |
| radgroupcheck |
| radgroupreply |
| radreply |
| usergroup |
+------------------+
6 rows in set (0.00 sec)
Nils
> ~matt
>
>
> ----- Original Message -----
> From: "Nils R�nhovde" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, March 12, 2003 2:53 PM
> Subject: MySQL connect problem
>
>
> Hi,
>
> Is this a rlm_my_sql problem, something else in the radius-server or a
> problem with my database:
>
> Module: Loaded SQL
> sql: driver = "rlm_sql_mysql"
> sql: server = "10.122.95.163"
> sql: port = "15022"
> sql: login = "radius"
> sql: password = "radius"
> sql: radius_db = "radius"
> sql: acct_table = "radacct"
> sql: acct_table2 = "radacct"
> sql: authcheck_table = "radcheck"
> sql: authreply_table = "radreply"
> sql: groupcheck_table = "radgroupcheck"
> sql: groupreply_table = "radgroupreply"
> sql: usergroup_table = "usergroup"
> sql: nas_table = "nas"
> sql: dict_table = "dictionary"
> sql: sqltrace = no
> sql: sqltracefile =
> "/local/net/experimental/radius-sql/var/log/radius/sqltrace.sql"
> sql: deletestalesessions = yes
> sql: num_sql_socks = 5
> sql: sql_user_name = "%{User-Name}"
> ...
> rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and
> linked
> rlm_sql (sql): Attempting to connect to
> [EMAIL PROTECTED]:15022/radius
> rlm_sql (sql): starting 0
> rlm_sql (sql): Attempting to connect rlm_sql_mysql #0
> rlm_sql_mysql: Starting connect to MySQL server for #0
> rlm_sql_mysql: Couldn't connect socket to MySQL server
> [EMAIL PROTECTED]:radius
> rlm_sql_mysql: Mysql error 'Can't connect to MySQL server on
> '10.122.95.163' (145)'
> rlm_sql (sql): Failed to connect DB handle #0
>
> I haven't done anything special in radiusd.conf and mysql.conf except
> enabling mysql and setting the host:port and connection parameters.
> The connection works fine when i use the mysql program itself.
>
> best regards
> Nils R�nhovde
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>
>
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.459 / Virus Database: 258 - Release Date: 2/25/2003
>
>
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>
--
best regards
Nils Ronhovde
TBS/Datacom/NMS
tel: +47 905 35 149, fax: +47 912 96 654
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
