Update MySQL >5.5 centos asterisk crash

Asterisk Asterisk Support
1

Hi I use centos 6.7 and install mysql which comes with that. I would like to upgrade to a much later version of mysql so I can use later versions of other applications.

I can upgrade the mysql with no issue but it breaks asterisk.

Is there a trick to get asterisk to play with later version of mysql?

Thanks

2

If I build from source does this problem go away?

Thanks

3

You haven’t given us nearly enough info to help you.

How exactly does it “break” asterisk? What do you see in /var/log/asterisk/full when you run /etc/init.d/asterisk start?

In the working system, is there an existing “asterisk” user in MySQL? Is there an asterisk or asteriskcdrdb database in the existing MySQL? Is there a password configured for MySQL user asterisk in /etc/asterisk/manager.conf?

4

Yes it’s a bit thin on detail but my first question is should I be able to upgrade the stock centos 6.7 mysql 5.01 with the mysql 5.5 community RPM and expect asterisk to play nice with it?

My experience is asterisk fails start.

I’m using odbc to connect CDR, extensions and lookups in dialplan.

If it should work I’ll spin up a test server and start gathering some error messages but I thought I would ask the question first to see if this should work at all.

Thanks

5

Ahh OK I ran up a test server and all I needed to do is update odbcinst.ini with a new location of the driver and reload asterisk

Thanks