Le blog de Jean David TECHER, un Réunionnais à Saint-Priest/Lyon

Wine 1.5.13 supports Raw input for keyboard and mouse. Unfortunately the full Raw Input patch hasn't ported completly in Wine code. Indeed this feature could be usefull for some games but for not all expected games. Below are the expected commands to patch the entire real patch.

# Reverse the patches
wget -q "http://source.winehq.org/git/wine.git/patch/c6fcc0255c3e7a655b157d1e68e5c80fe328bdf2" -O - | patch -p1 -R 
wget -q "http://source.winehq.org/git/wine.git/patch/faaf3d388eb6db8c2594cb11f76a2b1bce77edf3" -O - | patch -p1 -R 
wget -q "http://source.winehq.org/git/wine.git/patch/5befb959dd6f6e3567f0cd4fabd28b3b3b92966d" -O - | patch -p1 -R

# Apply the full patch
wget -q "http://baboonlinuxzone.free.fr/wineWOT/patchs/Patchs%20non%20fonctionnels/raw3.patch" -O - | patch -p1

Issue: For Streaming Replication if you have a a slave you are supposed to know that for a slave queries like "unlisten ...", "notify..." are disallowed on the slave-side not on the master-side. Npgsql used this type of query.

Fix: Remove these queries from the Npgsql sources. Below is the expected patch I use to do that. This patch could be improved but it works

Download

You can download it at http://www.davidgis.fr/download/Hot_Standby_SR.txt

--- Npgsql2.0.12.0.src/src/Npgsql/NpgsqlState.cs        2012-01-12 19:44:55.000000000 +0100
+++ Npgsql2.0.12.0.src_new/src/Npgsql/NpgsqlState.cs    2013-01-07 12:17:04.000000000 +0100
@@ -105,7 +105,7 @@ namespace Npgsql
             //Qlisten notifytest;notify notifytest;
             Stream stm = context.Stream;
             string uuidString = "uuid" + Guid.NewGuid().ToString("N");
-            PGUtil.WriteString("Qlisten " + uuidString + ";notify " + uuidString + ";", stm);
+            PGUtil.WriteString("Qlisten " + uuidString + ";", stm);
             Queue buffer = new Queue();
             byte[] convertBuffer = new byte[36];
             for (;;)
@@ -129,7 +129,7 @@ namespace Npgsql
                                     throw new EndOfStreamException();
                                 case 'Z':
                                     //context.Query(new NpgsqlCommand("UNLISTEN *", context));
-                                    using(NpgsqlCommand cmd = new NpgsqlCommand("UNLISTEN *", context))
+                                    using(NpgsqlCommand cmd = new NpgsqlCommand("-- UNLISTEN *", context))
                                     {
                                         context.Query(cmd);
                                     }
--- Npgsql2.0.12.0.src/src/Npgsql/NpgsqlConnector.cs    2012-01-12 19:44:55.000000000 +0100
+++ Npgsql2.0.12.0.src_new/src/Npgsql/NpgsqlConnector.cs        2013-01-07 12:17:44.000000000 +0100
@@ -401,7 +401,7 @@ namespace Npgsql
         internal void ReleaseRegisteredListen()
         {
             //Query(new NpgsqlCommand("unlisten *", this));
-            using(NpgsqlCommand cmd = new NpgsqlCommand("unlisten *", this))
+            using(NpgsqlCommand cmd = new NpgsqlCommand("-- unlisten *", this))
             {
                 Query(cmd);
             }

Apply the patch

# Download Npgsql 2.0.12 sources and uncompress on the fly
wget -q "http://mirrors.ircam.fr/pub/postgresql/projects/pgFoundry/npgsql/_npgsql2/Npgsql2.0.12/Npgsql2.0.12.0.src.tar.bz2" -O - | tar xjf -

# Go to Npgsql folder
cd Npgsql2.0.12.0.src/

# Download the patch and apply on the fly
wget -q http://www.davidgis.fr/download/Hot_Standby_SR.txt -O - | patch -p1