It is currently Sun Sep 23, 2018 10:35 am

All times are UTC - 7 hours [ DST ]

Recent News:



Post new topic Reply to topic  [ 137 posts ]  Go to page Previous  1 ... 3, 4, 5, 6, 7, 8, 9, 10  Next
Author Message
PostPosted: Tue Jan 12, 2010 11:51 am 
Offline
Newbie
Newbie

Joined: Tue Jan 12, 2010 11:09 am
Posts: 3
Thanks: 0
Thanked: 0 time in 0 post
Like a few others I tried installing v0.0.8 of the MySQL Installer and the installer fails with a 1603 error. I've included the WHS log file below.

It apparently thinks it's installed all ok & then fails to start MySQL. On closer inspection I find that the mysql folder hasn't been created in c:\program files & therefore there is no bin\mysql.exe file to start. The service is installed ok but it fails to start with error 2: The system cannot find the file specified. I tried uninstalling everything & creating the mysql\bin folder manually before reinstalling but no mysql.exe file gets put into the folder. First time round the folder D:\MySQL Databases\ was created ok but on re-install I see that hasn't been created either...

This is almost a fresh install of WHS with no other add-ins (except for your php install - which worked fine).

Really like to get it going.

Log File:
Code:
Created at 12/01/2010 16:22:09
***** Started at 12/01/2010 16:22:09 ***
***** Closed at 12/01/2010 16:22:09 ***
=== Logging started: 12/01/2010  16:22:13 ===
Action start 16:22:13: INSTALL.
Action start 16:22:13: AppSearch.
Action ended 16:22:47: AppSearch. Return value 1.
Action start 16:22:47: LaunchConditions.
Action ended 16:22:47: LaunchConditions. Return value 1.
Action start 16:22:47: ValidateProductID.
Action ended 16:22:47: ValidateProductID. Return value 1.
Action start 16:22:47: CostInitialize.
Action ended 16:22:47: CostInitialize. Return value 1.
Action start 16:22:47: FileCost.
Action ended 16:22:47: FileCost. Return value 1.
Action start 16:22:47: CostFinalize.
Action ended 16:22:47: CostFinalize. Return value 1.
Action start 16:22:47: InstallValidate.
Action ended 16:22:47: InstallValidate. Return value 1.
Action start 16:22:47: InstallInitialize.
Action ended 16:22:48: InstallInitialize. Return value 1.
Action start 16:22:48: ProcessComponents.
Action ended 16:22:48: ProcessComponents. Return value 1.
Action start 16:22:49: UnpublishFeatures.
Action ended 16:22:49: UnpublishFeatures. Return value 1.
Action start 16:22:49: SchedSecureObjectsRollback.
Action start 16:22:49: ExecSecureObjectsRollback.
Action ended 16:22:49: ExecSecureObjectsRollback. Return value 1.
Action ended 16:22:49: SchedSecureObjectsRollback. Return value 1.
Action start 16:22:49: StopServices.
Action ended 16:22:49: StopServices. Return value 1.
Action start 16:22:49: DeleteServices.
Action ended 16:22:49: DeleteServices. Return value 1.
Action start 16:22:49: RemoveRegistryValues.
Action ended 16:22:49: RemoveRegistryValues. Return value 1.
Action start 16:22:49: RemoveEnvironmentStrings.
Action ended 16:22:49: RemoveEnvironmentStrings. Return value 1.
Action start 16:22:49: RemoveFiles.
Action ended 16:22:49: RemoveFiles. Return value 0.
Action start 16:22:49: RemoveFolders.
Action ended 16:22:49: RemoveFolders. Return value 1.
Action start 16:22:49: CreateFolders.
Action ended 16:22:49: CreateFolders. Return value 1.
Action start 16:22:49: InstallFiles.
Action ended 16:22:49: InstallFiles. Return value 1.
Action start 16:22:49: WriteRegistryValues.
Action ended 16:22:49: WriteRegistryValues. Return value 1.
Action start 16:22:49: WriteEnvironmentStrings.
Action ended 16:22:49: WriteEnvironmentStrings. Return value 1.
Action start 16:22:49: InstallServices.
Action ended 16:22:49: InstallServices. Return value 1.
Action start 16:22:49: SchedSecureObjects.
Action start 16:22:49: ExecSecureObjects.
Action ended 16:22:49: ExecSecureObjects. Return value 1.
Action ended 16:22:49: SchedSecureObjects. Return value 1.
Action start 16:22:49: StartServices.
Action ended 16:22:49: StartServices. Return value 1.
Action start 16:22:49: RegisterUser.
Action ended 16:22:49: RegisterUser. Return value 1.
Action start 16:22:49: RegisterProduct.
Action ended 16:22:49: RegisterProduct. Return value 1.
Action start 16:22:49: PublishFeatures.
Action ended 16:22:49: PublishFeatures. Return value 1.
Action start 16:22:49: PublishProduct.
Action ended 16:22:49: PublishProduct. Return value 1.
Action start 16:22:49: QtInstallMySql.
Action ended 16:22:49: QtInstallMySql. Return value 1.
Action start 16:22:49: QtExecDeferred.
Action ended 16:22:49: QtExecDeferred. Return value 1.
Action start 16:22:49: InstallFinalize.
CAQuietExec:  Service successfully installed.
CAQuietExec:  The MySQL.WHS service is starting.
CAQuietExec:  The MySQL.WHS service could not be started.
CAQuietExec: 
CAQuietExec:  A system error has occurred.
CAQuietExec: 
CAQuietExec:  System error 1067 has occurred.
CAQuietExec: 
CAQuietExec:  The process terminated unexpectedly.
CAQuietExec: 
CAQuietExec:  Error 0x80070002: Command line returned an error.
CAQuietExec:  Error 0x80070002: CAQuietExec Failed
Action ended 16:24:18: InstallFinalize. Return value 3.
Action ended 16:24:21: INSTALL. Return value 3.
Property(S): PHPEXISTS = C:\php5\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:\Program Files\mysql\
Property(S): bin = C:\Program Files\mysql\bin\
Property(S): data = C:\Program Files\mysql\data\
Property(S): Docs = C:\Program Files\mysql\Docs\
Property(S): debug = C:\Program Files\mysql\Embedded\DLL\debug\
Property(S): release = C:\Program Files\mysql\Embedded\DLL\release\
Property(S): debug_1 = C:\Program Files\mysql\Embedded\static\debug\
Property(S): release_1 = C:\Program Files\mysql\Embedded\static\release\
Property(S): include = C:\Program Files\mysql\include\
Property(S): mysql_2 = C:\Program Files\mysql\include\mysql\
Property(S): debug_2 = C:\Program Files\mysql\lib\debug\
Property(S): opt = C:\Program Files\mysql\lib\opt\
Property(S): share = C:\Program Files\mysql\share\
Property(S): charsets = C:\Program Files\mysql\share\charsets\
Property(S): czech = C:\Program Files\mysql\share\czech\
Property(S): danish = C:\Program Files\mysql\share\danish\
Property(S): dutch = C:\Program Files\mysql\share\dutch\
Property(S): english = C:\Program Files\mysql\share\english\
Property(S): estonian = C:\Program Files\mysql\share\estonian\
Property(S): french = C:\Program Files\mysql\share\french\
Property(S): german = C:\Program Files\mysql\share\german\
Property(S): greek = C:\Program Files\mysql\share\greek\
Property(S): hungarian = C:\Program Files\mysql\share\hungarian\
Property(S): italian = C:\Program Files\mysql\share\italian\
Property(S): japanese = C:\Program Files\mysql\share\japanese\
Property(S): japanese_sjis = C:\Program Files\mysql\share\japanese-sjis\
Property(S): korean = C:\Program Files\mysql\share\korean\
Property(S): norwegian = C:\Program Files\mysql\share\norwegian\
Property(S): norwegian_ny = C:\Program Files\mysql\share\norwegian-ny\
Property(S): polish = C:\Program Files\mysql\share\polish\
Property(S): portuguese = C:\Program Files\mysql\share\portuguese\
Property(S): romanian = C:\Program Files\mysql\share\romanian\
Property(S): russian = C:\Program Files\mysql\share\russian\
Property(S): serbian = C:\Program Files\mysql\share\serbian\
Property(S): slovak = C:\Program Files\mysql\share\slovak\
Property(S): spanish = C:\Program Files\mysql\share\spanish\
Property(S): swedish = C:\Program Files\mysql\share\swedish\
Property(S): ukrainian = C:\Program Files\mysql\share\ukrainian\
Property(S): ProgramMenuFolder = C:\Documents and Settings\Administrator\Start Menu\Programs\
Property(S): mysql_1 = E:\MySQL Databases\mysql\
Property(S): TARGETDIR = E:\
Property(S): QtExecDeferred = "c:\windows\system32\Net.exe" start MySQL.WHS
Property(S): QtInstallMySql = "c:\Progra~1\mysql\bin\mysqld.exe" --install MySQL.WHS --defaults-file="C:\Progra~1\mysql\my-whs.ini"
Property(S): QtRemoveMySql = "c:\Progra~1\mysql\bin\mysqld.exe" --remove MySQL.WHS
Property(S): ExecSecureObjects = C:\Program Files\mysql\?CreateFolder??Guests?268435456
Property(S): ExecSecureObjectsRollback = C:\Program Files\mysql\?CreateFolder?D:AI(A;ID;0x1200a9;;;BU)(A;OICIIOID;GXGR;;;BU)(A;ID;0x1301bf;;;PU)(A;OICIIOID;SDGXGWGR;;;PU)(A;ID;FA;;;BA)(A;OICIIOID;GA;;;BA)(A;ID;FA;;;SY)(A;OICIIOID;GA;;;SY)(A;OICIIOID;GA;;;CO)(A;ID;0x1301bf;;;S-1-5-13)(A;OICIIOID;SDGXGWGR;;;S-1-5-13)?0
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:\Program Files\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:\Program Files\
Property(S): DLL = C:\Program Files\mysql\Embedded\DLL\
Property(S): Embedded = C:\Program Files\mysql\Embedded\
Property(S): static = C:\Program Files\mysql\Embedded\static\
Property(S): MySQL_Databases = E:\MySQL Databases\
Property(S): test = E:\MySQL Databases\test\
Property(S): SourceDir = C:\Documents and Settings\All Users\Application Data\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.8
Property(S): UpgradeCode = {60AD6671-BDB2-4CFB-9324-E52B916954C8}
Property(S): WHSLogo = 1
Property(S): PackageCode = {51AE1CD1-F39D-4282-BF3D-1C6450BFFC9D}
Property(S): ProductState = -1
Property(S): PackagecodeChanging = 1
Property(S): CURRENTDIRECTORY = C:\Program Files\Windows Home Server
Property(S): CLIENTUILEVEL = 2
Property(S): CLIENTPROCESSID = 3688
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:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\
Property(S): CommonFilesFolder = C:\Program Files\Common Files\
Property(S): AppDataFolder = C:\Documents and Settings\Administrator\Application Data\
Property(S): FavoritesFolder = C:\Documents and Settings\Administrator\Favorites\
Property(S): NetHoodFolder = C:\Documents and Settings\Administrator\NetHood\
Property(S): PersonalFolder = C:\Documents and Settings\Administrator\My Documents\
Property(S): PrintHoodFolder = C:\Documents and Settings\Administrator\PrintHood\
Property(S): RecentFolder = C:\Documents and Settings\Administrator\Recent\
Property(S): SendToFolder = C:\Documents and Settings\Administrator\SendTo\
Property(S): TemplateFolder = C:\Documents and Settings\Administrator\Templates\
Property(S): CommonAppDataFolder = C:\Documents and Settings\All Users\Application Data\
Property(S): LocalAppDataFolder = C:\Documents and Settings\Administrator\Local Settings\Application Data\
Property(S): MyPicturesFolder = C:\Documents and Settings\Administrator\My Documents\My Pictures\
Property(S): AdminToolsFolder = C:\Documents and Settings\Administrator\Start Menu\Programs\Administrative Tools\
Property(S): StartupFolder = C:\Documents and Settings\Administrator\Start Menu\Programs\Startup\
Property(S): StartMenuFolder = C:\Documents and Settings\Administrator\Start Menu\
Property(S): DesktopFolder = C:\Documents and Settings\Administrator\Desktop\
Property(S): FontsFolder = C:\WINDOWS\Fonts\
Property(S): GPTSupport = 1
Property(S): OLEAdvtSupport = 1
Property(S): ShellAdvtSupport = 1
Property(S): Intel = 15
Property(S): PhysicalMemory = 1919
Property(S): VirtualMemory = 2966
Property(S): AdminUser = 1
Property(S): LogonUser = Administrator
Property(S): UserSID = S-1-5-21-1756526142-2413260453-3320310378-500
Property(S): UserLanguageID = 2057
Property(S): ComputerName = SERVER
Property(S): SystemLanguageID = 2057
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 = 16:24:21
Property(S): Date = 12/01/2010
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 = Windows Home Server User
Property(S): COMPANYNAME = Family
Property(S): DATABASE = C:\WINDOWS\Installer\149c4e.msi
Property(S): OriginalDatabase = C:\Documents and Settings\All Users\Application Data\Microsoft\Windows Home Server\MySql Installer for WHS.msi
Property(S): UILevel = 3
Property(S): ACTION = INSTALL
Property(S): ROOTDRIVE = E:\
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:\Documents and Settings\All Users\Application Data\Microsoft\Windows Home Server\
Property(S): SourcedirProduct = {2490A341-EACF-4279-B587-320CE62D02FD}
Property(S): ProductToBeRegistered = 1
MSI (s) (F4:C4) [16:24:21:968]: Product: MySql Installer for WHS -- Installation failed.

