Topic: Pervasive SQL Client

[p-jones]

Anyone out there in Guru land had any experience installing the Pervasive Linux SQL Engine ??

Would welcome any comments / gotcha's in installing it on SME6.01

Thanks
Peter

[dilligaf]

Yes,
I have it installed on three linux servers 6.0.1 it is rock solid stable.
The big issue you will have, is the symlinks to start mkded and slqmgr end up being installed in /etc/rc.d/rc5.d.
So it never starts.
What I do is copy the pervasive installer created @S92psql from /etc/rc.d/rc5.d
to /etc/rc.d/rc7.d
Rebooted and ps -e shows sqlmgr and mkded running.

[p-jones]

Thanks for that. I went ahead and gave it a crack and used a script that I downloaded.

Didnt have the issue you described. It copied to /etc/rc.d/init.d and I started it from rc.local.
Can also stop-start-restart from # prompt with psql restart etc.

How did you overcome the Samba shares it likes to have in usr/local/psql/data or maybe you used a different approach ?


Cheers
Peter

[dilligaf]

Yes,
I have it installed on three linux servers 6.0.1 it is rock solid stable.
The big issue you will have, is the symlinks to start mkded and slqmgr end up being installed in /etc/rc.d/rc5.d.
So it never starts.
What I do is copy the pervasive installer created @S92psql from /etc/rc.d/rc5.d
to /etc/rc.d/rc7.d
Rebooted and ps -e shows sqlmgr and mkded running.

Further to this is the following problem all of the sudden, out of the blue...
I have an extremely weird thing happening all of a sudden.

Using the Pervasive.SQL-8.60-192.032.i486.rpm (which I have used lots before...)
All of a sudden on two test servers today:
6.0.1 and 7.X I get the following when installing the rpm.

+++++ Setting up group and admgroup...
Creating group pvsw...
groupadd: gid 5000 is not unique
Creating group pvsw-adm...
groupadd: gid 5001 is not unique

+++++ Setting up user psql...
Creating user psql, this may take a while...
ERROR: The user psql could not be created due to a system limitation. Please reinstall the product.
[root@centosserver etc]#
Can any one help?

[dilligaf]

Yes,
I have it installed on three linux servers 6.0.1 it is rock solid stable.
The big issue you will have, is the symlinks to start mkded and slqmgr end up being installed in /etc/rc.d/rc5.d.
So it never starts.
What I do is copy the pervasive installer created @S92psql from /etc/rc.d/rc5.d
to /etc/rc.d/rc7.d
Rebooted and ps -e shows sqlmgr and mkded running.

Further to this is the following problem all of the sudden, out of the blue...
I have an extremely weird thing happening all of a sudden.

Using the Pervasive.SQL-8.60-192.032.i486.rpm (which I have used lots before...)
All of a sudden on two test servers today:
6.0.1 and 7.X I get the following when installing the rpm.

+++++ Setting up group and admgroup...
Creating group pvsw...
groupadd: gid 5000 is not unique
Creating group pvsw-adm...
groupadd: gid 5001 is not unique

+++++ Setting up user psql...
Creating user psql, this may take a while...
ERROR: The user psql could not be created due to a system limitation. Please reinstall the product.
[root@centosserver etc]#
Can any one help?

What I found is, in /etc/group an ibay and an user were already using the 5000 and 5001 id's.
I removed the user and ibay as a test, and the Pervasive installed.
Not a good fix though...

[dilligaf]

Yes,
I have it installed on three linux servers 6.0.1 it is rock solid stable.
The big issue you will have, is the symlinks to start mkded and slqmgr end up being installed in /etc/rc.d/rc5.d.
So it never starts.
What I do is copy the pervasive installer created @S92psql from /etc/rc.d/rc5.d
to /etc/rc.d/rc7.d
Rebooted and ps -e shows sqlmgr and mkded running.

Further to this is the following problem all of the sudden, out of the blue...
I have an extremely weird thing happening all of a sudden.

Using the Pervasive.SQL-8.60-192.032.i486.rpm (which I have used lots before...)
All of a sudden on two test servers today:
6.0.1 and 7.X I get the following when installing the rpm.

+++++ Setting up group and admgroup...
Creating group pvsw...
groupadd: gid 5000 is not unique
Creating group pvsw-adm...
groupadd: gid 5001 is not unique

+++++ Setting up user psql...
Creating user psql, this may take a while...
ERROR: The user psql could not be created due to a system limitation. Please reinstall the product.
[root@centosserver etc]#
Can any one help?

What I found is, in /etc/group an ibay and an user were already using the 5000 and 5001 id's.
I removed the user and ibay as a test, and the Pervasive installed.
Not a good fix though...

I found the root of it all:
Once the Pervasive RPM extracts it calls a postinstall.sh script, and in there is the following snippet:
else
        PS=/bin/ps
        PSPARAMS=ax
        SEM=sem
        MEM=shm
        ECHO=/bin/echo
        GRPFLAG="-g 5000"
        ADMGRPFLAG="-g 5001"

Can any one tell me if I change the 5000 and 5001 in there script, is there a guideline to what I should use?
Or should I just look in /etc/group and pick the next highest incrent values?

[p-jones]

I know it is rather bit dirty, but I just took the next number and I added both the user and the group manually. (to /etc/user and /etc/group)and just blanked out that part of the script.

So far, it has not come back to haunt me and I have since thrashed the test server I violated in this way.

HTH
Peter

[p-jones]

Perhaps I should also add that the error "ERROR: The user psql could not be created due to a system limitation. Please reinstall the product." dissapeared after I did this.

The only issue I need to resolve is the location of the psqldata folder. That is simply a matter of application on my part. To date it has been as you initially described - rock solid.

P