Hi,

About failover stuff i cant say nothing, i haven't used it ... .

>And any way to stay on MS SQL but get never Version as .94 ? I feel left behind and I do not think that xml is possible I am running Lumisoft Mail with over >90 GB Database (.mdf) and it will still grow in the next years to come.
There no benefit on mssql(if for some reasong messages must be stored to sql), in xml version messages are stored as separate "eml" files, so it can store a lot of GB. In xml version just users and settings stored to xml, also xml probably deprecated and replaced with sqllite.

About mssql version, i havent decided yet if it will be deprecated or code will be updated in version 0.97.
(You can email me directly ivar@lumisoft.ee, i can let you know desicion on first week of january)

Oh.

I forgot. Do you have some "update-script" from MSsql to XML/filesystem ?

I could set up a second LumiSoft-mailserver and give it a try how it compares to my running one.

But I DID set Primary keys and Indexes so SQL-DB is pretty fast even with 90 GB.

thanks

Mike

Hi Ivar,

I may have time to test .97 next week. But I found the Problem with Mirroring:

Having 'Failover Partner' in connectionstring REQIERES also 'Initial Catalog'. Witch is provided in api_initsttring.

But on api_init you check for existance of DataBase (to create if not there). And THERE is the problem.

ConnectionstringBuilder.ToString() removes DataBase Information! (that is what you want there to open con without DB)

and THAT con.Open() throws the error. Because no DBname there needed by Failover Partner in connectionstring.

Stupid, isnt it ?

Since I know my DBs are there I just commented that check out and LumisoftMailserver runs perfect with MS sql Database Mirroring.

wonderful.

Now I need to recode my web-application to use the newer MIME Implementation. I used some examples 2 years ago and have still warnings (deprecated ...) running fine with .94 but I want to test .96 and I guess I should do that anyways.

While searching thru your code to find the solution I stumbled over your Net folder.

2 years ago I just needded a simple to handle mailserver for our ~40 mailadresses, beeing able to manage accounts thru my own web-application. Sampling code from examples and Mailserver Manager I was able to do that, imported the old stuff and - well - since then every thing works fine. So I did never looked closer at that NET library.

Now I did. WOW.

You are a hell of a programmer. What an amount of work. AND well structured (#regions, interfaceces etc.).

I am really, really impressed.

and I started programming at a time where COBOL was state of the art ....

thank you again for sharingyor code.

Can I offer you some 'compensation' ? Maybe translating some of your wtext files to GERMAN ?

WOW.

Mike

I didn't fully finish it.
It worked perfectly in a Winforms app. Well, I might have introduced some bugs converting SQL code to nHibernate (more than 95 stored procedures), and I cannot say anything about performance, but overall, it seemed to work.

When I put it from the WinForms into the API, then it lost the initial config after loading the initial configuration for unknown reason.
It might have been related to nHibernate 3 being an alpha-release back then, or an issue with a static variable.
(
nHibernate loads information on the entire schema from XML files into it's configuration.
I put the object holding the configuration into a static variable, because I wanted to create static classes and methods for that I don't have to create an instance of a class always, because when nHibernate creates the factory (which it would have to do for each instance), it loads and reads many XML config files, which takes almost 10 to 15 seconds, so it should only be done once at startup. For unknown reason that static object - or an object withing the object - becomes somehow NULL, while == NULL is false...

The other possibility is that the API calls init, then somehow disposes, and for further calls passes connection string + query to a new instance each, which would explain why my config-object is/was always NULL. Anyway, I need to somehow eliminate that static variable, because it probably isn't thread-safe.
)

I filed a bug report for nHibernate, which was ignored, claiming that there probably was something wrong with my XML files.
It got on my nerveres, I did some other things in-between, waiting for nHibernate to get out of Alpha.
Then, my laptop's hard-disk crashed. I had (and still have) a backup somewhere, just de-dusted it recently, to get the old version of the server that worked. Maybe I'll make a fresh attempt to finish this soon.

I also used nHibernate to create the database schema for MS-SQL, MySQL, PostGre, Oracle and Firebird - which worked like a charm.
The main problem there was getting Oracle to run on Ubuntu. The makefiles Oracle supplies with the installer were riddled with bugs, but RedHat/Oracle uses an older gcc version, which doesn't detect that...

I recently managed to get Sybase and MS-Access (v2003) to work on Linux, but there seems to be a few little bugs in the mono ODBC pinvoke calls (int32 used instead of int64 for 64-bit Linux systems), so these are next.