=== Logging stopped: 12/01/2010  16:24:21 ===


Top
 Profile  
Thanks  

Attention Guest: Remove this ad by Registering with the MediaSmartServer.net Forums. It's Free!
PostPosted: Tue Jan 12, 2010 1:38 pm 
Offline
Uber Moderator
Uber Moderator
User avatar

Joined: Sun Dec 02, 2007 3:29 am
Posts: 1736
Location: Brighton, England
Thanks: 27
Thanked: 202 times in 152 posts
I'm not in a position to check on this fully, but the first thing that stands out is it was working on drive E instead of D. I'm not sure if there is anything hard coded in the sql ini file for D so will check when I get home. Can you shed any light on your drive arrangement on the server?

_________________
Have you tried our Add-Ins? If so, be sure to Rate them at WeGotServed.
Help support MediaSmartServer.Net!


Top
 Profile  
Thanks  
PostPosted: Tue Jan 12, 2010 1:40 pm 
Offline
Uber Moderator
Uber Moderator
User avatar

Joined: Sun Dec 02, 2007 3:29 am
Posts: 1736
Location: Brighton, England
Thanks: 27
Thanked: 202 times in 152 posts
sorry, oldgoat... same applied to your issue as well. Could you let me know whats on E?

I'm pretty sure mysql hard codes the database drive in the ini file and thats probably what the issue is

