<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Queries to Windows MySQL servers from Linux Systems often fail unless
the lower_case_table_names parameter is set to 0 in the my.ini file in
the MySQL directory.<br>
Have a look at your my.ini file in the mysql directory, look under
[mysqld] and if the setting is missing, insert it as shown below, then
restart the MySQL service on Windows.<br>
<br>
Check
this setting first, because on Linux, MySQL preserves the case of
everything, the default on Windows is to convert tablenames to lower
case, which causes Queries to fail from Linux machines to Windows based
MySQL servers.<br>
<br>
Modify the my.ini file in the mysqld section to ensure case sensitivity
is adhered to on Windows as follows:<br>
<br>
<b><big><big><font face="Courier New, Courier, monospace">[mysqld]<br>
lower_case_table_names = 0<br>
.<br>
.<br>
.<br>
</font></big></big></b><br>
Hope this helps.<br>
<br>
<br>
Cory Robson wrote:
<blockquote cite="mid20070508023513.991371044A3@poseidon.gateway.net.au"
type="cite">
<pre wrap="">The problem is with your sql server not with freeradius, I'm using the exact
same sql statement on one of my machines.
MySQL runs fine with the original statement on a Linux derivative
Seems an incompatibility issue.
-----Original Message-----
From: <a class="moz-txt-link-abbreviated" href="mailto:freeradius-users-bounces+cory=cmi.net.au@lists.freeradius.org">freeradius-users-bounces+cory=cmi.net.au@lists.freeradius.org</a>
[<a class="moz-txt-link-freetext" href="mailto:freeradius-users-bounces+cory=cmi.net.au@lists.freeradius.org">mailto:freeradius-users-bounces+cory=cmi.net.au@lists.freeradius.org</a>] On
Behalf Of Hugh Messenger
Sent: Tuesday, 8 May 2007 10:17 AM
To: <a class="moz-txt-link-abbreviated" href="mailto:freeradius-users@lists.freeradius.org">freeradius-users@lists.freeradius.org</a>
Subject: MySQL and postauth_query
Dear freeradius Alpha Geeks,
Am I loosing my mind or is there a bug in the postauth_query in the MySQL
version of sql.conf?
I'm running freeradius 1.1.6 on RHEL4, and MySQL 5.0.37 on W2k. Don't ask.
Out-of-box, this postauth query ...
postauth_query = "INSERT into ${postauth_table} (id, user, pass,
reply, date) values ('', '%{User-Name}', '%{User-Password:-Chap-Password}',
'%{reply:Packet-Type}', NOW())"
.... fails with:
Incorrect integer value: '' for column 'id' at row 1
If I change this to remove the (auto incrementing) 'id' column ...
postauth_query = "INSERT into ${postauth_table} (user, pass, reply,
date) values ('%{User-Name}', '%{User-Password:-Chap-Password}',
'%{reply:Packet-Type}', NOW())"
.... it works.
-- hugh
-
List info/subscribe/unsubscribe? See
<a class="moz-txt-link-freetext" href="http://www.freeradius.org/list/users.html">http://www.freeradius.org/list/users.html</a>
__________ NOD32 2248 (20070507) Information __________
This message was checked by NOD32 antivirus system.
<a class="moz-txt-link-freetext" href="http://www.eset.com">http://www.eset.com</a>
-
List info/subscribe/unsubscribe? See <a class="moz-txt-link-freetext" href="http://www.freeradius.org/list/users.html">http://www.freeradius.org/list/users.html</a>
</pre>
</blockquote>
<br>
<br>
<div class="moz-signature">
<meta content="text/html; charset=ISO-8859-1" http-equiv="content-type">
<title>George Signature</title>
<span
style="font-weight: bold; font-family: helvetica,arial,sans-serif;"><span
style="font-style: italic;"></span>George Embrey</span><br
style="font-family: helvetica,arial,sans-serif;">
<small
style="font-family: helvetica,arial,sans-serif; font-weight: bold;">
CEO / Senior Systems Architect.</small><br
style="font-family: helvetica,arial,sans-serif;">
<small style="font-family: helvetica,arial,sans-serif;"><span
style="font-weight: bold;">
Vmail Internet Services Pty Ltd.</span></small><br
style="font-weight: bold; font-family: helvetica,arial,sans-serif;">
<small style="font-family: helvetica,arial,sans-serif;"><span
style="font-weight: bold;">318 Shoal Point Road</span><br
style="font-weight: bold;">
<span style="font-weight: bold;">Shoal Point QLD 4750</span><br
style="font-weight: bold;">
<span style="font-weight: bold;">Australia</span><br>
</small>
<small style="font-family: helvetica,arial,sans-serif;"><span
style="font-weight: bold;"></span></small><br
style="font-family: helvetica,arial,sans-serif;">
</div>
</body>
</html>