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