Re: FoxBase license on SCO

On Thu, 29 Nov 2007 08:39:31 -0600, "Steve M. Fabac, Jr."
<smfabac@xxxxxxx> wrote:

Joe Chasan wrote:

. use qtemp
Exclusive lock failed
. use qtemp shared
Unrecognized phrase/keyword in command.
. use qtemp excl
Exclusive lock failed

help use lists
Format: USE [<file>] [INDEX <ndx_file_list>] [ALIAS <alias>]

no one is on system (i can't give it to customer with this broken!)

Just a stab in the dark: Try setting up a small file system for the data
files of type EAFS. Move your FoxBASE directory to there and try again.

This worked for old Informix iSQL 4.10.UC2 that used to run on 5.0.6 but would not
run on 5.0.7. I have not tried it on 6.0 of any flavor.


This should not be necessary; the 6.0 system I have Foxbase running on
is not using an EAFS filesystem. I'll have access to the system
tomorrow, so stay tuned.



-joe

On Wed, Nov 28, 2007 at 01:29:02PM -0500, Ben Rosenthal wrote:
Ok. I don't remember if Foxbase shipped as a run time only or not. Try
this go into the data directory and type ./foxplus
You should end up at the Foxplus "dot" prompt. Try opening a table with
the following command:
use <table_name> shared
If that works try:
use <table_name> excl
If no one is using that table then it should open. If it does not then
the problem is OS related.

Ben
Joe Chasan wrote:

all is exact same directory structure (perms, etc) as is currently working
currently on a 5.05 system. perms on .idx and *.fox *.dbf, etc seem fine,
plus it happens to me when running as root anyway, so i doubt its a perms
problem.

i found a /usr/lib/foxplus/config.fx file - is that what you are referring
to? as tar'ed from the working 5.05 system, it contained:
bucket=4
hmemory=4
maxmem=380
mvarsiz=12
mvcount=512
pcache=64

-joe

On Tue, Nov 27, 2007 at 05:55:07PM -0500, Ben Rosenthal wrote:

I'm not running this on OSR6. My last experience with Foxbase was on
5.0.4. There is a config file, the name now excapes me that should be
in the application directory or some where in the path. There is a line
in there that determines wether tables are opened shared or exclusive by
default. I think the file name is config.fp. Let's have a look at it's
contents. Also check the perms on *.dbf, *.idx etc.

Ben

Joe Chasan wrote:

On Fri, Nov 23, 2007 at 02:52:02PM -0500, Joe Chasan wrote:


On Wed, Nov 21, 2007 at 06:02:55PM -0500, Joe Chasan wrote:


On Tue, Nov 20, 2007 at 05:43:14PM +0000, Richard Seeder wrote:


...

You can move your licensed foxbase product from OSR5 to OSR6 simply by
copying the /usr/lib/foxplus directory and relevant /usr/bin scripts;
no need to reinstall and relicense.

I thought i had this licked, got the fox binaries & libs moved over ok,
even found R&R report writer & moved the same way. then when testing the
moved-over stuff i kept getting "File is in use by another", even when no
one on system. i don't use foxbase at all so not familiar with its daily
operation.

checked ta database, all i found is TA #101011 which suggests system lock
table is insufficient - to fix, on Xenix one would increase NFLOCKS and on
Unix one would increase FLCKREC.

i have never had to tune this - if i go in on OSR6 for FLCKREC, it says
recommended extremes are Min 100, Max 20000, currently set at 16000

am i on the right track with the fix for this, and if so, what would be
a reasonable setting for at most 10 concurrent users of fox?

I did try for the max of 20000 while waiting for a response, and was no
better, so i don't think this was the issue, maybe maintenance pack #3
broke something with foxplus? i know it worked on osr6 with mp2...


just found & tried "newer" fox - ver 2.1.2 - all this did was change
the text of the error from "File is in use by another" to "Exclusive lock
failed"

is anyone using this stuff anymore? i'd sure like to hear from someone
that they are successfully using version X of foxplus on openserver 6
with mp3. i do see from mp3 install notes (regarding xenix emulator)
that some change was done for fox, i sure wish there was an easy back-out
of mp3 to test - unfortunately, this was a clean install straight to mp3
so i've really nothing to go back to except start all over again.

--- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - ---
-Joe Chasan- Magnatech Business Systems, Inc.
joe@xxxxxxxxxxxxxxxxxxx Hicksville, NY - USA
http://www.MagnatechOnline.com Tel.(516) 931-4444/Fax.(516) 931-1264



Steve Fabac
S.M. Fabac & Associates
816/765-1670
.

Relevant Pages

  • Re: FoxBase license on SCO
    ... Exclusive lock failed ... use qtemp shared ... its got to be mp3. ... I thought i had this licked, got the fox binaries & libs moved over ok, ...
    (comp.unix.sco.misc)
  • Re: FoxBase license on SCO
    ... Joe Chasan wrote: ... Exclusive lock failed ... use qtemp shared ... with mp3. ...
    (comp.unix.sco.misc)