Skip to main content

MySQL Illegal mix of collations

MySQL Illegal mix of collations

MySQL Illegal mix of collations

A character encoding details how each symbol is represented in binary (and therefore stored in the computer). For example, the symbol é (U+00E9, latin small letter E with acute) is encoded as 0xc3a9 in UTF-8 (which MySQL calls utf8) and 0xe9 in Windows-1252 (which MySQL calls latin1). A character set is the alphabet of symbols […]

openSmpp configuration with Mysql

openSmpp configuration with Mysql

If you need to install openSMPP please have a look on “Install Kannel Addons” OpenSMpp is Kannel addon; used to allow smpp clients to connect to kannel gateway and send SMS over SMPP protocol. following are the steps for configuring openSMPP with mysql as storage of DLR. Create a Mysql Database if you don’t have […]

Install Kannel Addons; opensmpp and sqlb...

Install Kannel Addons; opensmpp and sqlbox

If you need to install kannel with mysql support please refer to this post “How to Install Kannel” Once you have installed the kannel with Mysql support, you can install additional addons of kannel which are opensmpp and sqlbox. Install openSMPP (you can remove the –with-kannel-dir, but some distributions do not automatically find the kannel […]

How to run large sql script

How to run large sql script

some times you have to run a large SQL script in SQL server and “Sql Server Management Studio” dies when you load the large file. To import / run the large script you need to use SQL Server command line tool sqlcmd there are many parameters for this command line toll use this for full list […]

CURL ERROR 7 Failed to connect to Permis...

CURL ERROR 7 Failed to connect to Permission denied

“CURL ERROR 7 Failed to connect to Permission denied” error is caused, when for any reason curl request is blocked by some firewall or similar thing. you will face this issue when ever the curl request is not with standard ports. for example if you do curl to some URL which is on port 1234, […]

Shrink SQL Server 2008

Shrink SQL Server 2008

Normally when a database in Microsoft Sql Server 2008 is created the recovery model is full and that causes huge disk space usage and with usage of database the log file increases in size. Some times you may need to clean the log file, so here you go.

Get SMSC Status

Get SMSC Status

kannel do not directly gives you status for any SMSC it is connected with. i have been asked many times by many that how can we get the status of a given SMSC. Many times one need to make some decision on current status of SMSC that weather or not one should this SMSC to sent Message. […]

How to install Kannel

How to install Kannel

Download Get sources using the following command where <project> is: gateway, sqlbox or opensmppbox. Once you have the kannel source, navigate to source directory which typically is [YOUR_DOWNLOAD_PATH]/trunk/ Here you can compile kannel wtih mysql support or without mysql. Install Kannel Without Mysql Support Install Kannel With Mysql Support Once you have installed kannel you can locate […]