← Back to team overview

maria-developers team mailing list archive

Re: Windows installer MWL#55 finished.


From: Peter Laursen [mailto:peter_laursen@xxxxxxxxxx] 
Sent: Dienstag, 1. Februar 2011 21:52
To: Vladislav Vaintroub
Cc: maria-developers@xxxxxxxxxxxxxxxxxxx
Subject: Re: [Maria-developers] Windows installer MWL#55 finished.
But I do not think "NT Authority\Network Service is localized" (it only is in Czech and other tonguebreaking languages and also not from Vista onwards as far as I remember. In Vista/2008/7 localization only applies to GUI and not command syntax) 
Well, I see what the bug was.. IT must be written NetworkService without space, not „Network Service“ as I did it (at least MSDN documents it so). I’ll check again the whole installer on German VM, and come back when I have something new.,
Also isn't 'NT AUTHORITY\SYSTEM' what user account MySQL normally uses?  But using \Network Service may be an improvement .. I remember we had some discussions. :-)
Yes, there were some discussion indeed in the bugdb.. http://bugs.mysql.com/bug.php?id=45216 (filed by you) for example  .System account is the most powerful account, it is the same as “root” on Unix.   That is, a bug in mysqld.exe (buffer overflow or something like that)  potentially compromises the whole machine.  How this could stay this way and pass all Sun and Oracle security reviews, is something I completely fail to understand. 
NetworkService has by far less privileges,  it does not need password and it can talk Kerberos (good property, as I think at some point Windows authentication will be in Maria as well).  SQLServer is using NetworkService to run, so  it can’t be wrong. 

If you need more information from my system just ask for a registry key dump or the output from some specific command.
Thanks for your offer, I think I will find that out, but will also come back if there are any questions. 
-- Peter
On Tue, Feb 1, 2011 at 20:30, Peter Laursen <peter_laursen@xxxxxxxxxx> wrote:
It is a Danish Windows (Home Premium 64 bit).
On Tue, Feb 1, 2011 at 20:07, Vladislav Vaintroub <wlad@xxxxxxxxxxxxxxxx> wrote:
Thanks Peter.
This might be helpful.  Is this a localized Windows? Asking because error you  get is ERROR_INVALID_SERVICE_ACCOUNT, and the service account is NT Authority\Network Service, which is “well-known” and always there. However I recall there was some PITA with localized names for standard users mentioned in source code in other open source projects (e.g. Wix).  I was never affected since I do not run localized Windows, though now I think I should give them a try from time to time;)
From: Peter Laursen [mailto:peter_laursen@xxxxxxxxxx] 
Sent: Dienstag, 1. Februar 2011 19:52

To: Vladislav Vaintroub
Cc: maria-developers@xxxxxxxxxxxxxxxxxxx
Subject: Re: [Maria-developers] Windows installer MWL#55 finished.
I am sorry .. no luck either this time.  I executed: "C:\m>msiexec /i mariadb-5.2.5-winx64.msi /l*v log.txt"
It looks like it is the service creation that fails .. excerpt 
CAQuietExec: Running bootstrap
CAQuietExec: Removing default user
CAQuietExec: Changing root password
CAQuietExec: Creating my.ini file
CAQuietExec: Registering service
CAQuietExec: FATAL ERROR: CreateService failed (1057)
CAQuietExec: Error 0x80070001: Command line returned an error.
CAQuietExec: Error 0x80070001: CAQuietExec Failed
CustomAction CreateDatabase returned actual error code 1603 (note this may not be 100% accurate if translation happened inside sandbox)
(full installation log attached).
I specified service name 'maria52' and no such service exist. Port specified is 3310 what is not in use. Selected default path for installation. I am administrator user of course and UAC is disabled.
-- Peter
On Tue, Feb 1, 2011 at 19:20, Vladislav Vaintroub <wlad@xxxxxxxxxxxxxxxx> wrote:
This could be a bug I found and fixed  yesterday evening.  It turns out I did an superfluous LocalFree() in mysql_install_db.exe. Interestingly, it has crashed rather seldom, it was the first time I have seen it.
Fixed here : http://bazaar.launchpad.net/~maria-captains/maria/5.2-windows-packaging-upgrade/revision/2929 . 
I updated msi installers after the fix  here  <http://cid-ff0c950417b4f8a4.office.live.com/browse.aspx/share> http://cid-ff0c950417b4f8a4.office.live.com/browse.aspx/share . I would appreciate if you could give new MSI’s  a try . Make sure to uninstall what you currently have prior to this experiment .
To trace what is happening in installation, a log file can be helpful. To get a log,  issue  
msiexec /i mariadb-5.2.5-win32.msi /l*v log.txt 
on the command line. This will launch setup and write  some interesting (and lots of uninteresting) info into log.txt. If an executable launched by MSI crashes  (I presumably it was the case here), the information would be sparse,  but at least one would know at what step installation did a rollback, which exe has crashed and what it has written to output prior to crash.
From: Peter Laursen [mailto:peter_laursen@xxxxxxxxxx] 
Sent: Dienstag, 1. Februar 2011 18:46
To: Vladislav Vaintroub
Cc: Kristian Nielsen; serg@xxxxxxxxxxxx; maria-developers@xxxxxxxxxxxxxxxxxxx

