Service OSAE failed to start. Verify...sufficient privileges

Post here if you are having difficulty getting OSA up and running
Message
Author
User avatar
kherron
Posts: 646
Joined: Mon Dec 05, 2011 10:44 am
Location: Jacksonville, Fl.
Contact:

Re: Service OSAE failed to start. Verify...sufficient privil

#51 Post by kherron » Fri Jun 13, 2014 6:53 am

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

Automate
Posts: 1691
Joined: Sat Dec 11, 2010 1:44 pm
Location: US

Re: Service OSAE failed to start. Verify...sufficient privil

#52 Post by Automate » Thu Jul 03, 2014 6:31 am

Automate 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
@tommysharp

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.

tommysharp
Posts: 55
Joined: Thu Jun 12, 2014 1:02 pm

Re: Service OSAE failed to start. Verify...sufficient privil

#53 Post by tommysharp » Thu Jul 03, 2014 11:47 am

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

Automate
Posts: 1691
Joined: Sat Dec 11, 2010 1:44 pm
Location: US

Re: Service OSAE failed to start. Verify...sufficient privil

#54 Post by Automate » Thu Jul 03, 2014 12:24 pm

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.

tommysharp
Posts: 55
Joined: Thu Jun 12, 2014 1:02 pm

Re: Service OSAE failed to start. Verify...sufficient privil

#55 Post by tommysharp » Thu Jul 03, 2014 12:31 pm

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...

Automate
Posts: 1691
Joined: Sat Dec 11, 2010 1:44 pm
Location: US

Re: Service OSAE failed to start. Verify...sufficient privil

#56 Post by Automate » Thu Jul 03, 2014 12:38 pm

One other SQL related thing it could be is starting MySQL Events.

Log into MySQL as the osae user and trying running the following:

Code: Select all

SET GLOBAL event_scheduler = ON;

tommysharp
Posts: 55
Joined: Thu Jun 12, 2014 1:02 pm

Re: Service OSAE failed to start. Verify...sufficient privil

#57 Post by tommysharp » Thu Jul 03, 2014 1:01 pm

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...
'Your mama is so fat. She jumped in the air and got stuck.'
Had to laugh! What do we use that for?

Automate
Posts: 1691
Joined: Sat Dec 11, 2010 1:44 pm
Location: US

Re: Service OSAE failed to start. Verify...sufficient privil

#58 Post by Automate » Thu Jul 03, 2014 1:12 pm

osaePass

tommysharp
Posts: 55
Joined: Thu Jun 12, 2014 1:02 pm

Re: Service OSAE failed to start. Verify...sufficient privil

#59 Post by tommysharp » Thu Jul 03, 2014 1:22 pm

Running this query...
SET GLOBAL event_scheduler = ON;
Resulted in...
SET GLOBAL event_scheduler = ON;
/* Affected rows: 0 Found rows: 0 Warnings: 0 Duration for 1 query: 0.000 sec. */
So looks like it was okay as no errors...

Automate
Posts: 1691
Joined: Sat Dec 11, 2010 1:44 pm
Location: US

Re: Service OSAE failed to start. Verify...sufficient privil

#60 Post by Automate » Thu Jul 03, 2014 1:30 pm

Did you ever try installing the UltiDev web server on it own?
http://ultidev.com/download/

Post Reply