_________________
Have you tried our Add-Ins? If so, be sure to Rate them at WeGotServed.
Help support MediaSmartServer.Net!


Top
 Profile  
Thanks  
PostPosted: Wed Jan 13, 2010 3:33 am 
Offline
Newbie
Newbie

Joined: Tue Jan 12, 2010 11:09 am
Posts: 3
Thanks: 0
Thanked: 0 time in 0 post
Thanks for the quick response. Yes the system has a separate E drive that's used for periodic backups of WHS itself (i.e. Server backup drive not server storage drive).

I'll remove it for now & try the install again...


Top
 Profile  
Thanks  
PostPosted: Wed Jan 13, 2010 4:34 am 
Offline
Newbie
Newbie

Joined: Tue Jan 12, 2010 11:09 am
Posts: 3
Thanks: 0
Thanked: 0 time in 0 post
Temporarily disconnected the E drive & MySQL install worked fine. Reconnected the E drive & everything still ok.

I think this may be the problem some other respondents have had...

Good work, thanks.


Top
 Profile  
Thanks  
PostPosted: Wed Jan 13, 2010 8:46 am 
Offline
Uber Moderator
Uber Moderator
User avatar

Joined: Sun Dec 02, 2007 3:29 am
Posts: 1736
Location: Brighton, England
Thanks: 27
Thanked: 202 times in 152 posts
Great thanks for the update; I'll make some amendments for the next release to counter that.

