Mailing List Archive


Back to the month index Back to the list index
Dean Karres (karres@southwind.net)
Tue, 11 Nov 1997 12:25:07 -0600 (CST) 

From: Dean Karres <karres@southwind.net>
Message-Id: <199711111825.MAA27678@onyx.southwind.net>
Subject: msql 2.0.3: indices and msqlListFields() question
Date: Tue, 11 Nov 1997 12:25:07 -0600 (CST)

Hi,

I am running:

Version Details :-

        msqladmin version 2.0.3
        mSQL server version 2.0.3
        mSQL protocol version 23
        mSQL connection Localhost via UNIX socket
        Target platform BSD_OS-2.1-i386

I have a question about msqlListFields() and indices. I have defined a
table

    create table foo
    (
        a int not null,
        b char(10)
    )

    create unique index index1 on foo
    (
        a
    )

I then do a msqlListFields() and get:

    a
    b
    index1

This is fine I suppose but I am wondering if "index1" is litterally a
field that I can manipulate or if I need to keep track of the indices
that I create and ignore the last N fields returned by msqlListFields()?
This begs the question, are the indices *always* going to be the last
fields specified in a table definition?

I see in the msql.h file that a type value of IDX_TYPE is defined. I'll
suppose that it is valid for me to filter index fields based on that.

Based on the msql.h file then, how many of the other types mentioned are
currently valid? I know about the int, real, char and text types. Are
the others just placeholders for now?

Dean...K... 

-- 
Dean Karres               | http://www2.southwind.net/~karres
     karres@southwind.net |
Southwind Internet Access | Programmer / Systems Administrator
Wichita, KS               | <Troll 2nd Class /w Clusters>
From jmm@rccn.net  Tue Nov 11 13:33:54 1997
Received: from wep.rccn.net (phobos.rccn.net [193.136.7.17])
	by services.bunyip.com (8.8.5/8.8.5) with SMTP id NAA05254
	for <msql-list@services.bunyip.com>; Tue, 11 Nov 1997 13:33:53 -0500 (EST)
Received: from dione.rccn.net by phobos.rccn.net with SMTP (PP);
          Tue, 11 Nov 1997 18:32:31 +0000
Message-ID: <34689893.80651197@rccn.net>
Date: Tue, 11 Nov 1997 18:40:35 +0100
From: Joao Mendes Moreira <jmm@rccn.net>
Organization: FCCN
X-Mailer: Mozilla 4.01 [en] (Win95; I)
MIME-Version: 1.0
To: cosmin@indigo.quadrant.net
CC: Multiple recipients of list <msql-list@services.bunyip.com>
Subject: Re: rc.local entry
X-Priority: 3 (Normal)
References: <Pine.BSI.3.95.971111120721.20915B-100000@indigo.quadrant.net>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

cosmin@indigo.quadrant.net wrote:
> 
> Hi everyone,
> 
> I have msql running on a BSD 3.0 system.
> I have created a user called msql and the msql2d daemon runs
> as this user.
> 
> I want to be able to start up the msql2d daemon at boot time.
> A simple entry in the rc.local such as:
> 
> /usr/local/Hughes/bin/msql2d &
> 
> will not do it, since I need to run the server as user msql.
> If anyone setup their rc.local file to start the msql daemon at boot time
> and run as a user other than root, please let me know.

	Please try

su -c "/usr/local/Hughes/bin/msql2d" msql

	Joao Moreira

> 
> I did get it started with a crontab file for user msql, but I am
> interested in starting the daemon directly from the rc.local file - as
> user msql.
> 
> Any help would be appreciated. Thanks.
> 
> Version Details :-
> 
>         msqladmin version       2.0.1
>         mSQL server version     2.0.1
>         mSQL protocol version   23
>         mSQL connection         Localhost via UNIX socket
>         Target platform         BSD_OS-3.0-i386
> 
> Configuration Details :-
> 
>         Default config file     /usr/local/Hughes/msql.conf
>         TCP socket              1114
>         UNIX socket             /usr/local/Hughes/msql2.sock
>         mSQL user               msql
>         Admin user              cosmin
>         Install directory       /usr/local/Hughes
>         PID file location       /usr/local/Hughes/msql2d.pid
>         Memory Sync Timer       30
>         Hostname Lookup         True
> 
> --Cosmin H.
From aacesta@ahand.unicamp.br  Tue Nov 11 16:54:48 1997
Received: from mocha.bunyip.com (mocha.Bunyip.Com [192.197.208.1])
	by services.bunyip.com (8.8.5/8.8.5) with ESMTP id QAA08949
	for <msql-list@services.bunyip.com>; Tue, 11 Nov 1997 16:54:47 -0500 (EST)
Received: from gramado.ahand.unicamp.br (gramado.ahand.unicamp.br [143.106.25.1])
	by mocha.bunyip.com (8.8.5/8.8.5) with ESMTP id QAA28670
	for <msql-list@Bunyip.Com>; Tue, 11 Nov 1997 16:54:49 -0500 (EST)
Received: from mafalda.ahand.unicamp.br (aacesta@mafalda.ahand.unicamp.br [143.106.25.69])
	by gramado.ahand.unicamp.br (8.8.7/8.8.7) with ESMTP id TAA15478;
	Tue, 11 Nov 1997 19:50:31 -0200 (EDT)
Received: (from Received: (from aacesta@localhost)
	by mafalda.ahand.unicamp.br (8.8.7/8.8.7) id TAA22722;
	Tue, 11 Nov 1997 19:56:17 -0200
Date: Tue, 11 Nov 1997 19:56:17 -0200
Message-Id: <199711112156.TAA22722@mafalda.ahand.unicamp.br>
From: Andre Augusto Cesta <aacesta@ahand.unicamp.br>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
To: msql-list@Bunyip.Com, aacesta@ahand.unicamp.br
Subject: mSQL evaluation report
X-Mailer: VM 6.34 under Emacs 19.34.1

Hi, maybe I'll get another comercial mSQL running...

A company considering licensing mSQL, requested me an evaluation
report about it.  I am in trouble because although the whole thing may
end up in a Unix mSQL server they also want information about Windows
mSQL ports and Windows client API's. I use mSQL only under Linux and
Solaris systems with the Java, C and Perl languages. The only mSQL
related code I've run on Windows was a Java applet. I'll put the
information I obtained about Windows on the end of the email.

I need some help in doing the Windows part of this report, is there
anyone with a working Windows-mSQL-SomeProgLanguage system? Please
provide me some evaluation on your system (please send system
configuration detais as well: operating system versions, api versions
and sites were to download system components, performance, bugs). 

How do the license terms apply to ports (the same)?  I think Hughes
only supports the Unix versions and developing over a Windows port may
become a complicated task.

>From neros world:
quoting msql116c_os2.lsm (only OS/2):
Platform:       OS/2 2.x or Warp (Connect) with TCP/IP (IAK)

quoting msql201b.lsm (beta!):
Platform:       OS/2 2.x or Warp (Connect) with TCP/IP (IAK),
                Windows NT with TCP/IP (WinSocks)

Still have to check the availability of the Perl module for
NT... Anyone uses Perl with mSQL on Windows?

I'd appreciate your help, thanks. 

Tchau: Cesta