Active TopicsActive Topics  Display List of Forum MembersMemberlist  Search The ForumSearch  HelpHelp
  RegisterRegister  LoginLogin
PowerHome General
 PowerHome Messageboard : PowerHome General
Subject Topic: PH stalls on startup "Connect to SQL..." Post ReplyPost New Topic
Author
Message << Prev Topic | Next Topic >>
jeffw_00
Super User
Super User


Joined: June 30 2007
Online Status: Offline
Posts: 929
Posted: July 20 2019 at 08:05 | IP Logged Quote jeffw_00

Hi - My goal is to make sure that, unattended, Powerhome always starts up properly when my PC reboots. To that end, I have PH write a "I'm healthy file) after it starts up, and a Perl script that waits a bit after boot and then checks that the file exists. However, things don't work well when Powerhome starts up partially, and I get a grey window:
-----------------
Header: Connect to SQL Anywhere
Tabs: Login [active], ODBC, Database, Network, Advanced

* Supply user ID and password
UserId: Powerhome
Password: **********

OK Cancel Help
-----------------

Now, my perl script detects something's wrong, and tries to kill pwrhome.exe, but hangs (not sure why - but that's my problem). I could go nuclear and just have it reboot the PC instead, but I'm writing because I was wondering if anyone knew why this SQL window came up, and how to get past it.   

Alternately, does anyone know how to INDUCE this behavior so I can better figure out how to get around it?

Thanks Very Much!
/j


[FWIW - I'm actually going beyond this, once in a blue moon PH freezes, so my PH writes a file every 15min and my Perl script reacts if it goes 30 min without seeing a new file]

Edited by jeffw_00 - July 20 2019 at 08:06
Back to Top View jeffw_00's Profile Search for other posts by jeffw_00
 
jeffw_00
Super User
Super User


Joined: June 30 2007
Online Status: Offline
Posts: 929
Posted: July 20 2019 at 08:07 | IP Logged Quote jeffw_00

Back to Top View jeffw_00's Profile Search for other posts by jeffw_00
 
jeffw_00
Super User
Super User


Joined: June 30 2007
Online Status: Offline
Posts: 929
Posted: July 20 2019 at 08:42 | IP Logged Quote jeffw_00

perhaps I need to kill rteng11.exe before pwrhome.exe when this happens?
Back to Top View jeffw_00's Profile Search for other posts by jeffw_00
 
dhoward
Admin Group
Admin Group
Avatar

Joined: June 29 2001
Location: United States
Online Status: Offline
Posts: 4447
Posted: July 20 2019 at 08:52 | IP Logged Quote dhoward

Jeff,

Yes, if you get the SQL Anywhere popup, I would kill rteng11.exe. The SQL popup appears when PowerHome is having a problem connecting
to the database and is usually an indicator there is a problem with the rteng11.exe process.

Under normal operations, PowerHome is launched and should start the rteng11.exe process so it can connect to the database. If the
rteng11 process is already running, then this will fail. When PowerHome is terminated (normally), the last thing it does is to shutdown
the SQL Anywhere database. If PowerHome is terminated (abnormally), then the rteng11 process will remain running for awhile. If
everything is ok with the process, it will sense that PowerHome is no longer running and has closed the database connection and will
then clean up and close itself. Sometimes though, this does not happen and the process hangs around.

Concerning PowerHome starting on a reboot, I know some people have had better success with launching a separate app first that has a
delay and then launches PowerHome after the PC is fully up and going vs just placing the pwrhome.exe in the startup folder.

Dave.
Back to Top View dhoward's Profile Search for other posts by dhoward Visit dhoward's Homepage
 
jeffw_00
Super User
Super User


Joined: June 30 2007
Online Status: Offline
Posts: 929
Posted: July 20 2019 at 09:13 | IP Logged Quote jeffw_00

Hey Dave - always good to hear from you! I hope life is treating you well.

Thanks for the quick and thorough response. I do already delay PH startup for a while after boot, but I did shorten it recently, I'll extend it some more.

I have also added to my script a kill of rteng11.exe, 2 sec. before I kill pwrhome.exe. I'll keep you posted if there are any further issues.

Best!
/j
Back to Top View jeffw_00's Profile Search for other posts by jeffw_00
 
GadgetGuy
Super User
Super User
Avatar

Joined: June 01 2008
Location: United States
Online Status: Offline
Posts: 942
Posted: July 26 2022 at 17:18 | IP Logged Quote GadgetGuy

Just ran into the same issues today and finally discovered that the PowerHome "database" Folder must contain both the "pwrhome.db" and the "phlogs.db" files.

I was missing the phlogs.db file and didn't realize it was important until prowling around for awhile.


Edited by GadgetGuy - July 26 2022 at 17:19


__________________
Ken B - Live every day like it's your last. Eventually, you'll get it right!
Back to Top View GadgetGuy's Profile Search for other posts by GadgetGuy
 

If you wish to post a reply to this topic you must first login
If you are not already registered you must first register

  Post ReplyPost New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum