MediaSmartServer.net
http://www.mediasmartserver.net/forums/

MySql Installer for WHS
http://www.mediasmartserver.net/forums/viewtopic.php?f=10&t=5374
Page 3 of 10

Author:  infodrive [ Sat Sep 26, 2009 6:36 am ]
Post subject:  Re: MySql Installer for WHS

Quote:
What happens if you try "C:\Program Files\mysql\bin\mysql.exe" -h localhost -u root -p


It asking to enter a password...

"btw, to get in the MySQL Administratrive Console directly i added a root password to get in. Could this be somehow related to this?"

Author:  Cajunle [ Sun Sep 27, 2009 10:24 am ]
Post subject:  Re: MySql Installer for WHS

I install the MySQL without any problems. When I Open the phpMYADMIN I notice on the bottom of the page the 2 items below.

1. The additional features for working with linked tables have been deactivated. To find out why click here.

2. Your PHP MySQL library version 5.0.51a differs from your MySQL server version 5.1.36. This may cause unpredictable behavior.

I am basicly a begginer at this.

I am using a EX470 Home Server

Author:  Cougar [ Sun Sep 27, 2009 11:10 am ]
Post subject:  Re: MySql Installer for WHS

infodrive wrote:

It asking to enter a password...

"btw, to get in the MySQL Administratrive Console directly i added a root password to get in. Could this be somehow related to this?"


Thats what I would be expecting, so you probably need to create a user for that app; which one was it?

Author:  Cougar [ Sun Sep 27, 2009 11:11 am ]
Post subject:  Re: MySql Installer for WHS

Cajunle wrote:
I install the MySQL without any problems. When I Open the phpMYADMIN I notice on the bottom of the page the 2 items below.

1. The additional features for working with linked tables have been deactivated. To find out why click here.

2. Your PHP MySQL library version 5.0.51a differs from your MySQL server version 5.1.36. This may cause unpredictable behavior.

I am basicly a begginer at this.

I am using a EX470 Home Server

I'm told it's nothing to worry about and just due to the fact the mysql library hasn't been updated in php yet. There is a newer version of php but I found it to be unstable when putting this together so stayed on 5.2

Author:  infodrive [ Sun Sep 27, 2009 12:24 pm ]
Post subject:  Re: MySql Installer for WHS

Quote:
Thats what I would be expecting, so you probably need to create a user for that app; which one was it?


The app is phpAutoVideo site @ https://secure.agaresmedia.com/v6/products/phpautovideo

below the install page

http://img213.imageshack.us/img213/2217 ... ovideo.jpg

Author:  category14 [ Mon Sep 28, 2009 7:43 am ]
Post subject:  Re: MySql Installer for WHS

I was wondering how should I perform upgrades when new versions of the plugin come out. Do I need to uninstall the old version and install the new one or do I just install the new plugin.

Author:  Cougar [ Mon Sep 28, 2009 8:37 am ]
Post subject:  Re: MySql Installer for WHS

For MySql there maybe an additional step to upgrade the database; then upgrade the Add-In, I'd expect to remove the Add-In then apply the new one. The Console doesnt give me the option to patch an installer.

Author:  Cougar [ Mon Sep 28, 2009 10:59 am ]
Post subject:  Re: MySql Installer for WHS

infodrive wrote:


I'd assume you need to create a user and a database for this app; the websites not very forthcoming on installation instructions but refer you to the manual.

Author:  snoerenberg [ Thu Oct 01, 2009 11:27 am ]
Post subject:  Re: MySql Installer for WHS

I also get the Error 1603

Here is the I think important part of the log:
Code:
Action ended 18:22:25: QtInstallMySql. Return value 1.
Action start 18:22:25: QtExecDeferred.
Action ended 18:22:25: QtExecDeferred. Return value 1.
Action start 18:22:25: InstallFinalize.
CAQuietExec:  Error 0x80070003: Command failed to execute.
CAQuietExec:  Error 0x80070003: CAQuietExec Failed
Action ended 18:24:02: InstallFinalize. Return value 3.
Action ended 18:24:13: INSTALL. Return value 3.


