Haven't tested it with my SME 8.0 beta server, yet. So far everything is working the way I want it to. 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. I do this through a windows workstation logged in as admin. 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 use an ibay to store the btrieve files in. In my case I use pervasive to manage the older style btrieve data files (microkernel). (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. If you want PSQL to authenticate from the SME list of users, the authentication method has to be changed. Note: the default user for monitoring is admin with no password. Use the monitor program or the Pervasive control center to connect to the SME server. For my application, I use the Pervasive V10.10 workgroup client. This installation assumes you have a windows workstation that will be using pervasive client or workgroup loaded. This PC program was developed to work on Windows XP, Windows Vista, Windows 7, Windows 8 or Windows 10 and can function on 32-bit systems. The most popular versions among the software users are 11.1 and 11.0. Using the server manager panel reconfigure and reboot the server. Pervasive.SQL 11.10.21 is free to download from our software library. On the last line of the rc.local file and save.ġ2. OPTIONAL: If you want PSQL to start on server reboot, mcedit /etc/rc.d/rc.local and add Start psql manually by /etc/init.d/psql startġ1. from the root prompt yum localinstall Pervasive*.rpm (assuming Pervasive rpm is the only named rpm in your root directory)ġ0. chown psql:pvsw /usr/local/psql/data (this is the default location for Pervasive to set up SQL containers)Ĩ. Login to a shell using putty or login as root on the serverħ.
#PERVASIVE PSQL HOW TO#
(I don't know how to do this via command prompt)Ĥ. Using server manager user remote access panel, give use psql shell access of /bin/bash. Add a password to the psql user, preferably 8 or more characters and following password compliancy.ģ. Create the psql user using the server manager users panel and assign to the pvsw group. Actian PSQL v13 Server (32 bit / 64 bit) - (ActianPSQLServerEnginev13. Important Step: Prior to installing a later version of Pervasive/Actian, it is highly advised to uninstall the prior version of Pervasive/Actian through Control Panel.
#PERVASIVE PSQL UPDATE#
Create the pvsw group using the server manager groups panelĢ. Download your specific installation below to update to Actian PSQL v13. Set SME server as a Domain Controller and workgroup server in the server manager workgroup panel.ġ. Set up /etc/fstab with acl on /dev/main/root by adding ,acl after grpquotaĤ. Download the Pervasive for Linux Core RPM and save to /rootģ.
#PERVASIVE PSQL INSTALL#
If you don't have smeserver-remoteuseraccess installed, please install it from the smecontribs repo.Ģ. Notes on Installing Pervasive V10.12 on an SME 7.3 Stock server.ġ. Thanks to everyones notes I was able install and make it work successfully. I've successfully set up Pervasive V10.12 on my SME test server.
0 kommentar(er)
