[Mono-bugs] [Bug 78597][Nor] Changed - SSL re-negotiation failure with Postgres

[bugzilla-daemon at bugzilla.ximian.com]

Please do not reply to this email- if you want to comment on the bug, go to the
URL shown below and enter your comments there.

Changed by fxjrlists at yahoo.com.br.

http://bugzilla.ximian.com/show_bug.cgi?id=78597

--- shadow/78597	2006-08-05 16:54:24.000000000 -0400
+++ shadow/78597.tmp.26854	2006-08-06 12:35:19.000000000 -0400
@@ -614,6 +614,134 @@
 Tomorrow, I'll add more data into my database and re-run the test.
 We'll see if this still works or not...
 
 ------- Additional Comments From mfarr at paradise.net.nz  2006-08-05 16:54 -------
 Sorry, I have just moved country (without my server) and am unable to
 test this fix.
+
+------- Additional Comments From fxjrlists at yahoo.com.br  2006-08-06 12:35 -------
+
+Hi Sebastien!
+
+I changed my test to the following, so we don't need to depend on
+database data:
+
+using System;
+using System.Data;
+using Npgsql;
+
+namespace npgsqltest
+{
+
+        // npgsql PostgreSQL driver TEST program
+        class NpgsqlTest
+        {
+
+                [STAThread]
+                static void Main(string[] args)
+                {
+                        // test connectivity to the postgresql server
+                        // given a small table output the information
+it contains
+                        NpgsqlEventLog.Level = LogLevel.Debug;
+                NpgsqlEventLog.LogName = "NpgsqlTests.LogFile";
+
+                                String connectionstring =
+"Server=localhost;User
+Id=npgsql_tests;Password=npgsql_tests;Database=npgsql_tests;ssl=yes";
+                                NpgsqlConnection conn = new
+NpgsqlConnection(connectionstring);
+                                conn.Open(); // shouldn't throw exceptions
+
+                        // implement testing here
+                        try
+                        {
+
+                                for(Int32 i = 0; i < 1000; i++)
+                                {
+
+                                        NpgsqlCommand createRow = new
+NpgsqlCommand("select 'This is a ssl renegotiation test.'", conn);
+                                       
+Console.WriteLine(createRow.ExecuteScalar());
+                                }
+
+                        }
+                        catch (Exception e)
+                        {
+                                Console.WriteLine("err");
+                                Console.WriteLine(e.Message);
+                        }
+                        finally
+                        {
+
+                                conn.Close();
+                                Console.WriteLine("Successful.");
+                        }
+
+
+                }
+        }
+}
+
+
+Also, I changed my Npgsql to add a better CWL with strange data. This
+is what I get now:
+
+ NpgsqlTest.exe
+CurrentMonoSecurity
+This is an ssl renegotiation test.
+This is an ssl renegotiation test.
+This is an ssl renegotiation test.
+This is an ssl renegotiation test.
+extra byte: 0
+extra byte: 0
+extra byte: 0
+extra byte: 0
+CurrentMonoSecurity
+This is an ssl renegotiation test.
+This is an ssl renegotiation test.
+This is an ssl renegotiation test.
+This is an ssl renegotiation test.
+This is an ssl renegotiation test.
+This is an ssl renegotiation test.
+This is an ssl renegotiation test.
+This is an ssl renegotiation test.
+This is an ssl renegotiation test.
+This is an ssl renegotiation test.
+This is an ssl renegotiation test.
+This is an ssl renegotiation test.
+This is an ssl renegotiation test.
+This is an ssl renegotiation test.
+This is an ssl renegotiation test.
+extra byte: 0
+extra byte: 0
+extra byte: 0
+extra byte: 0
+CurrentMonoSecurity
+This is an ssl renegotiation test.
+This is an ssl renegotiation test.
+This is an ssl renegotiation test.
+This is an ssl renegotiation test.
+This is an ssl renegotiation test.
+This is an ssl renegotiation test.
+This is an ssl renegotiation test.
+This is an ssl renegotiation test.
+This is an ssl renegotiation test.
+This is an ssl renegotiation test.
+This is an ssl renegotiation test.
+This is an ssl renegotiation test.
+This is an ssl renegotiation test.
+This is an ssl renegotiation test.
+This is an ssl renegotiation test.
+extra byte: 0
+extra byte: 0
+extra byte: 0
+extra byte: 0
+
+
+and so on...
+
+I don't know why Npgsql is getting these 4 extra 0 bytes :( 
+
+I'm recompiling postgresql 8.0.1 with ssl to give it a try too.
+