Topic: Installing Pervasive PSQL v9

[lional]

Hi
I have recently done a sme-server 7.3 installation. The client has one request. The are running pastel partner 2007, which runs off of a pervasive database. Is it possible to have the database running off of sme. There is a Linux installation for pervasive. I will include a link for this. I just need to know if it is possible and how does one do this. Will it be the same as Linux?

http://www.pervasive.com/library/docs/psql/950/sgs/sgs-17-2.html

Thanks

Lional

[warren]

Lional,

http://www.pervasive.com/library/docs/psql/950/sgs/sgs-17-3.html

shows that there is an RPM package.

As such, i would imagine you could download the RPM to eg /root/mycontribs/PSQL

Then run yum localinstall Pervasive.SQL-release-build.rpm  to cater for dependencies

[daniel]

I have been working on installing pervasive on linux without any easy degree of success.     What I do know is the Linux rpm sets up a samba share for PSQLData and I'm sure there will be several templating issues I haven't figured out yet.  I have loaded Pervasive in Suse 10 to start comparing install bases to SME. 

[cactus]

I have loaded Pervasive in Suse 10 to start comparing install bases to SME.

Do not do that using Suse as SME Server is based on CentOS, the two are very different, which effectively means once you have found out how to do it  using Suse, you will have to start the same project again to find out how it is done using CentOS (and SME Server).

[daniel]

Cactus,

I completely agree, what I meant by my statement was I needed to see Pervasive working on linux to see if it would do what I wanted.  Then I would work at putting it on SME so I would know what the end result would be.  For example, I didn't know pervasive made a samba share.  It shows up on Suse.  Now I need to make sure when its installed on SME that it shows up there as well.  With time and perseverance, I'll muddle through it somehow.

[lional]

I tried to install the rpm on sme, but it seems to have issues creating the user psql. I then manually created the user psql. It then complains that the home dir for psql is different from /usr/local/psql/bin. Is it possible to change the user directory for a specific user. I want to get the installation to run through correctly to see if it does want i want

[cactus]

I tried to install the rpm on sme, but it seems to have issues creating the user psql. I then manually created the user psql. It then complains that the home dir for psql is different from /usr/local/psql/bin. Is it possible to change the user directory for a specific user. I want to get the installation to run through correctly to see if it does want i want

Please state exact failure messages do not try to paraphrase, this makes it much harder to help investigating. Please post the exact steps you have done and the exact error message you are shown.

[lional]

I have the rpm on a cd. I am fairly new to sme so what I did was upload the rpm to my ftp site and then use wget to download the file. I then used rpm -i -vv and the package name to install it. the install seemed to go fine and then I got the following errors:
The install seems to go fine until it creates the psql user. I get an error message saying that the user psql could not be created due to a system limitation. Please reinstall the product. It then says that the script failed with an exit status 1
I then uninstalled the product and created the user psql manually on sme and reinstalled the product. When I got to the part where it creates the psql user it says that the user already exists and that the home dir for psql is different from /usr/local/psql/bin. I think it has a predefined home directory which is /usr/local/psql/bin and sme does not store the home directories in the same location

[cactus]

I have the rpm on a cd. I am fairly new to sme so what I did was upload the rpm to my ftp site and then use wget to download the file. I then used rpm -i -vv and the package name to install it.

You do not need to use rpm, you should use

Code: [Select]

yum localinstall /path/to/rpmYou might even just put the CD into your server and install it from CD using that command, no need to wget anything if you have physical access to your server.

the install seemed to go fine and then I got the following errors:
The install seems to go fine until it creates the psql user. I get an error message saying that the user psql could not be created due to a system limitation. Please reinstall the product. It then says that the script failed with an exit status 1

As I stated earlier:

Do no paraphrase, post the exact error message.

[lional]

When I run it without manually crewating the user I get the following error messages:
ERROR: The user psql could not be created due to a system limitation. Please re-install the product.
D: INDTALL: waitpid(23797) rc 23797 status 100 secs 18.132
ERROR: %POST(Pervasive.SQL-9.50-077.002.i486) scriptlet failed exit status 1

