Topic: Installing Pervasive PSQL v9

[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.