The user that Servers Alive is running as has rights to create a table? -----Original Message----- From: Servers Alive Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Peter Shankland Sent: 11 March 2008 21:46 To: Servers Alive Discussion List Subject: [Fwd: Re: [SA-list] Uptime Logging to Database Problem]
Have just tried creating a new ODBC connection to a different SQL2000 server and changing the setup within SA to point to this ODBC connection instead. Unfortunatly, I still can't create the table so at least it rules out a problem with the local copy of SQL2005. Has anyone else had any difficulties getting Uptime logging to a DB? Thanks. -------- Original Message -------- Subject: Re: [SA-list] Uptime Logging to Database Problem Date: Fri, 07 Mar 2008 11:25:38 +0100 From: [EMAIL PROTECTED] Reply-To: Servers Alive Discussion List <[email protected]> To: Servers Alive Discussion List <[email protected]> Hi Dirk, When I run as an app, the table still dosn't get created. The following is from the debug debug log file: 07 March 2008 10:10:47 CreateTable: () create table salive( said varchar(15),uniqueid numeric, nYear numeric, nmonth numeric, nday numeric,upcycles numeric, downcycles numeric, maintenancecycles numeric, unavailablecycles numeric, totalcycles numeric,upseconds numeric, downseconds numeric, maintenanceseconds numeric, unavailableseconds I don't think this should matter but I am running MySQL on the same server. Obviously, I have had to set up an ODBC connection to the local SQL2005 instance and this works fine, hence the reason I can't see MySQL would be an issue - thought I should mention it though. Thanks. Pete. Dirk Bulinckx wrote: > When running as app, and when you say the table doesn't get created, what does > the debuglogfile show for that as reason? > > Dirk Bulinckx. > > -----Original Message----- > From: Servers Alive Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of > Peter Shankland > Sent: Friday, February 15, 2008 3:20 PM > To: Servers Alive Discussion List > Subject: Re: [SA-list] Uptime Logging to Database Problem > > Sorry it has taken so long to reply... > > Q: Could it be that you're running app and service at the same time? > A: Definatly just running the service > > Q: Does the service user have rights to the directory where the > logfile should be created? > A: Yes, running as local admin > > Q: If you run it as app does it then create the file/table? > A: If I run as app the debug file does get created, but the table dosn't > > Q: Are you checking via a remote connection or directly on the system > A: Always run through RDC using the command 'mstsc /console' > > Thanks. > > Dirk Bulinckx wrote: > >> Could it be that you're running app and service at the same time? >> does the service user have rights to the directory were the logfile should be >> created? >> If you run it as app does it then create the file/table? >> Are you checking this via a remote connection or directly on the system? >> >> Dirk Bulinckx. >> >> -----Original Message----- >> From: Servers Alive Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of >> Peter Shankland >> Sent: Sunday, February 10, 2008 2:40 PM >> To: Servers Alive Discussion List >> Subject: Re: [SA-list] Uptime Logging to Database Problem >> >> I have now got the debug logging to 'stay' with the changes I have made >> by restarting the service, but even though I have the debug logging >> enabled and set to maximum, I get no log file created :(. This is the >> same sort of problem as I am getting with the SQL Uptime logging. >> >> Peter Shankland wrote: >> >> >>> It is running as a Service. Whenever I try to enable debug logging to >>> file, I put in the details, click apply then ok and then when I go back >>> into the setup the changes I have made revert to defaults, it all the >>> changes have dissapeared! >>> >>> Very strange >>> >>> Dirk Bulinckx wrote: >>> >>> >>> >>>> How is SA running, as service or as app? >>>> Does the debuglog (file based) show any errors? >>>> >>>> Dirk Bulinckx. >>>> >>>> -----Original Message----- >>>> From: Servers Alive Discussion List [mailto:[EMAIL PROTECTED] On Behalf >>>> > Of > >>>> Peter Shankland >>>> Sent: Sunday, February 10, 2008 1:35 PM >>>> To: Servers Alive Discussion List >>>> Subject: [SA-list] Uptime Logging to Database Problem >>>> >>>> I am using Servers Alive v6.1 and, on the same server, have SQL Express >>>> 2005 installed as I want to be able to log uptime / downtime to a DB. >>>> >>>> I have created the ODBC connection and it tests ok but when I go into SA >>>> and Uptime Logging --> To Database, I enter all the correct information >>>> and press Create Table but the table never does create. >>>> >>>> I have also tried manually creating the DB and then just configuring SA >>>> to use it but no user tables ever get created. >>>> >>>> Any suggestions / ideas? >>>> >>>> Thanks. >>>> >>>> To unsubscribe send a message with UNSUBSCRIBE as subject to >>>> >>>> >> [email protected] >> >> >>>> If you use auto-responders (like out-of-the-office messages), then make sure >>>> that they are not send to the list nor to the individual members of the list >>>> that send a message. Doing this will get you removed from the list. >>>> >>>> To unsubscribe send a message with UNSUBSCRIBE as subject to >>>> >>>> >> [email protected] >> >> >>>> If you use auto-responders (like out-of-the-office messages), then make sure >>>> >>>> >> that they are not send to the list nor to the individual members of the list >> that send a message. Doing this will get you removed from the list. >> >> >>>> >>>> >>>> >>> To unsubscribe send a message with UNSUBSCRIBE as subject to >>> >>> >> [email protected] >> >> >>> If you use auto-responders (like out-of-the-office messages), then make sure >>> >>> >> that they are not send to the list nor to the individual members of the list >> that send a message. Doing this will get you removed from the list. >> >> >>> >>> >> To unsubscribe send a message with UNSUBSCRIBE as subject to >> > [email protected] > >> If you use auto-responders (like out-of-the-office messages), then make sure >> that they are not send to the list nor to the individual members of the list >> that send a message. Doing this will get you removed from the list. >> >> To unsubscribe send a message with UNSUBSCRIBE as subject to >> > [email protected] > >> If you use auto-responders (like out-of-the-office messages), then make sure >> > that they are not send to the list nor to the individual members of the list > that send a message. Doing this will get you removed from the list. > >> >> > > To unsubscribe send a message with UNSUBSCRIBE as subject to [email protected] > If you use auto-responders (like out-of-the-office messages), then make sure > that they are not send to the list nor to the individual members of the list > that send a message. Doing this will get you removed from the list. > > To unsubscribe send a message with UNSUBSCRIBE as subject to [email protected] > If you use auto-responders (like out-of-the-office messages), then make sure that they are not send to the list nor to the individual members of the list that send a message. Doing this will get you removed from the list. > > > To unsubscribe send a message with UNSUBSCRIBE as subject to [email protected] If you use auto-responders (like out-of-the-office messages), then make sure that they are not send to the list nor to the individual members of the list that send a message. Doing this will get you removed from the list. -- No virus found in this incoming message. Checked by AVG. Version: 7.5.518 / Virus Database: 269.21.7/1325 - Release Date: 11/03/2008 13:41 To unsubscribe send a message with UNSUBSCRIBE as subject to [email protected] If you use auto-responders (like out-of-the-office messages), then make sure that they are not send to the list nor to the individual members of the list that send a message. Doing this will get you removed from the list. ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ This e-mail (including any attachments), is confidential and intended only for the use of the addressee(s). It may contain information covered by legal, professional or other privilege. If you are not an addressee, please inform the sender immediately and destroy this e-mail. Do not copy, use or disclose this e-mail. E-mail transmission cannot be guaranteed to be secure or error free. The sender does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard copy version. Freebridge Community Housing Ltd is a Charitable Industrial and Provident Society - Reg No IP29744R Registered with the Housing Corporation - No L4463. VAT Registration Number 860762121 Freebridge Community Housing, Juniper House, Austin Street, Kings Lynn, Norfolk PE30 1DZ ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ To unsubscribe send a message with UNSUBSCRIBE as subject to [email protected] If you use auto-responders (like out-of-the-office messages), then make sure that they are not send to the list nor to the individual members of the list that send a message. Doing this will get you removed from the list.
