No module load MYSQL

[chandimadharmarathne]

Hello. I got following error

[Feb 22 15:57:24] WARNING[47285][C-00000004]: pbx.c:2925 pbx_extension_helper: No application 'MYSQL' for extension (dmse_IVR, s, 7)
  == Spawn extension (dmse_IVR, s, 7) exited non-zero on 'PJSIP/registrar-00000003'
  == Spawn extension (dmse_IVR, s, 7) exited non-zero on 'PJSIP/registrar-00000003'
[Feb 22 15:57:24] ERROR[44140]: cdr_odbc.c:171 odbc_log: Unable to retrieve database handle.  CDR failed.

my Extensions.conf code is bellow

 same => n,MYSQL(Connect connid localhost dms password asterisk)
   same => n,MYSQL(Query resultid ${connid} INSERT INTO cdr (calldate, clid, src, dst, dcontext, channel, dstchannel, lastapp, lastdata, duration, billsec, disposition, amaflags, accountcode, uniqueid, userfield) VALUES (NOW(), '${CALLERID(name)}', '${CALLERID(num)}', 'chandima1', '', '${CHANNEL}', '${DSTCHANNEL}', 'Dial', '${EXTEN}', 0, 0, 'answered', 0, '', '${CONFID}', ''))
   same => n,MYSQL(Disconnect ${connid})

How fix this issue?

[chandimadharmarathne]

and No module show like MYSQL

dms*CLI> module show like mysql
Module                         Description                              Use Count  Status      Support Level
0 modules loaded
dms*CLI>

[Pooh]

On Thursday 22 February 2024 at 11:51:14, chandimadharmarathne via Asterisk
Community wrote:

and No module show like MYSQL

What are you expecting? What documentation have you found saying there is a
function, or a module, named MYSQL?

Antony.

–
BASIC is to computer languages what Roman numerals are to arithmetic.

                                               Please reply to the list;
                                                     please *don't* CC me.

[jcolp]

The app_mysql module was removed as of Asterisk 19[1]. Its recommended replacement was, and continues to be, func_odbc.

[1] Asterisk Module Deprecations - Asterisk Documentation

[chandimadharmarathne]

Which database most suitable for store the call details in asterisk?

[jcolp]

MySQL? Postgresql? Something else. It’s completely up to you, provided it has an ODBC connector.

[chandimadharmarathne]

Can you suggest any document or any method for setup Call details record and store database?

[Pooh]

On Thursday 22 February 2024 at 12:07:22, chandimadharmarathne via Asterisk
Community wrote:

Which database most suitable for store the call details in asterisk?

The most suitable database is the one you can best work with when you want to
use the data that Asterisk puts there.

Antony.

–
“Black holes are where God divided by zero.”

• Steven Wright

                                              Please reply to the list;
                                                    please *don't* CC me.