FreeTDS errors after running perfectly fine for 30-60minutes.

Olaf siegson at gmail.com
Thu Dec 14 09:56:20 UTC 2023


Running Freeradius 3.2.3 (from freeradius rep)
installed with: sudo apt install freeradius freeradius-utils
freeradius-freetds

After running for 30-60 minutes this happens on all servers (3) (Debian
12-latetst)

Thu Dec 14 06:49:32 2023 : Error: rlm_sql_freetds: unable to send command
(ct_send())
Thu Dec 14 06:49:32 2023 : ERROR: (571)     ERROR: rlm_sql_freetds: Server
msg from "mydbserver": severity(5701), number(0), origin(1), layer(1),
procedure "none": Changed database context to 'mydb'.
Thu Dec 14 06:49:32 2023 : ERROR: (571)     ERROR: SQL query failed: server
error
Thu Dec 14 06:49:32 2023 : Auth: (571) Login incorrect (rlm_sql_freetds:
Server msg from "mydbserver": severity(5701), number(0), origin(1),
layer(1), procedure "none": Changed database context to 'mydblog'.):
[327700051207842] (from client 192.168.3.161/32 port 0 cli 327700051207842)
Thu Dec 14 06:49:32 2023 : Auth: (572) Login OK: [327700050547002] (from
client 192.168.3.161/32 port 0 cli 327700050547002)
Thu Dec 14 06:49:33 2023 : Auth: (573) Login OK: [327700050626183] (from
client 192.168.3.161/32 port 0 cli 327700050626183)
Thu Dec 14 06:49:33 2023 : Auth: (574) Login OK: [327700051319260] (from
client 192.168.3.161/32 port 0 cli 327700051319260)
Thu Dec 14 06:49:34 2023 : Auth: (575) Login OK: [327700051047968] (from
client 192.168.3.161/32 port 0 cli 327700051047968)
Thu Dec 14 06:49:35 2023 : Error: rlm_sql_freetds: unable to send command
(ct_send())
etc
etc


And start repeating like this forever. Most successful, some not.
Restarting freeradius solves it directly.
At that exact same moment my old centos server CAN connect with no issues
to that same db for years already.
I'm clueless whats going on here. But im almost sure it must be something
local.

Changing start servers did not help. Issue stays.

freetds.conf
# A typical Microsoft Azure SQL
[myserver]
        host = mydb.database.windows.net
        port = 1433
        tds version = 7.3
        database = mydb


Note that 7.4 does not connect but 7.3 or lower connects.

My Setup is a default as possible with 1 sql query that does accept for
unit or not.

freeradius-freetds seems to install:
freetds-common/stable,now 1.3.17+ds-2 all [installed,automatic]

Not sure what to do here to use latest from Freetds (1.4.1)
Any suggestions?

Thanks,
Olaf


More information about the Freeradius-Users mailing list