Then I manually install the user, uninstall the product and reinstall the product and I get:
An existing psql user is found
ERROR: Existing user psql has home dir another than /usr/local/psql/bin

These are the exact messages

Thanks

[cactus]

When I run it without manually crewating the user I get the following error messages:
ERROR: The user psql could not be created due to a system limitation. Please re-install the product.
D: INDTALL: waitpid(23797) rc 23797 status 100 secs 18.132
ERROR: %POST(Pervasive.SQL-9.50-077.002.i486) scriptlet failed exit status 1

Then I manually install the user, uninstall the product and reinstall the product and I get:
An existing psql user is found
ERROR: Existing user psql has home dir another than /usr/local/psql/bin

These are the exact messages

Thanks, it seems that the Pervasice SQL RPM expects a different system layout it will be hard to modify this without having the SRPM (source RPM) available, and I doubt if they will provide that.

Perhaps we can inspect the RPM and the post-install scripts to see what we can do, but unfortunately I do not have access to the PSQL RPM's. We might be able to manually change file locations and references to match the SME Server layout.

[lional]

I have the rpm that I installed from. Is tehre somewhere I can upload it to

[cactus]

I have the rpm that I installed from. Is tehre somewhere I can upload it to

Please contact me by e-mail for detail to upload it...

[william_syd]

Is there a 'correct way' to alter a users home directory in /etc/passwd ?

[lional]

I think that I have successfully installed pervasive. Once the client is live and I know for sure, I will post  it

[cactus]

Is there a 'correct way' to alter a users home directory in /etc/passwd ?

AFAIK this file is not templated and therefore you should be able to manually modify it with your favorite editor.

[cactus]

I think that I have successfully installed pervasive. Once the client is live and I know for sure, I will post  it

Please do so, but make sure you do it to the wiki (and post the link here for reference).

[RvLardin]

Hi,

lional, any news from you ?
What is the state of your project ?
Did you have some success ?
Can you give us some info about what you did ?

RV.

[lional]

Yes I have a live site running for about 3 months so I am now confident to submit the installation process. I will do this within the next couple of days

Thanks

Lional

[daniel]

Thanks for the work.  I had it working however once I did a post-upgrade it would erase the configurations.  I knew samba needed templated for the changes and the startup stuff.  Hadn't had that figured out yet.

What authentication service do you use to connect to the pervasive server to access data?  I wanted to use windows using the SME server as a domain, but it would not authenticate that way.  That was a secondary problem I had.

[lional]

The authentication service is where most of the work was done. We had to assign user rights and groups to pervasive manually.
I have documentation in pdf explaining the process which I can mail to you

[daniel]

Excellent.  I'll take a look at it...I appreciate your efforts.   
email to danielr@charton-mgmt.com   I'll look over it this week.  Also if you could, list your SME server version and config.  I like to compare apples to apples as much as possible on server developments.

[lional]

I discoverted a small problem with pervasive in that the service does not start automatically so we need to manually enter the command /etc/init.d/psql start is there a file where we can eneter this so that it will start automatically on startup

[warren]

Put file eg (psql ) in :

/etc/e-smith/events/local

contents of file will be something like :

#!/bin/sh
cd /etc/init.d
/usr/bin psql start

[Stefano]

Put file eg (psql ) in :

/etc/e-smith/events/local

contents of file will be something like :

#!/bin/sh
cd /etc/init.d
/usr/bin psql start

it's far better if you do:

Code: [Select]

config set psql service status enabled
cd /etc/rc7.d
ln -s /etc/rc.d/init.d/e-smith-service S99psql

in this way, psql will start automagically on every reboot, you can enable/disable it with

Code: [Select]

config setprop psql status enabled/disabled

and the command

Code: [Select]

service psql start/stop/restart/status
will work

HTH
Ciao
Stefano

[lional]

config set psql service status enabled

