Mailing List Archive


Back to the month index Back to the list index
Andreas Koppenhoefer (koppenhoefer@belwue.de)
Thu, 20 Nov 1997 15:19:42 +0100 

Message-ID: <19971120151942.44463@nepi.belwue.de>
Date: Thu, 20 Nov 1997 15:19:42 +0100
From: Andreas Koppenhoefer <koppenhoefer@belwue.de>
Subject: Re: msqlTimeToUnixTime

On Nov 13, Jens Vonderheide wrote:
> Hi,
>
> I am using mSQL 2.0.3 on a Sun Ultra 1 running Solaris 2.6. My problem
> is that msqlTimeToUnixTime is off by one hour. E.g.
> msqlTimeToUnixTime("00:00:00") return -3600, ("01:00:00") returns 0.
>
> Jens Vonderheide
> Network Operations Center
> University of Technology Aachen, Germany

I think that depends upon your current timezone!? In Germany we are of
GMT by one hour...

- Andreas 

-- 
     Andreas Koppenhoefer <koppenhoefer@belwue.de>    |SysAdmin, Guru
       Rechenzentrum der Universitaet Stuttgart       |on Solaris&Linux
BelWue Koordination; Allmandring 30; D-70550 Stuttgart|Perl, C, Backup,
     Phone +49 711 685-7225, Fax +49 711 678 7626     |Intranet-KnowHow
From grantt@nortel.ca  Thu Nov 20 10:24:38 1997
Received: from bcarsde4.localhost (mailgate.nortel.ca [192.58.194.74])
	by services.bunyip.com (8.8.5/8.8.5) with ESMTP id KAA11821
	for <msql-list@services.bunyip.com>; Thu, 20 Nov 1997 10:24:37 -0500 (EST)
Message-Id: <199711201524.KAA11821@services.bunyip.com>
Received: from bcarsfba.ca.nortel.com (actually bcarsfba.bnr.ca) 
          by bcarsde4.localhost; Thu, 20 Nov 1997 09:21:56 -0500
Received: from bnr.ca by bcarsfba.bnr.ca id <11589-0@bcarsfba.bnr.ca>;
          Thu, 20 Nov 1997 09:19:41 -0500
Date: 20 Nov 1997 09:18 EST
Sender: "Grant Totten" <grantt@nortel.ca>
To: rn@prolink.de
Cc: msql-list@services.bunyip.com
From: "Grant Totten" <grantt@nortel.ca>
Subject: Re: Error Condition Re: Bad Hand Shakes Too Many Connections

So, how do I check the version of my running msql system?

Thanks,

Grant Totten
grantt@nortel.ca

In message "Re: Error Condition Re: Bad Hand Shakes Too Many Connections", 
'rn@prolink.de' writes:

>>  I was wondering if anyone knew if the latest version off mSQL
>>  (msql2.0.3 i think) has taken care of the "To many connections"
>>  problem that i am having.  After reading the mail archive I found
>> ..
>>  running msql2.0.1 on a sparc 20.  A few days ago my database
>>  locked up with "Too many connections". I had to restart it.
>>  
>>  Since then I have been watch the connections and they keep climbing.
>
>Hi Michael,
>
>yes, that bug has gone away with msql-2.0.3.
>
>regards, Ralf
>
From rn@prolink.de  Thu Nov 20 10:40:22 1997
Received: from Sol.prolink.de (root@sol.prolink.de [193.203.166.3])
	by services.bunyip.com (8.8.5/8.8.5) with ESMTP id KAA12448
	for <msql-list@services.bunyip.com>; Thu, 20 Nov 1997 10:40:20 -0500 (EST)
Received: from Jupiter.prolink.de (Jupiter [193.203.166.229])
          by Sol.prolink.de (8.8.4/8.8.4) with SMTP
	  id QAA30791; Thu, 20 Nov 1997 16:39:38 +0100
Received: by Jupiter.prolink.de with Microsoft Mail
	id <01BCF5D2.ED58FA60@Jupiter.prolink.de>; Thu, 20 Nov 1997 16:39:53 +0100
Message-ID: <01BCF5D2.ED58FA60@Jupiter.prolink.de>
From: Ralf Niederhuefner <rn@prolink.de>
To: "'Grant Totten'" <grantt@nortel.ca>
Cc: "msql-list@services.bunyip.com" <msql-list@services.bunyip.com>
Subject: Re: Error Condition Re: Bad Hand Shakes Too Many Connections
Date: Thu, 20 Nov 1997 16:39:52 +0100
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit

Grant Totten wrote:
> So, how do I check the version of my running msql system?

If you issue the command "msqladmin stats"
it will give you something like this:

Server Statistics
-----------------

Mini SQL Version 2.0.3				<----  Here you see
Copyright (c) 1993-94 David J. Hughes
Copyright (c) 1995-97 Hughes Technologies Pty Ltd.
All rights reserved.

Config file      : /usr/local/Hughes/msql.conf
Max connections  : 214
Cur connections  : 1
Running as user  : msql

Connection table :
  Sock    Username       Hostname        Database    Connect   Idle   Queries
 +-----+------------+-----------------+------------+---------+------+--------+
 |   6 | root       | UNIX Sock       | No DB      |  0H  0M |    0 |      1 |
 +-----+------------+-----------------+------------+---------+------+--------+