Mysql doesn't work after upgrade pfsense from 2.6 to 2.7

SteveITS

@vahidmoghadam I was guessing. Uninstalling and reinstalling should be safe unless you've unchecked the option to "Keep Settings/Data." If that doesn't work then the brute force approach would be to install 2.7 from scratch and then restore your config file from backup.

As a small bonus reinstalling would use the ZFS file system.

stephenw10

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?

stephenw10

Ah, it's in the php82-mysqli-8.2.6.pkg
Make sure you have that installed

vahitsezer

@SteveITS @stephenw10

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)

stephenw10

What exactly are you enabling in Freeradius that triggers this?

Did the mysql php pkg get installed correctly the second time you tested?

jimp

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.

stephenw10

Yup, feels like there may have been something custom running...

vahitsezer

MySQL service is available on pfSense 2.6 but in 2.7 It doesn't work correctly

vahitsezer

@stephenw10

I enabled SQL Support in FreeRADIUS to connect a MySQL authorization database

Gertjan

@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 !?

I advise you to read several threads found here (just click) as they all have the same question : how to install mysql server on pfsense and nearly always the same answer : please don't.

stephenw10

Are you able to show the MySQL service in 2.6? It doesn't exist AFAIK. This could also just be terminology confusion.