Topic: Installing Pervasive PSQL v9

[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