Tag Archives: mysql

The password hash doesn’t have the expected format

Today I thought I would grant permissions to use a mysql database.  I did the regular thing, but it didn’t work: mysql> grant all on *.* to ‘user’@’169.254.1.1’ identified by ‘somesecret’; ERROR 1827 (HY000): The password hash doesn’t have the … Continue reading

Posted in Stuff | Tagged , , , | 1 Comment

rlm_sql_mysql: MySQL error ‘Incorrect integer value: ” for column ‘XAscendDataRate’ at row 1

If you get this on your favourite radius server: rlm_sql_mysql: MySQL error ‘Incorrect integer value: ” for column ‘XAscendDataRate’ at row 1 it is probably because you have upgraded your FreeRadius with MySQL backend system from RHEL/CentOS 5 to RHEL/CentOS … Continue reading

Posted in Stuff | Tagged , , , , , , , , , | Comments Off on rlm_sql_mysql: MySQL error ‘Incorrect integer value: ” for column ‘XAscendDataRate’ at row 1

ERROR 1305 (42000): FUNCTION eval does not exist

MySQL cluster – a wonderful idea.  It’s really nice: you have a front end, and multiple redundant back ends, and all the data is loaded into memory, so things go very fast, even queries that inefficiently scan vast squabs of … Continue reading

Posted in Stuff | Tagged , , | Comments Off on ERROR 1305 (42000): FUNCTION eval does not exist

Floating to 0.999 on the MySQL cloud

This code: REPLACE INTO loadtable (`hostname`,`load`) VALUES (‘server1′,2.093); didn’t work. It worked in my testing from my local machine, but I ended up with this when I ran it from a real machine: load host 0.309 desktop1 0.201 desktop2 0.172 … Continue reading

Posted in Stuff | Tagged , , | Comments Off on Floating to 0.999 on the MySQL cloud