# Queue Log dump directally into mysql db

**URL:** <https://community.asterisk.org/t/queue-log-dump-directally-into-mysql-db/27575>\
**Category:** Asterisk General\
**Created:** [June 17, 2009, 8:57am UTC](https://community.asterisk.org/t/queue-log-dump-directally-into-mysql-db/27575 "2009-06-17T08:57:14Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![zaib\_kiani](https://sea1.discourse-cdn.com/asterisk/user_avatar/community.asterisk.org/zaib_kiani/32/9558_2.png) [@zaib\_kiani](https://community.asterisk.org/u/zaib_kiani)\
**Post date:** [June 17, 2009, 8:57am UTC](https://community.asterisk.org/t/queue-log-dump-directally-into-mysql-db/27575/1 "2009-06-17T08:57:14Z")

</div>

Hi all,

i want to dump queue log directally dump into mysql table for asterisk-1.4.25.1… As i have patched for asterisk-1.4.21 but still it is not working. Error are listed below  
asterisk.o astmm.o astobj2.o audiohook.o autoservice.o callerid.o cdr.o channel.o chanvars.o cli.o config.o cryptostub.o db.o devicestate.o dial.o dns.o dnsmgr.o dsp.o enum.o file.o fixedjitterbuf.o frame.o fskmodem.o global\_datastores.o http.o image.o indications.o io.o jitterbuf.o loader.o logger.o manager.o md5.o netsock.o pbx.o plc.o privacy.o rtp.o say.o sched.o sha1.o slinfactory.o srv.o stdtime/localtime.o strcompat.o tdd.o term.o threadstorage.o translate.o udptl.o ulaw.o utils.o editline/libedit.a db1-ast/libdb1.a -\> asterisk

logger.o: In function `write\_mysql\_logger’:

logger.c:(.text+0x29d): undefined reference to `mysql\_real\_query’

logger.c:(.text+0x2b1): undefined reference to `mysql\_error’

logger.o: In function `init\_mysql\_logger’:

logger.c:(.text+0x1cd2): undefined reference to `mysql\_real\_connect’

collect2: ld returned 1 exit status

make[1]: \*\*\* [asterisk] Error 1

make[1]: Leaving directory `/usr/src/Asterisk-1.4.21.2/asterisk-1.4.21.2/main’

* * *

i also included the correct path in logger.c but unable to resolve errors, is anybody here can help me out… do write in simple step by step thanks

Regards,

Jehanzaib younis