Subject: Re: [Maria-developers] Windows installer MWL#55 finished.
sorry .. it was 32 bit installer!
On Tue, Feb 1, 2011 at 18:43, Peter Laursen <peter_laursen@xxxxxxxxxx> wrote:
hmmm .. installer rolls back.  Why? 
64 bit build on 64 bit Win7 (UAC disabled). Default file path.  No conflicts with ports or service name specified.  After rollback there is no track left. 
-- Peter
On Tue, Feb 1, 2011 at 18:05, Vladislav Vaintroub <wlad@xxxxxxxxxxxxxxxx> wrote:

> -----Original Message-----
> From: Kristian Nielsen [mailto:knielsen@xxxxxxxxxxxxxxx]
> Sent: Dienstag, 1. Februar 2011 14:59
> To: Vladislav Vaintroub
> Cc: maria-developers@xxxxxxxxxxxxxxxxxxx; serg@xxxxxxxxxxxx; Michael Widenius
> Subject: Re: [Maria-developers] Windows installer MWL#55 finished.
> "Vladislav Vaintroub" <wlad@xxxxxxxxxxxxxxxx> writes:
> > Wizard is an MFC application. I'm sorry for that, but my Windows C/C++ GUI programming experience is not only rusty (prior to
> > WL last time I used it was more than  a decade ago), it is also restricted to MFC only. Being MFC application, it will require
> > least VS Professional to build.  There is no MFC in  free Visual Studio Express edition,  nor in free Windows SDK.  Build and
> > packaging process will handle missing MFC gracefully (build won't try to compile upgrade wizard,  package won't include it , and
> > installer won't  start it at the end of installation).
> What license are we distributing the wizard source code under?

> The reason I ask is that because of the above dependency, GPL may not be
> appropriate (and since it sounds like a new application, nor is it
> necessary). So we might consider another license, eg. BSD or if prefered some
> other more copy-left license. Or just GPL-with-MFC-exception.
> I don't really have an opinion myself for one license or the other, I just
> wanted to point out the issue to make sure it is considered by those that do
> care. Since it sounds like if we just use GPL, we may be releasing something
> that formally others cannot redistribute without violating the license. Which
> I think we should avoid, even if we're obviously not planning to sue anyone
> over it ...

Not sure I'm correct person  to start discussions over the of GPL, I think I'm not qualified.

I do know there is a plenty of established open source projects that use MFC, including GPLv2, such as different incarnations of
Tortoise (SVN,CVS, BZR, HG).

>From my point of view,  it is just a  system library. It came bundled with compiler, just like other library CRT which is non-GPL
that we use extensively for quite important functionality like strcpy() or say fopen().  Maybe this explanation will satisfy GPL
purists. I do not think CRT , MFC , ATL (libraries that come bundled with Visual Studio) have any written license, at least I have
never seen one. The source code is available, and installed together with Visual Studio.  If  one needs to redistribute one of this
libraries  as DLLs, there is Microsoft EULA that basically allows inclusion into any software . But we do not even do that, as we
link Visual Studio libraries (CRT, and also MFC now) statically, MySQL-ish way.

>  - Kristian.

Mailing list: https://launchpad.net/~maria-developers
Post to     : maria-developers@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~maria-developers
More help   : https://help.launchpad.net/ListHelp

Follow ups