Mysql doesn't work after upgrade pfsense from 2.6 to 2.7
-
Hmm mysqli.so doesn't exist in pfSense after installing Freeradius. But it also doesn't exist in 2.6.
Did you install anything custom there? -
Ah, it's in the php82-mysqli-8.2.6.pkg
Make sure you have that installed -
Actually, the source of my problem is related to the MySQL service, It can not be started.
Now I installed a new version and fresh pfSense on another physical machine, then installed the FreeRADIUS, everything was OK and FreeRADIUS started and worked normally, When I enabled the MySQL connection in FreeRADIUS, the FreeRADIUS service stopped because the MySQL service was not running.
and again I get this error when I try to start MySQL even on fresh pfSense.
ERROR 2002 (HY00): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
-
What exactly are you enabling in Freeradius that triggers this?
Did the mysql php pkg get installed correctly the second time you tested?
-
J jimp moved this topic from Problems Installing or Upgrading pfSense Software on
-
There is no "MySQL Service" on pfSense. Even with the PHP MySQL module installed it is only capable of acting as a client to contact a MySQL server on another host.
-
Yup, feels like there may have been something custom running...
-
MySQL service is available on pfSense 2.6 but in 2.7 It doesn't work correctly
-
I enabled SQL Support in FreeRADIUS to connect a MySQL authorization database
-
@vahidmoghadam
Running a MySQL server on pfSense ??
Read and sign off the Using Software from FreeBSD.
Be aware : totally not supported, so you have to support it by yourself, as you already did it ones : if you had a MySQL server running on your 2.6.0 then you installed that yourself.
So, do it again !? -
Are you able to show the MySQL service in 2.6? It doesn't exist AFAIK. This could also just be terminology confusion.