I can't get this to run. The problem I think that we have is that because Pervasive is written for Linux but we have had to make certain changes to make it work, the psql service if I remember correctly is enabled but doesn't start.
So we enter /etc/init.d/psql start.
Is there not a start up file that commands can be entered that will run at startup

[lional]

Thanks I got it to work

[Stefano]

Pervasive is written for Linux

well.. Sme IS linux

[lional]

Yes but if u read the forum there are a few issues with Pervasive on SME and it is not as smooth as it should be

[daniel]

My monthly Pervasive newsletter had an article about installing Pervasive 10.10 on Ubuntu linux.  They mentioned using the Tar and not the RPM for Ubuntu installation.   Maybe we need to do the same on the SME install.  Just a thought.

[lional]

The installation with the rpm works fine but it needs to be created in the following order:
1) create the pvsw group
2) create the psql user, assign them to the pvsw group and assign them to the /usr/local/psql/data user directory
3) install from the rpm
4) the services dont start so follow the post by nenonano

[zatnikatel]

I can't get this to run. The problem I think that we have is that because Pervasive is written for Linux but we have had to make certain changes to make it work, the psql service if I remember correctly is enabled but doesn't start.
So we enter /etc/init.d/psql start.
Is there not a start up file that commands can be entered that will run at startup

edit you /etc/rc.d/rc.local
and add the line /etc/init.d/psql start at the bottom

[daniel]

I've successfully set up Pervasive V10.12 on my SME test server.   Thanks to everyones notes I was able install and make it work successfully.

Notes on Installing Pervasive V10.12 on an SME 7.3 Stock server.

Prerequisites
1.   If you don't have smeserver-remoteuseraccess installed, please install it from the smecontribs repo.
2.   Download the Pervasive for Linux Core RPM and save to /root
3.   Set up /etc/fstab with acl on /dev/main/root by adding ,acl after grpquota
4.   Set SME server as a Domain Controller and workgroup server in the server manager workgroup panel.

Procedure
1.   Create the pvsw group using the server manager groups panel
2.   Create the psql user using the server manager users panel and assign to the pvsw group.  Add a password to the psql user, preferably 8 or more characters and following password compliancy.
3.   Using server manager user remote access panel, give use psql shell access of /bin/bash.  (I don't know how to do this via command prompt)
4.   Login to a shell using putty or login as root on the server
5.   mkdir /usr/local/psql
6.   mkdir /usr/local/psql/data
7.   chown psql:pvsw /usr/local/psql/data (this is the default location for Pervasive to set up SQL containers) 
8.   from the root prompt  yum localinstall Pervasive*.rpm (assuming Pervasive rpm is the only named rpm in your root directory)
9.   Let the RPM install as normal
10.   Start psql manually by /etc/init.d/psql start
11.   OPTIONAL:  If you want PSQL to start on server reboot, mcedit /etc/rc.d/rc.local and add
                   /etc/init.d/psql start
            on the last line of the rc.local file and save.
12.   Using the server manager panel reconfigure and reboot the server.

This installation assumes you have a windows workstation that will be using pervasive client or workgroup loaded.  For my application, I use the Pervasive V10.10 workgroup client.  Use the monitor program or the Pervasive control center to connect to the SME server.  Note: the default user for monitoring is admin with no password.  If you want PSQL to authenticate from the SME list of users, the authentication method has to be changed. (not sure the procedure to do this yet)  If things are installed properly you should be able to browse the DBs in Pervasive Control Center and login to the server.

In my case I use pervasive to manage the older style btrieve data files (microkernel).   I use an ibay to store the btrieve files in.  In order for the btrieve files to be accessed and written to, I have to use windows security and add the user psql with full rights to the directories in the Ibay.  I do this through a windows workstation logged in as admin.  Then through file and folder security properties I add psql user with full access for all child objects to the folders holding the btrieve files.  So far everything is working the way I want it to.  Haven't tested it with my SME 8.0 beta server, yet.

[cactus]

3.   Using server manager user remote access panel, give use psql shell access of /bin/bash.  (I don't know how to do this via command prompt)

Code: [Select]

db accounts setprop username Shell /bin/bash
signal-event user-modify username