# MySQL

**URL:** <https://community.asterisk.org/t/mysql/5776>\
**Category:** Asterisk Support\
**Created:** [April 18, 2006, 2:09am UTC](https://community.asterisk.org/t/mysql/5776 "2006-04-18T02:09:42Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![wl33](https://avatars.discourse-cdn.com/v4/letter/w/da6949/32.png) [@wl33](https://community.asterisk.org/u/wl33)\
**Post date:** [April 18, 2006, 2:09am UTC](https://community.asterisk.org/t/mysql/5776/1 "2006-04-18T02:09:42Z")

</div>

Hi, i m new beginner of asterisk. I am going to use MySQL database to store the data. My asterisk version is 1.2.4.

Can you guys recommand me which version of MysQL and ODBC is suitable for my asterisk?

Thanks

---

<div class="post-metadata">

**Author:** ![wl33](https://avatars.discourse-cdn.com/v4/letter/w/da6949/32.png) [@wl33](https://community.asterisk.org/u/wl33)\
**Post date:** [April 18, 2006, 8:50am UTC](https://community.asterisk.org/t/mysql/5776/2 "2006-04-18T08:50:34Z")

</div>

Apr 18 16:20:27 WARNING[16282]: res\_odbc.c:238 odbc\_sanity\_check: Connection is down attempting to reconnect…  
Apr 18 16:20:27 WARNING[16282]: res\_odbc.c:497 odbc\_obj\_disconnect: res\_odbc: asterisk [asterisk] already disconnected  
Apr 18 16:20:27 NOTICE[16282]: res\_odbc.c:552 odbc\_obj\_connect: Connecting asterisk  
Apr 18 16:20:27 WARNING[16282]: res\_odbc.c:563 odbc\_obj\_connect: res\_odbc: Error SQLConnect=-1 errno=0 [unixODBC][Driver Manager]Data source name not found, and no default driver specified

this is the error i find when i ry to configure my odbc with mysql.

Plz help me and give some suggetionon it . Thanks

---

<div class="post-metadata">

**Author:** ![dswartz](https://avatars.discourse-cdn.com/v4/letter/d/45deac/32.png) [@dswartz](https://community.asterisk.org/u/dswartz)\
**Post date:** [April 18, 2006, 12:03pm UTC](https://community.asterisk.org/t/mysql/5776/3 "2006-04-18T12:03:37Z")

</div>

if you’re really that new to all this, just use asterisk@home which comes preconfigured with mysql.

---

<div class="post-metadata">

**Author:** ![yomomma](https://avatars.discourse-cdn.com/v4/letter/y/5e9695/32.png) [@yomomma](https://community.asterisk.org/u/yomomma)\
**Post date:** [April 18, 2006, 12:32pm UTC](https://community.asterisk.org/t/mysql/5776/4 "2006-04-18T12:32:09Z")

</div>

I do not think it’s not a problem if you use an older version of MySQL.

As long as it’s not MySQL from 3 years ago (even that old version _should_ suffice IMHO).

The only thing you need if you want to use Asterisk and MySQL, is to install asterisk-addons

Easy link: [http://ftp.digium.com/pub/asterisk/releases/asterisk-addons-1.2.2.tar.gz](http://ftp.digium.com/pub/asterisk/releases/asterisk-addons-1.2.2.tar.gz)

Have you installed asterisk-addons?

---

<div class="post-metadata">

**Author:** ![wl33](https://avatars.discourse-cdn.com/v4/letter/w/da6949/32.png) [@wl33](https://community.asterisk.org/u/wl33)\
**Post date:** [April 19, 2006, 4:00am UTC](https://community.asterisk.org/t/mysql/5776/5 "2006-04-19T04:00:48Z")

</div>

yup , i hv install the asterisk addon , but still cannt connect the odbc.