Cheers.

Nigel.

_________________
Have you tried our Add-Ins? If so, be sure to Rate them at WeGotServed.
Help support MediaSmartServer.Net!


Top
 Profile  
Thanks  
PostPosted: Wed Jan 13, 2010 4:10 pm 
Offline
Newbie
Newbie

Joined: Fri Dec 18, 2009 10:12 am
Posts: 4
Thanks: 0
Thanked: 0 time in 0 post
Cougar wrote:
sorry, oldgoat... same applied to your issue as well. Could you let me know whats on E?

I'm pretty sure mysql hard codes the database drive in the ini file and thats probably what the issue is


No problem, Cougar. You've a lot on your plate!

That's definately it. My system has a 2nd 1.5 gb drive, to which the system assigned E:. It is used only for server backups. Disabling server backups didn't work, so temporarily I removed that drive physically.

Your installer went without a hitch with no E: drive. I haven't tested anything, but at least I finally got it installed.

Thanks to Bandit99 and you for a much-needed workaround.


Top
 Profile  
Thanks  
PostPosted: Wed Jan 13, 2010 4:27 pm 
Offline
Uber Moderator
Uber Moderator
User avatar

Joined: Sun Dec 02, 2007 3:29 am
Posts: 1736
Location: Brighton, England
Thanks: 27
Thanked: 202 times in 152 posts
oldgoat wrote:
No problem, Cougar. You've a lot on your plate!


