I’ve been administering Asterisk servers for many years and everyday I’m learning something new. As the size of the projects have gotten bigger, so have the demands of my customers. One common request is database integration. In the past I’ve used external AGI scripts to run database queries to return values to Asterisk. But more [...]
A few weeks back I covered connecting ODBC to MS-SQL, but today we are going to do the same thing with MySQL. The process is very similar. One might ask, why use ODBC driver in the first place? The reason is simple, there are many flavors of SQL and the ODBC driver allows one standard [...]
Last week at work(VoiceIP Solutions) I did some research for Asterisk PBX integration with Microsoft CRM. The customer likes open source Asterisk because of the cost savings, but they requires screen pop-ups, and click to dial from their Customer Relationship Management software. So while my manager worked on the TAPI middleware, I was charged with [...]
I’m not DBA, but most Linux system administrators need to at least know a little about SQL. Like adding users, making simple databases, changing passwords, backups, etc… This article describes backing up a database to a fresh machine. In my case I happen to be backing up my wordpress blog. However these steps can applied [...]