[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: installation on FreeBSD

On 06.12.2011 15:56, Chris Travers wrote:

If that fails, please email me the following logs from /tmp/ledgersmb:
dblog, dblog_stderr, dblog_stdout.

On Tue, Dec 6, 2011 at 5:55 AM, Chris Travers<..hidden..>  wrote:

On Tue, Dec 6, 2011 at 5:38 AM, Silver Salonen<..hidden..>  wrote:

On 06.12.2011 15:00, David A. Bandel wrote:

On Tue, Dec 6, 2011 at 07:53, Silver Salonen<..hidden..>    wrote:

On 06.12.2011 14:44, Chris Travers wrote:

On Tue, Dec 6, 2011 at 4:40 AM, David A. Bandel<..hidden..>      wrote:

On Tue, Dec 6, 2011 at 07:37, Silver Salonen<..hidden..>      wrote:

On 06.12.2011 14:14, Chris Travers wrote:

On Tue, Dec 6, 2011 at 3:55 AM, Silver Salonen<..hidden..>        wrote:

Hello.

I THINK I've successfully installed LedgerSMB 1.3.7 on FreeBSD and I've
setup a new Postgres user 'ledgersmb' with role createdb.

When I try creating the database via /setup.pl, I get:


I am guessing something is missing.

Can you try locating tablefunc.sql and making sure you are pointing at
it in the ledgersmb.conf?

It cannot be found indeed. I'm also missing the pgsql contrib directory.

which version of PostgreSQL?

David has a good point.  If it's 9.1 you need the extensions
directories instead (look for tablefunc* in your filesystem).

PostgreSQL is 9.0.4. I don't find anything about tablefunc* (locate -i
tablefunc).


You are probably missing the contribs for postgres.  They are required.

So, installed databases/postgresql90-contrib, set "contrib_dir =
/usr/local/share/postgresql/contrib/", restarted both PostgreSQL and
Apache, but I still get the error.

Anything else to check?


Check the ledgersmb.conf to make sure it is pointing at the directory
where the tablefunc.sql is located.


$ ls -l /usr/local/share/postgresql/contrib/tablefunc.sql
-rw-r--r-- 1 root wheel 2306 Dec 6 15:14 /usr/local/share/postgresql/contrib/tablefunc.sql 

I'll send the log-files right away.

--
Silver