Yeah Xmas in Disneyworld was a killer :D

Thanks for letting me know; i'll sort it once and for all with the next release, which will kill off the Access Violation issue as well.

_________________
Have you tried our Add-Ins? If so, be sure to Rate them at WeGotServed.
Help support MediaSmartServer.Net!


Top
 Profile  
Thanks  
PostPosted: Fri Jan 15, 2010 7:26 pm 
Offline
Newbie
Newbie

Joined: Tue Jan 05, 2010 4:28 pm
Posts: 3
Thanks: 0
Thanked: 0 time in 0 post
hi again i do everything what i can but still PMA not working so i find one usefull soft for SQL and i create DB assigne user and filnally install the CMS there is it "Navicat for MySQL Enterprise v8.2.18" http://www.downarchive.com/software/int ... v8218.html


Top
 Profile  
Thanks  
PostPosted: Sat Jan 16, 2010 1:18 am 
Offline
Uber Moderator
Uber Moderator
User avatar

Joined: Sun Dec 02, 2007 3:29 am
Posts: 1736
Location: Brighton, England
Thanks: 27
Thanked: 202 times in 152 posts
lordcerberus wrote:
hi again i do everything what i can but still PMA not working so i find one usefull soft for SQL and i create DB assigne user and filnally install the CMS there is it "Navicat for MySQL Enterprise v8.2.18" http://www.downarchive.com/software/int ... v8218.html


Ive answered your problem here

_________________
Have you tried our Add-Ins? If so, be sure to Rate them at WeGotServed.
Help support MediaSmartServer.Net!


Top
 Profile  
Thanks  
PostPosted: Tue Feb 16, 2010 12:08 pm 
Offline
Newbie
Newbie

Joined: Tue Feb 16, 2010 11:44 am
Posts: 1
Thanks: 0
Thanked: 0 time in 0 post
macfather asked a couple of questions about mySQL setup back in Dec.
The following seems to work, anyone have better ideas or pointers to more information.
In IIS Mgr under Default Web Site, right click on Properties for pma.
Under Directory Security, IP address and ..., click Edit, check Denied access.
Then Add, then check Group of computers. Net ID something like 192.168.0.0
Subnet mask something like 255.255.255.0
You will need to use https://myserver/pma to access now, not your internet name for server.

