Main Area and Open Discussion > General Software Discussion
In search of ... several diagnostic tools
Shades:
Till now I encountered a lot of issues with Windows 7 and 2008 R2 when using a web interface to connect to services running on those machines. Lately I found out that it really makes a lot of difference if you start extra services like MySQL, Apache etc. with a user-name that is associated with the service.
When installing MySQL, Apache etc. you notice that extra Windows user groups are created (at least that is the case with Oracle software (which MySQL is now a part of)). Associate your user-name with that group and grant your user-name the 'Log on as service' right.
Initiate/restart the MySQL and/or Apache services with your user-name and suddenly your networking issues disappear.
Really, for anyone who is dabbling with Oracle software (on windows 2008 or higher), use the above method...it will save a lot of time, hair and other kinds of frustration.
Shades:
Actually, the use of a WAMP package solution (Windows, Apache,MySQL, PHP) would be preferable. Previous experiences with XAMPP package make me recommend it heartily.
Free, portable and doesn't even require installation if the archive is extracted in the root folder of a partition. Ideal for a transfer between different systems.
Stoic Joker:
When installing MySQL, Apache etc. you notice that extra Windows user groups are created (at least that is the case with Oracle software (which MySQL is now a part of)). Associate your user-name with that group and grant your user-name the 'Log on as service' right.-Shades (February 19, 2012, 12:38 PM)
--- End quote ---
Um... Doesn't that sort of fly in the face of LUA?? ...I've never had an issue with MySQL running under the SYSTEM account.
Shades:
Tell me about it!
But the beast that is Oracle requires some strange manipulations to run right...sometimes. Over time I have created quite some Oracle databases (9i, 10g and 11g) using the Oracle tools intended to create databases. But in Windows 2008 R2 these sometimes do not deliver the intended result. Oracle uses a listener that handles the access to their database. but sometimes the listener is not able to make contact with the database, giving you all kinds of error messages that imply you need to pay (top dollar) for Oracle technicians to fix.
Or you can use the method suggested by my previous post. That solved my problems on three occasions already. Oracle with older Windows operating systems never gave me these kind of errors.
Navigation
[0] Message Index
[*] Previous page
Go to full version