[Freeswitch-users] SQLExecute catches not all errors
helmut.kuper at ewetel.de
Thu Jan 15 02:58:46 PST 2009
-----BEGIN PGP SIGNED MESSAGE-----
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.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (MingW32)
-----END PGP SIGNATURE-----
More information about the FreeSWITCH-users