To enable computers on your home net to use mysql clients add an entry to WHS firewall for tcp port 3306, if you want clients in internet space need to setup router also to pass 3306.

No way I would open access to a database server to internet, just seems to risky.
As for how secure the protection above is for /pma, I don't know, just know I can't use it from outside my home net.


Top
 Profile  
Thanks  
PostPosted: Sun Feb 21, 2010 9:57 am 
Offline
.5TB storage
.5TB storage

Joined: Sun Feb 21, 2010 9:53 am
Posts: 20
Thanks: 0
Thanked: 0 time in 0 post
Hello,
I'm new to the forum but have used WHS for a while now. I used to have a website using PHP and MySQL, so when I had to to a fresh install recently, I decided to use the add in's for these two programs. However, I'm having problems accessing the root user on phpmyadmin log in screen.
Here are my exact installation steps:
Installed PHP Add In
Rebooted
Installed MySQL Add In
Rebooted
Put https://xxserver/pma into IE7
IE7 comes back with "There is a problem with this website's security certificate"
I click "Continue to this website"
It now goes to the Log In page
Username is "root"
Password is left empty
Click "Go"
IE7 comes back with "The website cannot display the page" with the "HTTP 500 Internal Server Error"
I'm not sure what is wrong since the test page is working correctly.
Can someone help?
Thanks in advance,
Chuck


Top
 Profile  
Thanks  
PostPosted: Sun Feb 21, 2010 11:06 am 
Offline
Uber Moderator
Uber Moderator
User avatar

Joined: Sun Dec 02, 2007 3:29 am
Posts: 1736
Location: Brighton, England
Thanks: 27
Thanked: 202 times in 152 posts
I think this is a clash with libmysql.dll; doesn't seem to effect everyone for some reason either. Just rename the libmysql.dll in c:\program files\mysql\bin and restart and you should be good to go. It will be resolved in the next release.

_________________
Have you tried our Add-Ins? If so, be sure to Rate them at WeGotServed.
Help support MediaSmartServer.Net!


Top
 Profile  
Thanks  
PostPosted: Sun Feb 21, 2010 12:15 pm 
Offline
.5TB storage
.5TB storage

Joined: Sun Feb 21, 2010 9:53 am
Posts: 20
Thanks: 0
Thanked: 0 time in 0 post
Cougar wrote:
I think this is a clash with libmysql.dll; doesn't seem to effect everyone for some reason either. Just rename the libmysql.dll in c:\program files\mysql\bin and restart and you should be good to go. It will be resolved in the next release.

Thanks for the quick reply. I will try that eventually. My server is currently in use and I can't restart it. I also use WHS to record my TV, so my wife may not like it if I restart it.

Not to rush you at all, but do you know when the next install will come out? If relatively soon, I may just wait.

Also, I'm going to PM you with some non related questions that you may be able to answer for me. I will send it shortly.

Thanks,
Chuck


Top
 Profile  
Thanks  
PostPosted: Mon Feb 22, 2010 3:27 am 
Offline
.5TB storage
.5TB storage

Joined: Sun Feb 21, 2010 9:53 am
Posts: 20
Thanks: 0
Thanked: 0 time in 0 post
Cougar wrote:
I think this is a clash with libmysql.dll; doesn't seem to effect everyone for some reason either. Just rename the libmysql.dll in c:\program files\mysql\bin and restart and you should be good to go. It will be resolved in the next release.

Cougar,
That got me into it. However I still have some issues per phpMyAdmin. At the bottom of the main screen it tells me that "The additional features for working with linked tables have been deactivated" as well as another message that says "Your PHP MySQL library version 5.0.51a differs from your MySQL server version 5.1.36. This may cause unpredictable behavior"
Do you have any idea as to what these problems are and why I am having them? Also I sent you a PM with other questions.
Do you have any idea why IE7 comes back with "There is a problem with this website's security certificate" when I try to go into pma? Can it be corrected?

Thanks in advance,
Chuck


Top
 Profile  
Thanks  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 137 posts ]  Go to page Previous  1 ... 3, 4, 5, 6, 7, 8, 9, 10  Next

All times are UTC - 7 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group