Service OSAE failed to start. Verify...sufficient privileges
Re: Service OSAE failed to start. Verify...sufficient privil
Also try accessing the OSAE database using Mysql Workbench using the OSAE login credintials, not the ROOT.
Also, make sure you did not change the OSAE User Password.
You can check this and the other settings in the registry at: HKLM/SOFTWARE/OSAE/DBSETTINGS
Also, make sure you did not change the OSAE User Password.
You can check this and the other settings in the registry at: HKLM/SOFTWARE/OSAE/DBSETTINGS
Re: Service OSAE failed to start. Verify...sufficient privil
@tommysharpAutomate wrote:I assume you did try to re-install OSA? I found this http://www.opensourceautomation.com/php ... 5755#p5755
Also the osae DB user has full privileges to the osae database right?
To see if it's a problem with the OSA web server you could try downloading and installing the UltiDev Web Pro server from here
http://ultidev.com/download/
If you have problems with UltiDev see this topic http://ultidev.com/Forums/yaf_postst645 ... setup.aspx
I know you got OSA running on WinXP but did you try the above on your Windows Server setup? Some people have reported issues running OSA on Windows Server. It would be great to find the root cause and fix it for OSA 0.4.4 so we have less install problems with new users.
-
- Posts: 55
- Joined: Thu Jun 12, 2014 1:02 pm
Re: Service OSAE failed to start. Verify...sufficient privil
My Windows Home server box has a pretty old version of MySql on it so assumed that was the problem. My MediaPortal server uses that DB so didn't want to tinker too much [SMILING FACE WITH SMILING EYES]
Sent from my Nexus 5 using Tapatalk
Sent from my Nexus 5 using Tapatalk
Re: Service OSAE failed to start. Verify...sufficient privil
You could try running the install SQL script here https://github.com/opensourceautomation ... ae_043.sql
That should tell us if it was a SQL version problem.
That should tell us if it was a SQL version problem.
-
- Posts: 55
- Joined: Thu Jun 12, 2014 1:02 pm
Re: Service OSAE failed to start. Verify...sufficient privil
That SQL script ran without error on the MySQL database on my home server. It's MySQL 5.1...
Will try the install again on there over the weekend, because it definitely got stuck at one point of the install...
Will try the install again on there over the weekend, because it definitely got stuck at one point of the install...
Re: Service OSAE failed to start. Verify...sufficient privil
One other SQL related thing it could be is starting MySQL Events.
Log into MySQL as the osae user and trying running the following:
Log into MySQL as the osae user and trying running the following:
Code: Select all
SET GLOBAL event_scheduler = ON;
-
- Posts: 55
- Joined: Thu Jun 12, 2014 1:02 pm
Re: Service OSAE failed to start. Verify...sufficient privil
Had a quick look through the wiki and couldn't find the default password for the osae user.... Any ideas?
Thought I'd look through the SQL script but didn't get further than...
Thought I'd look through the SQL script but didn't get further than...
Had to laugh! What do we use that for?'Your mama is so fat. She jumped in the air and got stuck.'
-
- Posts: 55
- Joined: Thu Jun 12, 2014 1:02 pm
Re: Service OSAE failed to start. Verify...sufficient privil
Running this query...
Resulted in...SET GLOBAL event_scheduler = ON;
So looks like it was okay as no errors...SET GLOBAL event_scheduler = ON;
/* Affected rows: 0 Found rows: 0 Warnings: 0 Duration for 1 query: 0.000 sec. */
Re: Service OSAE failed to start. Verify...sufficient privil
Did you ever try installing the UltiDev web server on it own?
http://ultidev.com/download/
http://ultidev.com/download/