Re: installation on FreeBSD

[Chris Travers <..hidden..>]

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.

Best Wishes,
Chris Travers