Hope you can help me solve the problem.

Regards
Stephan

Author:  Cougar [ Thu Oct 01, 2009 1:44 pm ]
Post subject:  Re: MySql Installer for WHS

Do you have MySql installed already? check your program files area or a MySql service?

I'm guessing further up the log you'll see a service already exists error.

Author:  DrewG5 [ Sat Oct 03, 2009 10:44 pm ]
Post subject:  Re: Can't login to phpmyadmin

UltimateUser wrote:
Hi, I'm having problems using the add-in. I can't login to the phpmyadmin, could you tell me what the default password is?

I tried using root as the username and a blank password, I also tried the same password as my WHS but it won't login. Is there any way I can change the password using a config file?

When I tried using root as the username and no password I got the following response :

Quote:
PHP has encountered an Access Violation at 02772BEB


@UltimateUser Topic merged, please use search feature so we do not open a thread that already exists

@Cougar I have the same issue I posted in this thread so it is searchable if UltimateUser tried it

:mss: COPC/Joe


I was getting the same error. The solution I found that worked was to install php first than MySql.

If you already have them installed I would suggest uninstalling both, than install php followed by MySql that resolved the issues for me.

Author:  Cougar [ Mon Oct 05, 2009 2:05 pm ]
Post subject:  Re: MySql Installer for WHS

Thanks guys.

I'm just building 0.06 that incorporates a check for an exisiting MySql install and also making PHP a pre-req so that if you have MySql installed, or PHP missing it fails.

Author:  Cougar [ Tue Oct 06, 2009 10:47 am ]
Post subject:  Re: MySql Installer for WHS

I've now uploaded 0.0.6 which can be downloaded from here

This installer now aborts if mysql is already on the system, and also if PHP is not installed.

Author:  Foxgame [ Wed Oct 07, 2009 10:29 am ]
Post subject:  Re: MySql Installer for WHS

Hi,

i try to install the MySql on my homeserver and i get the following error:

Code:
Created at 07.10.2009 18:14:09
***** Started at 07.10.2009 18:14:09 ***
***** Closed at 07.10.2009 18:14:09 ***
=== Logging started: 07.10.2009  18:14:10 ===
Action start 18:14:10: INSTALL.
Action start 18:14:10: AppSearch.
Action ended 18:14:11: AppSearch. Return value 1.
Action start 18:14:12: LaunchConditions.
Action ended 18:14:12: LaunchConditions. Return value 1.
Action start 18:14:12: ValidateProductID.
Action ended 18:14:12: ValidateProductID. Return value 1.
Action start 18:14:12: CostInitialize.
Action ended 18:14:12: CostInitialize. Return value 1.
Action start 18:14:12: FileCost.
Action ended 18:14:12: FileCost. Return value 1.
Action start 18:14:12: CostFinalize.
Action ended 18:14:12: CostFinalize. Return value 1.
Action start 18:14:12: InstallValidate.
Action ended 18:14:12: InstallValidate. Return value 1.
Action start 18:14:12: InstallInitialize.
Action ended 18:14:12: InstallInitialize. Return value 1.
Action start 18:14:12: ProcessComponents.
Action ended 18:14:12: ProcessComponents. Return value 1.
Action start 18:14:12: UnpublishFeatures.
Action ended 18:14:12: UnpublishFeatures. Return value 1.
Action start 18:14:12: SchedSecureObjectsRollback.
SchedSecureObjectsRollback:  Failed to store ACL rollback information with error 0x80070002 - continuing
Action ended 18:14:12: SchedSecureObjectsRollback. Return value 1.
Action start 18:14:12: StopServices.
Action ended 18:14:12: StopServices. Return value 1.
Action start 18:14:12: DeleteServices.
Action ended 18:14:12: DeleteServices. Return value 1.
Action start 18:14:12: RemoveRegistryValues.
Action ended 18:14:12: RemoveRegistryValues. Return value 1.
Action start 18:14:12: RemoveEnvironmentStrings.
Action ended 18:14:12: RemoveEnvironmentStrings. Return value 1.
Action start 18:14:12: RemoveFiles.
Action ended 18:14:12: RemoveFiles. Return value 0.
Action start 18:14:12: RemoveFolders.
Action ended 18:14:12: RemoveFolders. Return value 1.
Action start 18:14:12: CreateFolders.
Action ended 18:14:12: CreateFolders. Return value 1.
Action start 18:14:12: InstallFiles.
Action ended 18:14:12: InstallFiles. Return value 1.
Action start 18:14:12: WriteRegistryValues.
Action ended 18:14:12: WriteRegistryValues. Return value 1.
Action start 18:14:12: WriteEnvironmentStrings.
Action ended 18:14:12: WriteEnvironmentStrings. Return value 1.
Action start 18:14:12: InstallServices.
Action ended 18:14:12: InstallServices. Return value 1.
Action start 18:14:12: SchedSecureObjects.
Action start 18:14:12: ExecSecureObjects.
Action ended 18:14:12: ExecSecureObjects. Return value 1.
Action ended 18:14:12: SchedSecureObjects. Return value 1.
Action start 18:14:12: StartServices.
Action ended 18:14:12: StartServices. Return value 1.
Action start 18:14:12: RegisterUser.
Action ended 18:14:12: RegisterUser. Return value 1.
Action start 18:14:12: RegisterProduct.
Action ended 18:14:12: RegisterProduct. Return value 1.
Action start 18:14:12: PublishFeatures.
Action ended 18:14:12: PublishFeatures. Return value 1.
Action start 18:14:12: PublishProduct.
Action ended 18:14:12: PublishProduct. Return value 1.
Action start 18:14:12: QtInstallMySql.
Action ended 18:14:12: QtInstallMySql. Return value 1.
Action start 18:14:12: QtExecDeferred.
Action ended 18:14:12: QtExecDeferred. Return value 1.
Action start 18:14:12: InstallFinalize.
CAQuietExec:  Error 0x80070003: Command failed to execute.
CAQuietExec:  Error 0x80070003: CAQuietExec Failed
Action ended 18:14:30: InstallFinalize. Return value 3.
Action ended 18:14:32: INSTALL. Return value 3.
Property(S): PHPEXISTS = C:\Programme\php\php.exe
Property(S): pma = C:\inetpub\wwwroot\pma\
Property(S): contrib = C:\inetpub\wwwroot\pma\contrib\
Property(S): Fedora = C:\inetpub\wwwroot\pma\contrib\packaging\Fedora\
Property(S): js = C:\inetpub\wwwroot\pma\js\
Property(S): mooRainbow = C:\inetpub\wwwroot\pma\js\mooRainbow\
Property(S): images = C:\inetpub\wwwroot\pma\js\mooRainbow\images\
Property(S): lang = C:\inetpub\wwwroot\pma\lang\
Property(S): libraries = C:\inetpub\wwwroot\pma\libraries\
Property(S): auth = C:\inetpub\wwwroot\pma\libraries\auth\
Property(S): swekey = C:\inetpub\wwwroot\pma\libraries\auth\swekey\
Property(S): dbg = C:\inetpub\wwwroot\pma\libraries\dbg\
Property(S): dbi = C:\inetpub\wwwroot\pma\libraries\dbi\
Property(S): engines = C:\inetpub\wwwroot\pma\libraries\engines\
Property(S): export = C:\inetpub\wwwroot\pma\libraries\export\
Property(S): import = C:\inetpub\wwwroot\pma\libraries\import\
Property(S): tcpdf = C:\inetpub\wwwroot\pma\libraries\tcpdf\
Property(S): font = C:\inetpub\wwwroot\pma\libraries\tcpdf\font\
Property(S): transformations = C:\inetpub\wwwroot\pma\libraries\transformations\
Property(S): images_1 = C:\inetpub\wwwroot\pma\pmd\images\
Property(S): scripts_1 = C:\inetpub\wwwroot\pma\pmd\scripts\
Property(S): default = C:\inetpub\wwwroot\pma\pmd\styles\default\
Property(S): images_2 = C:\inetpub\wwwroot\pma\pmd\styles\default\images\
Property(S): scripts_2 = C:\inetpub\wwwroot\pma\scripts\
Property(S): setup = C:\inetpub\wwwroot\pma\setup\
Property(S): frames = C:\inetpub\wwwroot\pma\setup\frames\
Property(S): lib_4 = C:\inetpub\wwwroot\pma\setup\lib\
Property(S): darkblue_orange = C:\inetpub\wwwroot\pma\themes\darkblue_orange\
Property(S): css = C:\inetpub\wwwroot\pma\themes\darkblue_orange\css\
Property(S): img = C:\inetpub\wwwroot\pma\themes\darkblue_orange\img\
Property(S): original = C:\inetpub\wwwroot\pma\themes\original\
Property(S): css_1 = C:\inetpub\wwwroot\pma\themes\original\css\
Property(S): img_1 = C:\inetpub\wwwroot\pma\themes\original\img\
Property(S): mysql = C:\Programme\mysql\
Property(S): bin = C:\Programme\mysql\bin\
Property(S): data = C:\Programme\mysql\data\
Property(S): Docs = C:\Programme\mysql\Docs\
Property(S): debug = C:\Programme\mysql\Embedded\DLL\debug\
Property(S): release = C:\Programme\mysql\Embedded\DLL\release\
Property(S): debug_1 = C:\Programme\mysql\Embedded\static\debug\
Property(S): release_1 = C:\Programme\mysql\Embedded\static\release\
Property(S): include = C:\Programme\mysql\include\
Property(S): mysql_2 = C:\Programme\mysql\include\mysql\
Property(S): debug_2 = C:\Programme\mysql\lib\debug\
Property(S): opt = C:\Programme\mysql\lib\opt\
Property(S): share = C:\Programme\mysql\share\
Property(S): charsets = C:\Programme\mysql\share\charsets\
Property(S): czech = C:\Programme\mysql\share\czech\
Property(S): danish = C:\Programme\mysql\share\danish\
Property(S): dutch = C:\Programme\mysql\share\dutch\
Property(S): english = C:\Programme\mysql\share\english\
Property(S): estonian = C:\Programme\mysql\share\estonian\
Property(S): french = C:\Programme\mysql\share\french\
Property(S): german = C:\Programme\mysql\share\german\
Property(S): greek = C:\Programme\mysql\share\greek\
Property(S): hungarian = C:\Programme\mysql\share\hungarian\
Property(S): italian = C:\Programme\mysql\share\italian\
Property(S): japanese = C:\Programme\mysql\share\japanese\
Property(S): japanese_sjis = C:\Programme\mysql\share\japanese-sjis\
Property(S): korean = C:\Programme\mysql\share\korean\
Property(S): norwegian = C:\Programme\mysql\share\norwegian\
Property(S): norwegian_ny = C:\Programme\mysql\share\norwegian-ny\
Property(S): polish = C:\Programme\mysql\share\polish\
Property(S): portuguese = C:\Programme\mysql\share\portuguese\
Property(S): romanian = C:\Programme\mysql\share\romanian\
Property(S): russian = C:\Programme\mysql\share\russian\
Property(S): serbian = C:\Programme\mysql\share\serbian\
Property(S): slovak = C:\Programme\mysql\share\slovak\
Property(S): spanish = C:\Programme\mysql\share\spanish\
Property(S): swedish = C:\Programme\mysql\share\swedish\
Property(S): ukrainian = C:\Programme\mysql\share\ukrainian\
Property(S): ProgramMenuFolder = C:\Dokumente und Einstellungen\Administrator\Startmenü\Programme\
Property(S): mysql_1 = D:\MySQL Databases\mysql\
Property(S): TARGETDIR = D:\
Property(S): QtExecDeferred = "c:\windows\system32\Net.exe" start MySQL.WHS
Property(S): QtInstallMySql = "c:\Program Files\mysql\bin\mysqld.exe" --install MySQL.WHS --defaults-file="C:\Program Files\mysql\my-whs.ini"
Property(S): QtRemoveMySql = "c:\Program Files\mysql\bin\mysqld.exe" --remove MySQL.WHS
Property(S): ExecSecureObjects = C:\Programme\mysql\€CreateFolder€€Guests€268435456
Property(S): packaging = C:\inetpub\wwwroot\pma\contrib\packaging\
Property(S): pmd = C:\inetpub\wwwroot\pma\pmd\
Property(S): styles = C:\inetpub\wwwroot\pma\pmd\styles\
Property(S): lib = C:\Programme\mysql\lib\
Property(S): themes = C:\inetpub\wwwroot\pma\themes\
Property(S): wwwroot = C:\inetpub\wwwroot\
Property(S): IISROOT = C:\inetpub\
Property(S): ProgramFilesFolder = C:\Programme\
Property(S): DLL = C:\Programme\mysql\Embedded\DLL\
Property(S): Embedded = C:\Programme\mysql\Embedded\
Property(S): static = C:\Programme\mysql\Embedded\static\
Property(S): MySQL_Databases = D:\MySQL Databases\
Property(S): test = D:\MySQL Databases\test\
Property(S): SourceDir = C:\Dokumente und Einstellungen\All Users\Anwendungsdaten\Microsoft\Windows Home Server\
Property(S): VersionNT = 502
Property(S): Manufacturer = Nigel Wilks - www.mediasmartserver.net                                                                           Drashna Jael're - www.wegotserved.co.uk
Property(S): ProductCode = {2490A341-EACF-4279-B587-320CE62D02FD}
Property(S): ProductLanguage = 1033
Property(S): ProductName = MySql Installer for WHS
Property(S): ProductVersion = 0.0.6
Property(S): UpgradeCode = {60AD6671-BDB2-4CFB-9324-E52B916954C8}
Property(S): WHSLogo = 1
Property(S): PackageCode = {B77DE485-E1C0-4013-B810-3659BDA9CB73}
Property(S): ProductState = -1
Property(S): PackagecodeChanging = 1
Property(S): CURRENTDIRECTORY = C:\Programme\Windows Home Server
Property(S): CLIENTUILEVEL = 2
Property(S): CLIENTPROCESSID = 4280
Property(S): VersionDatabase = 200
Property(S): VersionMsi = 3.01
Property(S): WindowsBuild = 3790
Property(S): ServicePackLevel = 2
Property(S): ServicePackLevelMinor = 0
Property(S): MsiNTProductType = 3
Property(S): MsiNTSuiteSmallBusiness = 1
Property(S): MsiNTSuiteSmallBusinessRestricted = 1
Property(S): WindowsFolder = C:\WINDOWS\
Property(S): WindowsVolume = C:\
Property(S): SystemFolder = C:\WINDOWS\system32\
Property(S): System16Folder = C:\WINDOWS\system\
Property(S): RemoteAdminTS = 1
Property(S): TempFolder = C:\DOKUME~1\ADMINI~1\LOKALE~1\Temp\
Property(S): CommonFilesFolder = C:\Programme\Gemeinsame Dateien\
Property(S): AppDataFolder = C:\Dokumente und Einstellungen\Administrator\Anwendungsdaten\
Property(S): FavoritesFolder = C:\Dokumente und Einstellungen\Administrator\Favoriten\
Property(S): NetHoodFolder = C:\Dokumente und Einstellungen\Administrator\Netzwerkumgebung\
Property(S): PersonalFolder = C:\Dokumente und Einstellungen\Administrator\Eigene Dateien\
Property(S): PrintHoodFolder = C:\Dokumente und Einstellungen\Administrator\Druckumgebung\
Property(S): RecentFolder = C:\Dokumente und Einstellungen\Administrator\Recent\
Property(S): SendToFolder = C:\Dokumente und Einstellungen\Administrator\SendTo\
Property(S): TemplateFolder = C:\Dokumente und Einstellungen\Administrator\Vorlagen\
Property(S): CommonAppDataFolder = C:\Dokumente und Einstellungen\All Users\Anwendungsdaten\
Property(S): LocalAppDataFolder = C:\Dokumente und Einstellungen\Administrator\Lokale Einstellungen\Anwendungsdaten\
Property(S): MyPicturesFolder = C:\Dokumente und Einstellungen\Administrator\Eigene Dateien\Eigene Bilder\
Property(S): AdminToolsFolder = C:\Dokumente und Einstellungen\Administrator\Startmenü\Programme\Verwaltung\
Property(S): StartupFolder = C:\Dokumente und Einstellungen\Administrator\Startmenü\Programme\Autostart\
Property(S): StartMenuFolder = C:\Dokumente und Einstellungen\Administrator\Startmenü\
Property(S): DesktopFolder = C:\Dokumente und Einstellungen\Administrator\Desktop\
Property(S): FontsFolder = C:\WINDOWS\Fonts\
Property(S): GPTSupport = 1
Property(S): OLEAdvtSupport = 1
Property(S): ShellAdvtSupport = 1
Property(S): Intel = 6
Property(S): PhysicalMemory = 2037
Property(S): VirtualMemory = 3306
Property(S): AdminUser = 1
Property(S): LogonUser = Administrator
Property(S): UserSID = S-1-5-21-562299094-1902359283-1280303924-500
Property(S): UserLanguageID = 1031
Property(S): ComputerName = IT-LOUNGE
Property(S): SystemLanguageID = 1031
Property(S): ScreenX = 1024
Property(S): ScreenY = 768
Property(S): CaptionHeight = 19
Property(S): BorderTop = 1
Property(S): BorderSide = 1
Property(S): TextHeight = 16
Property(S): ColorBits = 32
Property(S): TTCSupport = 1
Property(S): Time = 18:14:32
Property(S): Date = 07.10.2009
Property(S): MsiNetAssemblySupport = 2.0.50727.3053
Property(S): MsiWin32AssemblySupport = 5.2.3790.3959
Property(S): RedirectedDllSupport = 2
Property(S): Privileged = 1
Property(S): USERNAME = Acer Aspire easyStore Home Server
Property(S): COMPANYNAME = Acer Incorporated
Property(S): DATABASE = C:\WINDOWS\Installer\2156d5.msi
Property(S): OriginalDatabase = C:\Dokumente und Einstellungen\All Users\Anwendungsdaten\Microsoft\Windows Home Server\MySql Installer for WHS.msi
Property(S): UILevel = 3
Property(S): ACTION = INSTALL
Property(S): ROOTDRIVE = D:\
Property(S): CostingComplete = 1
Property(S): OutOfDiskSpace = 0
Property(S): OutOfNoRbDiskSpace = 0
Property(S): PrimaryVolumeSpaceAvailable = 0
Property(S): PrimaryVolumeSpaceRequired = 0
Property(S): PrimaryVolumeSpaceRemaining = 0
Property(S): INSTALLLEVEL = 1
Property(S): SOURCEDIR = C:\Dokumente und Einstellungen\All Users\Anwendungsdaten\Microsoft\Windows Home Server\
Property(S): SourcedirProduct = {2490A341-EACF-4279-B587-320CE62D02FD}
Property(S): ProductToBeRegistered = 1
MSI (s) (F8:AC) [18:14:32:734]: Product: MySql Installer for WHS -- Installation failed.

=== Logging stopped: 07.10.2009  18:14:32 ===


I've installed PHP before Mysql

sorry for my bad englisch but I am from Germany

Author:  Cougar [ Wed Oct 07, 2009 11:52 am ]
Post subject:  Re: MySql Installer for WHS

Thankyou! That's exactly what i needed to get the low down on the german issue. I can see what it's doing, now off to see if i can fix it. Will let you know soon!

Page 3 of 10 All times are UTC - 7 hours [ DST ]
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/