[Freeswitch-users] SQLExecute catches not all errors

[Helmut Kuper]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hello,


today I moved the voicemail database from sqlite to mysql via odbc. FS
started up and connected successfully to the empty database.

Normally voicemail adds the neccessary database tables automaticly
during startup. In this case I forgot to add permissions for creating,
dropping and altering tables to the database user in mysql. So no SM
table was createt in database. Unfortunately FS can not detect this. FS
thinks everything is ok.


After adding the permissions one table was created but the
voicemail_prefs wasn't. This was, because I extented the create
statement for this table - and the statement was wrong, so mysql
couldn't execute it. This case wasn't detected by FS as well and FS
resp. voicemail modul thought everything is fine

Is there a way to detect those errors, because bug hunting can be last
quite long without error messages especially when you have no way to
access mysql.log to see the sql statements from FS.

regards
helmut
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (MingW32)

iEYEARECAAYFAklvFuYACgkQ4tZeNddg3dwT5ACfd/ArMsLfsLrnc5peY1qxaDWu
kbsAn00gvNJjXwtFYIX41lbbgGWF+m1P
=GO2m
-----END PGP SIGNATURE-----