Re: [Ledger-smb-users] Problems with upgrade from 1.2.x to current version
On 30. jan. 2012 12:02, Linda Ursin wrote: > What should I do? Do you try to login with the Postgres superuser and the correct database name and password ? Can you try to test the login to the db with psql ? What about the FAQ : I can't login http://www.ledgersmb.org/node/27 Login to several companies with one user? http://www.ledgersmb.org/node/468533 Mvh Håvard Sørli Anix.no - Tlf. +47 90 92 11 22 -- Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] Problems with upgrade from 1.2.x to current version
Yes, I have the correct user and password. I can login through psql. Using trust didn't work for setup.pl When I try the tip from the FAQ, I get postgres=# ALTER USER 'postgres' WITH VALID UNTIL '2013-11-09'; ERROR: syntax error at or near "'postgres'" LINE 1: ALTER USER 'postgres' WITH VALID UNTIL '2013-11-09'; I only have one company. Linda ~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~ Linda Ursin Heksebua Adresse: Tlf: (+47) 402 40 767 Solvangwww: http://heksebua.com 7288 Soknedal E-post: li...@heksebua.com Org: NO 995 578 107 On Tue, Jan 31, 2012 at 1:38 PM, Håvard Sørli wrote: > On 30. jan. 2012 12:02, Linda Ursin wrote: > > What should I do? > > Do you try to login with the Postgres superuser and the correct database > name and password ? > > Can you try to test the login to the db with psql ? > > What about the FAQ : > > I can't login > http://www.ledgersmb.org/node/27 > > Login to several companies with one user? > http://www.ledgersmb.org/node/468533 > > Mvh > > Håvard Sørli > Anix.no - Tlf. +47 90 92 11 22 > > > > -- > Keep Your Developer Skills Current with LearnDevNow! > The most comprehensive online learning library for Microsoft developers > is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, > Metro Style Apps, more. Free future releases when you subscribe now! > http://p.sf.net/sfu/learndevnow-d2d > ___ > Ledger-smb-users mailing list > Ledger-smb-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users > -- Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] Problems with upgrade from 1.2.x to current version
On Tue, Jan 31, 2012 at 5:08 AM, Linda Ursin wrote: > Yes, I have the correct user and password. > > I can login through psql. > > Using trust didn't work for setup.pl > > When I try the tip from the FAQ, I get > Please check your web server error logs and attach relevant entries. My guess, if you can log in using psql (with -h localhost) is that the problem is that the mod_rewrite stuff for 1.3 has not been set up and so LedgerSMB is not getting the username and password. I would look at the ledgersmb-httpd.conf.template for 1.3 and either preprocess/copy over the old one (and restart Apache) or copy the relevant directives into the appropriate configuration file. > > postgres=# ALTER USER 'postgres' WITH VALID UNTIL '2013-11-09'; > ERROR: syntax error at or near "'postgres'" > LINE 1: ALTER USER 'postgres' WITH VALID UNTIL '2013-11-09'; > Double quote identifiers. ALTER USER "postgres". > > I only have one company. > > > Linda > > ~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~ > > Linda Ursin > Heksebua > > Adresse: Tlf: (+47) 402 40 767 > Solvangwww: http://heksebua.com > 7288 Soknedal E-post: li...@heksebua.com > > Org: NO 995 578 107 > > > On Tue, Jan 31, 2012 at 1:38 PM, Håvard Sørli wrote: > >> On 30. jan. 2012 12:02, Linda Ursin wrote: >> > What should I do? >> >> Do you try to login with the Postgres superuser and the correct database >> name and password ? >> >> Can you try to test the login to the db with psql ? >> >> What about the FAQ : >> >> I can't login >> http://www.ledgersmb.org/node/27 >> >> Login to several companies with one user? >> http://www.ledgersmb.org/node/468533 >> >> Mvh >> >> Håvard Sørli >> Anix.no - Tlf. +47 90 92 11 22 >> >> >> >> -- >> Keep Your Developer Skills Current with LearnDevNow! >> The most comprehensive online learning library for Microsoft developers >> is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, >> Metro Style Apps, more. Free future releases when you subscribe now! >> http://p.sf.net/sfu/learndevnow-d2d >> ___ >> Ledger-smb-users mailing list >> Ledger-smb-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users >> > > > > -- > Keep Your Developer Skills Current with LearnDevNow! > The most comprehensive online learning library for Microsoft developers > is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, > Metro Style Apps, more. Free future releases when you subscribe now! > http://p.sf.net/sfu/learndevnow-d2d > ___ > Ledger-smb-users mailing list > Ledger-smb-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users > > -- Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] Problems with upgrade from 1.2.x to current version
ALTER USER "postgres" WITH VALID UNTIL '2013-11-09'; didn't help, even if
the command worked.
If I was still using the old ledgersmb confiuration for apache, my
installation would be available through http:///regnskap/
but it isn't, it's aat http://.../ledgersmb/
lur:/home/lur# more /etc/apache2/conf.d/ledgersmb-httpd.conf
# This file must be edited to substitute the current path with
/usr/share/ledger
smb
Alias /ledgersmb /usr/share/ledgersmb/
# Rewrite rule to allow HTTP Authorization information to the scripts only
# from this directory.
RewriteEngine On
# Redirect the /ledgersmb and /ledgersmb/ URL paths to
# the true login script: /ledgersmb/login.pl
RewriteRule ^/ledgersmb/?$ /ledgersmb/login.pl [R]
# Indicate that the HTTP Authorization data should be passed
# to the CGI scripts running from this directory
RewriteRule .* - [E=HTTP_AUTHORIZATION:%{HTTP:Authorization},L]
AllowOverride All
AddHandler cgi-script .pl
Options ExecCGI Includes FollowSymlinks
# By default, only allow from localhost. If you change this, please be
# advised that you should use SSL protection on any and all network
# connections that access this application in order to protect usernames
and
# passwords.
Order Deny,Allow
Allow from 127.0.0.1
Allow from localhost
Allow from 193.69.154.79
Deny from All
# The rest of this file just tightens up security.
Order Deny,Allow
Deny from All
Order Deny,Allow
Deny from All
Order Deny,Allow
Deny from All
Order Deny,Allow
Deny from All
Order Deny,Allow
Deny from All
Order Deny,Allow
Deny from All
Order Deny,Allow
Deny from All
I find the same file in /etc/apache/conf.d/, /etc/ledgersmb/ and
/usr/share/ledgersmb. But they all say the same.
For clarification, I was using 1.2.21, and upgrading from 1.2.17 to that
worked fine.
Linda
Linda
~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~
Linda Ursin
Heksebua
Adresse: Tlf: (+47) 402 40 767
Solvangwww: http://heksebua.com
7288 Soknedal E-post: li...@heksebua.com
Org: NO 995 578 107
On Tue, Jan 31, 2012 at 2:51 PM, Chris Travers wrote:
>
>
> On Tue, Jan 31, 2012 at 5:08 AM, Linda Ursin wrote:
>
>> Yes, I have the correct user and password.
>>
>> I can login through psql.
>>
>> Using trust didn't work for setup.pl
>>
>> When I try the tip from the FAQ, I get
>>
>
> Please check your web server error logs and attach relevant entries.
>
> My guess, if you can log in using psql (with -h localhost) is that the
> problem is that the mod_rewrite stuff for 1.3 has not been set up and so
> LedgerSMB is not getting the username and password. I would look at the
> ledgersmb-httpd.conf.template for 1.3 and either preprocess/copy over the
> old one (and restart Apache) or copy the relevant directives into the
> appropriate configuration file.
>
>
>>
>> postgres=# ALTER USER 'postgres' WITH VALID UNTIL '2013-11-09';
>> ERROR: syntax error at or near "'postgres'"
>> LINE 1: ALTER USER 'postgres' WITH VALID UNTIL '2013-11-09';
>>
>
> Double quote identifiers. ALTER USER "postgres".
>
>
>>
>> I only have one company.
>>
>>
>> Linda
>>
>> ~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~
>>
>> Linda Ursin
>> Heksebua
>>
>> Adresse: Tlf: (+47) 402 40 767
>> Solvangwww: http://heksebua.com
>> 7288 Soknedal E-post: li...@heksebua.com
>>
>> Org: NO 995 578 107
>>
>>
>> On Tue, Jan 31, 2012 at 1:38 PM, Håvard Sørli wrote:
>>
>>> On 30. jan. 2012 12:02, Linda Ursin wrote:
>>> > What should I do?
>>>
>>> Do you try to login with the Postgres superuser and the correct database
>>> name and password ?
>>>
>>> Can you try to test the login to the db with psql ?
>>>
>>> What about the FAQ :
>>>
>>> I can't login
>>> http://www.ledgersmb.org/node/27
>>>
>>> Login to several companies with one user?
>>> http://www.ledgersmb.org/node/468533
>>>
>>> Mvh
>>>
>>> Håvard Sørli
>>> Anix.no - Tlf. +47 90 92 11 22
>>>
>>>
>>>
>>> --
>>> Keep Your Developer Skills Current with LearnDevNow!
>>> The most comprehensive online learning library for Microsoft developers
>>> is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
>>> Metro Style Apps, more. Free future releases when you subscribe now!
>>> http://p.sf.net/sfu/learndevnow-d2d
>>> ___
>>> Ledger-smb-users mailing list
>>> Ledger-smb-users@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>>>
>>
>>
>>
>> --
>> Keep Your Developer Skills Current with LearnDevNow!
>> The most comprehensive online learning library for Microsoft developers
>> is just $9
Re: [Ledger-smb-users] Problems with upgrade from 1.2.x to current version
On Tue, Jan 31, 2012 at 6:10 AM, Linda Ursin wrote: > ALTER USER "postgres" WITH VALID UNTIL '2013-11-09'; didn't help, even if > the command worked. > > If I was still using the old ledgersmb confiuration for apache, my > installation would be available through http:///regnskap/ > but it isn't, it's aat http://.../ledgersmb/ > Ok, so ruling that out. can you check your httpd error logs and see what it prints when it gives the auth dialog? Best Wishes, Chris Travers -- Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] Problems with upgrade from 1.2.x to current version
[Tue Jan 31 15:42:15 2012] [error] [client 193.69.154.79] DBI
connect('dbname=template1','postgres',...) failed: FATAL: Ident
authentication failed for user "postgres" at LedgerSMB.pm line 982,
referer: http://lur.aitel.hist.no/ledgersmb/setup.pl
~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~
Linda Ursin
Heksebua
Adresse: Tlf: (+47) 402 40 767
Solvangwww: http://heksebua.com
7288 Soknedal E-post: li...@heksebua.com
Org: NO 995 578 107
On Tue, Jan 31, 2012 at 3:22 PM, Chris Travers wrote:
>
>
> On Tue, Jan 31, 2012 at 6:10 AM, Linda Ursin wrote:
>
>> ALTER USER "postgres" WITH VALID UNTIL '2013-11-09'; didn't help, even if
>> the command worked.
>>
>> If I was still using the old ledgersmb confiuration for apache, my
>> installation would be available through http:///regnskap/
>> but it isn't, it's aat http://.../ledgersmb/
>>
>
> Ok, so ruling that out.
>
> can you check your httpd error logs and see what it prints when it gives
> the auth dialog?
>
> Best Wishes,
> Chris Travers
>
>
> --
> Keep Your Developer Skills Current with LearnDevNow!
> The most comprehensive online learning library for Microsoft developers
> is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
> Metro Style Apps, more. Free future releases when you subscribe now!
> http://p.sf.net/sfu/learndevnow-d2d
> ___
> Ledger-smb-users mailing list
> Ledger-smb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>
>
--
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d___
Ledger-smb-users mailing list
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] Problems with upgrade from 1.2.x to current version
I don't know why it says dbname template1, because I gave the dbname
heksebua
~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~
Linda Ursin
Heksebua
Adresse: Tlf: (+47) 402 40 767
Solvangwww: http://heksebua.com
7288 Soknedal E-post: li...@heksebua.com
Org: NO 995 578 107
On Tue, Jan 31, 2012 at 3:26 PM, Linda Ursin wrote:
> [Tue Jan 31 15:42:15 2012] [error] [client 193.69.154.79] DBI
> connect('dbname=template1','postgres',...) failed: FATAL: Ident
> authentication failed for user "postgres" at LedgerSMB.pm line 982,
> referer: http://lur.aitel.hist.no/ledgersmb/setup.pl
>
>
>
> ~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~
>
> Linda Ursin
> Heksebua
>
> Adresse: Tlf: (+47) 402 40 767
> Solvangwww: http://heksebua.com
> 7288 Soknedal E-post: li...@heksebua.com
>
> Org: NO 995 578 107
>
>
> On Tue, Jan 31, 2012 at 3:22 PM, Chris Travers wrote:
>
>>
>>
>> On Tue, Jan 31, 2012 at 6:10 AM, Linda Ursin wrote:
>>
>>> ALTER USER "postgres" WITH VALID UNTIL '2013-11-09'; didn't help, even
>>> if the command worked.
>>>
>>> If I was still using the old ledgersmb confiuration for apache, my
>>> installation would be available through http:///regnskap/
>>> but it isn't, it's aat http://.../ledgersmb/
>>>
>>
>> Ok, so ruling that out.
>>
>> can you check your httpd error logs and see what it prints when it gives
>> the auth dialog?
>>
>> Best Wishes,
>> Chris Travers
>>
>>
>> --
>> Keep Your Developer Skills Current with LearnDevNow!
>> The most comprehensive online learning library for Microsoft developers
>> is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
>> Metro Style Apps, more. Free future releases when you subscribe now!
>> http://p.sf.net/sfu/learndevnow-d2d
>> ___
>> Ledger-smb-users mailing list
>> Ledger-smb-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>>
>>
>
--
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d___
Ledger-smb-users mailing list
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] Problems with upgrade from 1.2.x to current version
On Tue, Jan 31, 2012 at 6:26 AM, Linda Ursin wrote:
> [Tue Jan 31 15:42:15 2012] [error] [client 193.69.154.79] DBI
> connect('dbname=template1','postgres',...) failed: FATAL: Ident
> authentication failed for user "postgres" at LedgerSMB.pm line 982,
> referer: http://lur.aitel.hist.no/ledgersmb/setup.pl
You have a bad line in your pg_hba.conf
Best Wishes,
Chris Travers
>
>
>
> ~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~
>
> Linda Ursin
> Heksebua
>
> Adresse: Tlf: (+47) 402 40 767
> Solvangwww: http://heksebua.com
> 7288 Soknedal E-post: li...@heksebua.com
>
> Org: NO 995 578 107
>
>
> On Tue, Jan 31, 2012 at 3:22 PM, Chris Travers wrote:
>
>>
>>
>> On Tue, Jan 31, 2012 at 6:10 AM, Linda Ursin wrote:
>>
>>> ALTER USER "postgres" WITH VALID UNTIL '2013-11-09'; didn't help, even
>>> if the command worked.
>>>
>>> If I was still using the old ledgersmb confiuration for apache, my
>>> installation would be available through http:///regnskap/
>>> but it isn't, it's aat http://.../ledgersmb/
>>>
>>
>> Ok, so ruling that out.
>>
>> can you check your httpd error logs and see what it prints when it gives
>> the auth dialog?
>>
>> Best Wishes,
>> Chris Travers
>>
>>
>> --
>> Keep Your Developer Skills Current with LearnDevNow!
>> The most comprehensive online learning library for Microsoft developers
>> is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
>> Metro Style Apps, more. Free future releases when you subscribe now!
>> http://p.sf.net/sfu/learndevnow-d2d
>> ___
>> Ledger-smb-users mailing list
>> Ledger-smb-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>>
>>
>
>
> --
> Keep Your Developer Skills Current with LearnDevNow!
> The most comprehensive online learning library for Microsoft developers
> is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
> Metro Style Apps, more. Free future releases when you subscribe now!
> http://p.sf.net/sfu/learndevnow-d2d
> ___
> Ledger-smb-users mailing list
> Ledger-smb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>
>
--
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d___
Ledger-smb-users mailing list
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] Problems with upgrade from 1.2.x to current version
How is that possible when I haven't changed it? ( I changed it back to
default after trying trust)
This is what it looks like:
-
# Database administrative login by UNIX sockets
local all postgres ident
local ledgersmb ledgersmb md5
# TYPE DATABASEUSERCIDR-ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all ident
# IPv4 local connections:
hostall all 127.0.0.1/32 md5
# IPv6 local connections:
hostall all ::1/128 md5
-
The rest is commented out.
Linda
~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~
Linda Ursin
Heksebua
Adresse: Tlf: (+47) 402 40 767
Solvangwww: http://heksebua.com
7288 Soknedal E-post: li...@heksebua.com
Org: NO 995 578 107
On Tue, Jan 31, 2012 at 3:53 PM, Chris Travers wrote:
>
>
> On Tue, Jan 31, 2012 at 6:26 AM, Linda Ursin wrote:
>
>> [Tue Jan 31 15:42:15 2012] [error] [client 193.69.154.79] DBI
>> connect('dbname=template1','postgres',...) failed: FATAL: Ident
>> authentication failed for user "postgres" at LedgerSMB.pm line 982,
>> referer: http://lur.aitel.hist.no/ledgersmb/setup.pl
>
>
> You have a bad line in your pg_hba.conf
>
> Best Wishes,
> Chris Travers
>
>
>>
>>
>>
>> ~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~
>>
>> Linda Ursin
>> Heksebua
>>
>> Adresse: Tlf: (+47) 402 40 767
>> Solvangwww: http://heksebua.com
>> 7288 Soknedal E-post: li...@heksebua.com
>>
>> Org: NO 995 578 107
>>
>>
>> On Tue, Jan 31, 2012 at 3:22 PM, Chris Travers
>> wrote:
>>
>>>
>>>
>>> On Tue, Jan 31, 2012 at 6:10 AM, Linda Ursin wrote:
>>>
ALTER USER "postgres" WITH VALID UNTIL '2013-11-09'; didn't help, even
if the command worked.
If I was still using the old ledgersmb confiuration for apache, my
installation would be available through http:///regnskap/
but it isn't, it's aat http://.../ledgersmb/
>>>
>>> Ok, so ruling that out.
>>>
>>> can you check your httpd error logs and see what it prints when it gives
>>> the auth dialog?
>>>
>>> Best Wishes,
>>> Chris Travers
>>>
>>>
>>> --
>>> Keep Your Developer Skills Current with LearnDevNow!
>>> The most comprehensive online learning library for Microsoft developers
>>> is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
>>> Metro Style Apps, more. Free future releases when you subscribe now!
>>> http://p.sf.net/sfu/learndevnow-d2d
>>> ___
>>> Ledger-smb-users mailing list
>>> Ledger-smb-users@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>>>
>>>
>>
>>
>> --
>> Keep Your Developer Skills Current with LearnDevNow!
>> The most comprehensive online learning library for Microsoft developers
>> is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
>> Metro Style Apps, more. Free future releases when you subscribe now!
>> http://p.sf.net/sfu/learndevnow-d2d
>> ___
>> Ledger-smb-users mailing list
>> Ledger-smb-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>>
>>
>
>
> --
> Keep Your Developer Skills Current with LearnDevNow!
> The most comprehensive online learning library for Microsoft developers
> is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
> Metro Style Apps, more. Free future releases when you subscribe now!
> http://p.sf.net/sfu/learndevnow-d2d
> ___
> Ledger-smb-users mailing list
> Ledger-smb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>
>
--
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d___
Ledger-smb-users mailing list
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] Problems with upgrade from 1.2.x to current version
Of course, you have to at least tell PostgreSQL to reload the config files after making the change, but I find restarting is more reliable. Best Wishes, Chris Travers -- Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] Problems with upgrade from 1.2.x to current version
On Tue, Jan 31, 2012 at 7:01 AM, Linda Ursin wrote:
> How is that possible when I haven't changed it? ( I changed it back to
> default after trying trust)
>
1.3 handles things a bit differently, security-wise, so it isn't entirely
surprising that some configurations that worked with 1.2 are not working
with 1.3.
>
> This is what it looks like:
>
> -
> # Database administrative login by UNIX sockets
> local all postgres ident
> local ledgersmb ledgersmb md5
Try changing hte above two lines to:
localledgersmball md5
localallpostgres md5
# TYPE DATABASEUSERCIDR-ADDRESS METHOD
>
> # "local" is for Unix domain socket connections only
> local all all ident.
# IPv4 local connections:
> hostall all 127.0.0.1/32 md5
>
> # IPv6 local connections:
> hostall all ::1/128 md5
>
> -
>
> The rest is commented out.
>
> Linda
>
>
>
> ~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~
>
> Linda Ursin
> Heksebua
>
> Adresse: Tlf: (+47) 402 40 767
> Solvangwww: http://heksebua.com
> 7288 Soknedal E-post: li...@heksebua.com
>
> Org: NO 995 578 107
>
>
> On Tue, Jan 31, 2012 at 3:53 PM, Chris Travers wrote:
>
>>
>>
>> On Tue, Jan 31, 2012 at 6:26 AM, Linda Ursin wrote:
>>
>>> [Tue Jan 31 15:42:15 2012] [error] [client 193.69.154.79] DBI
>>> connect('dbname=template1','postgres',...) failed: FATAL: Ident
>>> authentication failed for user "postgres" at LedgerSMB.pm line 982,
>>> referer: http://lur.aitel.hist.no/ledgersmb/setup.pl
>>
>>
>> You have a bad line in your pg_hba.conf
>>
>> Best Wishes,
>> Chris Travers
>>
>>
>>>
>>>
>>>
>>> ~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~
>>>
>>> Linda Ursin
>>> Heksebua
>>>
>>> Adresse: Tlf: (+47) 402 40 767
>>> Solvangwww: http://heksebua.com
>>> 7288 Soknedal E-post: li...@heksebua.com
>>>
>>> Org: NO 995 578 107
>>>
>>>
>>> On Tue, Jan 31, 2012 at 3:22 PM, Chris Travers
>>> wrote:
>>>
On Tue, Jan 31, 2012 at 6:10 AM, Linda Ursin wrote:
> ALTER USER "postgres" WITH VALID UNTIL '2013-11-09'; didn't help, even
> if the command worked.
>
> If I was still using the old ledgersmb confiuration for apache, my
> installation would be available through http:///regnskap/
> but it isn't, it's aat http://.../ledgersmb/
>
Ok, so ruling that out.
can you check your httpd error logs and see what it prints when it
gives the auth dialog?
Best Wishes,
Chris Travers
--
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
___
Ledger-smb-users mailing list
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>>>
>>>
>>> --
>>> Keep Your Developer Skills Current with LearnDevNow!
>>> The most comprehensive online learning library for Microsoft developers
>>> is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
>>> Metro Style Apps, more. Free future releases when you subscribe now!
>>> http://p.sf.net/sfu/learndevnow-d2d
>>> ___
>>> Ledger-smb-users mailing list
>>> Ledger-smb-users@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>>>
>>>
>>
>>
>> --
>> Keep Your Developer Skills Current with LearnDevNow!
>> The most comprehensive online learning library for Microsoft developers
>> is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
>> Metro Style Apps, more. Free future releases when you subscribe now!
>> http://p.sf.net/sfu/learndevnow-d2d
>> ___
>> Ledger-smb-users mailing list
>> Ledger-smb-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>>
>>
>
>
> --
> Keep Your Developer Skills Current with LearnDevNow!
> The most comprehensive online learning library for Microsoft developers
> is just $99.99! Visual Studio, SharePoin
Re: [Ledger-smb-users] Problems with upgrade from 1.2.x to current version
On 31. jan. 2012 15:28, Linda Ursin wrote:
> I don't know why it says dbname template1, because I gave the dbname
> heksebua
> ~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~
Could it be that user postgres is a db "superuser" and the user info is
stored in template1 ?
> [Tue Jan 31 15:42:15 2012] [error] [client 193.69.154.79] DBI
> connect('dbname=template1','postgres',...) failed: FATAL: Ident
> authentication failed for user "postgres" at LedgerSMB.pm line 982,
> referer: http://lur.aitel.hist.no/ledgersmb/setup.pl
Could you try to change your pg_hba.conf file ?
http://www.postgresql.org/docs/8.3/static/auth-pg-hba-conf.html
Or post it ??
H
--
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
___
Ledger-smb-users mailing list
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] Problems with upgrade from 1.2.x to current version
It's the default configuration. I haven't touched it. What should be there
that isn't?
Linda
~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~
Linda Ursin
Heksebua
Adresse: Tlf: (+47) 402 40 767
Solvangwww: http://heksebua.com
7288 Soknedal E-post: li...@heksebua.com
Org: NO 995 578 107
On Tue, Jan 31, 2012 at 4:13 PM, Chris Travers wrote:
>
>
> On Tue, Jan 31, 2012 at 7:01 AM, Linda Ursin wrote:
>
>> How is that possible when I haven't changed it? ( I changed it back to
>> default after trying trust)
>>
>
> 1.3 handles things a bit differently, security-wise, so it isn't entirely
> surprising that some configurations that worked with 1.2 are not working
> with 1.3.
>
>
>>
>> This is what it looks like:
>>
>> -
>> # Database administrative login by UNIX sockets
>> local all postgres ident
>
>
>
>> local ledgersmb ledgersmb md5
>
>
>
> Try changing hte above two lines to:
> localledgersmball md5
> localallpostgres md5
>
>
> # TYPE DATABASEUSERCIDR-ADDRESS METHOD
>>
>> # "local" is for Unix domain socket connections only
>> local all all ident.
>
> # IPv4 local connections:
>> hostall all 127.0.0.1/32 md5
>>
>
>
>
>> # IPv6 local connections:
>> hostall all ::1/128 md5
>>
>> -
>>
>> The rest is commented out.
>>
>> Linda
>>
>>
>>
>> ~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~
>>
>> Linda Ursin
>> Heksebua
>>
>> Adresse: Tlf: (+47) 402 40 767
>> Solvangwww: http://heksebua.com
>> 7288 Soknedal E-post: li...@heksebua.com
>>
>> Org: NO 995 578 107
>>
>>
>> On Tue, Jan 31, 2012 at 3:53 PM, Chris Travers
>> wrote:
>>
>>>
>>>
>>> On Tue, Jan 31, 2012 at 6:26 AM, Linda Ursin wrote:
>>>
[Tue Jan 31 15:42:15 2012] [error] [client 193.69.154.79] DBI
connect('dbname=template1','postgres',...) failed: FATAL: Ident
authentication failed for user "postgres" at LedgerSMB.pm line 982,
referer: http://lur.aitel.hist.no/ledgersmb/setup.pl
>>>
>>>
>>> You have a bad line in your pg_hba.conf
>>>
>>> Best Wishes,
>>> Chris Travers
>>>
>>>
~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~
Linda Ursin
Heksebua
Adresse: Tlf: (+47) 402 40 767
Solvangwww: http://heksebua.com
7288 Soknedal E-post: li...@heksebua.com
Org: NO 995 578 107
On Tue, Jan 31, 2012 at 3:22 PM, Chris Travers >>> > wrote:
>
>
> On Tue, Jan 31, 2012 at 6:10 AM, Linda Ursin wrote:
>
>> ALTER USER "postgres" WITH VALID UNTIL '2013-11-09'; didn't help,
>> even if the command worked.
>>
>> If I was still using the old ledgersmb confiuration for apache, my
>> installation would be available through http:///regnskap/
>> but it isn't, it's aat http://.../ledgersmb/
>>
>
> Ok, so ruling that out.
>
> can you check your httpd error logs and see what it prints when it
> gives the auth dialog?
>
> Best Wishes,
> Chris Travers
>
>
> --
> Keep Your Developer Skills Current with LearnDevNow!
> The most comprehensive online learning library for Microsoft developers
> is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3,
> MVC3,
> Metro Style Apps, more. Free future releases when you subscribe now!
> http://p.sf.net/sfu/learndevnow-d2d
> ___
> Ledger-smb-users mailing list
> Ledger-smb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>
>
--
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
___
Ledger-smb-users mailing list
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>>>
>>>
>>> --
>>> Keep Your Developer Skills Current with LearnDevNow!
>>> The most comprehensive online learning library for Microsoft developers
>>> is just $99
Re: [Ledger-smb-users] Problems with upgrade from 1.2.x to current version
On Tue, Jan 31, 2012 at 8:39 AM, Linda Ursin wrote:
> It's the default configuration. I haven't touched it. What should be there
> that isn't?
>
> Now that I have had a chance to sleep on this just a little
Basically you have two options.
1) I suspect you are missing a database port assignment in your
ledgersmb.conf. If you add that in, it will fix the problem.
2) You could also grant all users md5 access to the database in question.
This would not be sufficient to use the setup.pl to create new databases
though.
What's happening is that the first rule here requires the postgres user on
all local connections to be logged in to the operating system as the
postgres operating system user. In 1.2 this is not a problem. In 1.3,
this is, because you have to have a superuser that creates/manages the
databases, and by default that's postgres.
Your PostgreSQL configuration is set up with basically two rule sets. The
first, for local UNIX socket connections is:
If user is postgres, ask OS what user the individual is logged in as, and
if not postgres, deny.
If user and db are ledgersmb, ask for password
otherwise ask OS what user the individual is logged in as and require that
it matches the requested db user.
The second rule set, for TCP/IP connections is much more simple:
Always ask for a password.
It seems to me that the easiest answer here is to correct the
ledgersmb.conf. It might be worth attaching or pasting it inline on the
reply to this email and we can talk about the best way to set this up.
>
> Linda
>
>
> ~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~
>
> Linda Ursin
> Heksebua
>
> Adresse: Tlf: (+47) 402 40 767
> Solvangwww: http://heksebua.com
> 7288 Soknedal E-post: li...@heksebua.com
>
> Org: NO 995 578 107
>
>
> On Tue, Jan 31, 2012 at 4:13 PM, Chris Travers wrote:
>
>>
>>
>> On Tue, Jan 31, 2012 at 7:01 AM, Linda Ursin wrote:
>>
>>> How is that possible when I haven't changed it? ( I changed it back to
>>> default after trying trust)
>>>
>>
>> 1.3 handles things a bit differently, security-wise, so it isn't entirely
>> surprising that some configurations that worked with 1.2 are not working
>> with 1.3.
>>
>>
>>>
>>> This is what it looks like:
>>>
>>> -
>>> # Database administrative login by UNIX sockets
>>> local all postgres ident
>>
>>
>>
>>> local ledgersmb ledgersmb md5
>>
>>
>>
>> Try changing hte above two lines to:
>> localledgersmball md5
>> localallpostgres md5
>>
>>
>> # TYPE DATABASEUSERCIDR-ADDRESS METHOD
>>>
>>> # "local" is for Unix domain socket connections only
>>> local all all ident.
>>
>> # IPv4 local connections:
>>> hostall all 127.0.0.1/32 md5
>>>
>>
>>
>>
>>> # IPv6 local connections:
>>> hostall all ::1/128 md5
>>>
>>> -
>>>
>>> The rest is commented out.
>>>
>>> Linda
>>>
>>>
>>>
>>> ~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~
>>>
>>> Linda Ursin
>>> Heksebua
>>>
>>> Adresse: Tlf: (+47) 402 40 767
>>> Solvangwww: http://heksebua.com
>>> 7288 Soknedal E-post: li...@heksebua.com
>>>
>>> Org: NO 995 578 107
>>>
>>>
>>> On Tue, Jan 31, 2012 at 3:53 PM, Chris Travers
>>> wrote:
>>>
On Tue, Jan 31, 2012 at 6:26 AM, Linda Ursin wrote:
> [Tue Jan 31 15:42:15 2012] [error] [client 193.69.154.79] DBI
> connect('dbname=template1','postgres',...) failed: FATAL: Ident
> authentication failed for user "postgres" at LedgerSMB.pm line 982,
> referer: http://lur.aitel.hist.no/ledgersmb/setup.pl
You have a bad line in your pg_hba.conf
Best Wishes,
Chris Travers
>
>
>
> ~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~
>
> Linda Ursin
> Heksebua
>
> Adresse: Tlf: (+47) 402 40 767
> Solvangwww: http://heksebua.com
> 7288 Soknedal E-post: li...@heksebua.com
>
> Org: NO 995 578 107
>
>
> On Tue, Jan 31, 2012 at 3:22 PM, Chris Travers <
> chris.trav...@gmail.com> wrote:
>
>>
>>
>> On Tue, Jan 31, 2012 at 6:10 AM, Linda Ursin wrote:
>>
>>> ALTER USER "postgres" WITH VALID UNTIL '2013-11-09'; didn't help,
>>> even if the command worked.
>>>
>>> If I was still using the old ledgersmb confiuration for apache, my
>>> installation would be available through http:///regnskap/
>>> but it isn't, it's aat http://.../ledgersmb/
>>>
>>
>> Ok, so ruling that out.
>>
>> can you check your httpd error logs
Re: [Ledger-smb-users] Announcing LedgerSMB 1.3.10
Roderick, On 2012-01-30 09:57, Roderick A. Anderson wrote: > Chris Travers wrote: >> On Mon, Jan 16, 2012 at 5:55 PM, Philip Rhoades >> wrote: >>> Chris, >>> >>> RPM? >> >> The RPM drops the version number requirement for the perl-config-std >> package, and it is there at the same download location. > > FYI, perl-Config-Std has been updated on Rpmforge to 0.900-1. > Notification came from Dag Wieers Monday that my patched spec file > had > been accepted and I just checked that the updated had gone through > and > was accessible. I presume installing this version does not help with my tablefunc.sql problem? Thanks, Phil. -- Philip Rhoades GPO Box 3411 Sydney NSW 2001 Australia E-mail: p...@pricom.com.au -- Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] Announcing LedgerSMB 1.3.10
On Tue, Jan 31, 2012 at 5:22 PM, Philip Rhoades wrote: > Roderick, > > > On 2012-01-30 09:57, Roderick A. Anderson wrote: > > Chris Travers wrote: > >> On Mon, Jan 16, 2012 at 5:55 PM, Philip Rhoades > >> wrote: > >>> Chris, > >>> > >>> RPM? > >> > >> The RPM drops the version number requirement for the perl-config-std > >> package, and it is there at the same download location. > > > > FYI, perl-Config-Std has been updated on Rpmforge to 0.900-1. > > Notification came from Dag Wieers Monday that my patched spec file > > had > > been accepted and I just checked that the updated had gone through > > and > > was accessible. > > > I presume installing this version does not help with my tablefunc.sql > problem? > Philip: Can you check what PostgreSQL version you are running? I assumed it was 9.0 but better be sure. Also can you check the following files in /tmp/ledgersmb? dblog dblog_stderr dblog_stdout Attaching them would be helpful > > Thanks, > > Phil. > -- > Philip Rhoades > > GPO Box 3411 > Sydney NSW 2001 > Australia > E-mail: p...@pricom.com.au > > > -- > Keep Your Developer Skills Current with LearnDevNow! > The most comprehensive online learning library for Microsoft developers > is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, > Metro Style Apps, more. Free future releases when you subscribe now! > http://p.sf.net/sfu/learndevnow-d2d > ___ > Ledger-smb-users mailing list > Ledger-smb-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users > -- Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] Announcing LedgerSMB 1.3.10
On 2012-02-01 12:45, Chris Travers wrote: > On Tue, Jan 31, 2012 at 5:22 PM, Philip Rhoades [7]> wrote: > >> Roderick, >> >> On 2012-01-30 09 [1]:57, Roderick A. Anderson wrote: >> > Chris Travers wrote: >> >> On Mon, Jan 16, 2012 at 5:55 PM, Philip Rhoades >> >> >> wrote: >> >>> Chris, >> >>> >> >>> RPM? >> >> >> >> The RPM drops the version number requirement for the >> perl-config-std >> >> package, and it is there at the same download location. >> > >> > FYI, perl-Config-Std has been updated on Rpmforge to 0.900-1. >> > Notification came from Dag Wieers Monday that my patched spec >> file >> > had >> > been accepted and I just checked that the updated had gone >> through >> > and >> > was accessible. >> >> I presume installing this version does not help with my >> tablefunc.sql >> problem? > > Philip: > > Can you check what PostgreSQL version you are running? I assumed it > was 9.0 but better be sure. postgresql-9.1.2-2.fc16.x86_64 > Also can you check the following files in /tmp/ledgersmb? > > dblog > dblog_stderr > dblog_stdout > > Attaching them would be helpful These files have not been created during the install yet - it is not getting that far I think . . Thanks, Phil. >> Thanks, >> >> Phil. >> >> -- >> Philip Rhoades >> >> GPO Box 3411 >> Sydney NSW 2001 >> Australia >> E-mail: p...@pricom.com.au [3] >> >> > > -- >> Keep Your Developer Skills Current with LearnDevNow! >> The most comprehensive online learning library for Microsoft >> developers >> is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, >> MVC3, >> Metro Style Apps, more. Free future releases when you subscribe >> now! >> http://p.sf.net/sfu/learndevnow-d2d [4] >> ___ >> Ledger-smb-users mailing list >> Ledger-smb-users@lists.sourceforge.net [5] >> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users [6] > > > > Links: > -- > [1] http://pricom.com.au/tel:2012-01-30%2009 > [2] mailto:p...@pricom.com.au > [3] mailto:p...@pricom.com.au > [4] http://p.sf.net/sfu/learndevnow-d2d > [5] mailto:Ledger-smb-users@lists.sourceforge.net > [6] https://lists.sourceforge.net/lists/listinfo/ledger-smb-users > [7] mailto:p...@pricom.com.au -- Philip Rhoades GPO Box 3411 Sydney NSW 2001 Australia E-mail: p...@pricom.com.au -- Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] Announcing LedgerSMB 1.3.10
Hi Philip; Something is obviously not as expected here. 1.3.10 addresses issues of missing extensions directories by detecting the PostgreSQL server version and if it is 9.0 or lower, it tries to look for the tablefunc.sql, but if it is 9.1 or above, it looks for tablefunc.control. If you are running 9.1, and it is still doing this, then something isn't right. Either you aren't pointing to the place where tablefunc.control is located, or something else is going on. I will be responding to the database troubleshooting steps on the other thread on -devel. Best Wishes, Chris Travers -- Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] Announcing LedgerSMB 1.3.10
Chris, On 2012-02-01 13:21, Chris Travers wrote: > Hi Philip; > > Something is obviously not as expected here. 1.3.10 addresses issues > of missing extensions directories by detecting the PostgreSQL server > version and if it is 9.0 or lower, it tries to look for the > tablefunc.sql, but if it is 9.1 or above, it looks for > tablefunc.control. If you are running 9.1, and it is still doing > this, then something isnt right. Either you arent pointing to the > place where tablefunc.control is located, or something else is going > on. > > I will be responding to the database troubleshooting steps on the > other thread on -devel. I was doing the RPM testing on a Fedora 16 i686 virtual machine but after those issues were resolved, I moved on to a real install on my live F16 x86_64 which I really need to get going now . . Thanks, Phil. -- Philip Rhoades GPO Box 3411 Sydney NSW 2001 Australia E-mail: p...@pricom.com.au -- Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] Announcing LedgerSMB 1.3.10
On Tue, Jan 31, 2012 at 6:55 PM, Philip Rhoades wrote: > Chris, > > > On 2012-02-01 13:21, Chris Travers wrote: > > Hi Philip; > > > > Something is obviously not as expected here. 1.3.10 addresses issues > > of missing extensions directories by detecting the PostgreSQL server > > version and if it is 9.0 or lower, it tries to look for the > > tablefunc.sql, but if it is 9.1 or above, it looks for > > tablefunc.control. If you are running 9.1, and it is still doing > > this, then something isnt right. Either you arent pointing to the > > place where tablefunc.control is located, or something else is going > > on. > > > > I will be responding to the database troubleshooting steps on the > > other thread on -devel. > > > I was doing the RPM testing on a Fedora 16 i686 virtual machine but > after those issues were resolved, I moved on to a real install on my > live F16 x86_64 which I really need to get going now . . > Try: select version(); and if 9.1: CREATE EXTENSION tablefunc; do that in a new database. If that works you can drop the database and I will send you some lines to comment out. Best Wishes, Chris Travers > > Thanks, > > Phil. > -- > Philip Rhoades > > GPO Box 3411 > Sydney NSW 2001 > Australia > E-mail: p...@pricom.com.au > > > -- > Keep Your Developer Skills Current with LearnDevNow! > The most comprehensive online learning library for Microsoft developers > is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, > Metro Style Apps, more. Free future releases when you subscribe now! > http://p.sf.net/sfu/learndevnow-d2d > ___ > Ledger-smb-users mailing list > Ledger-smb-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users > -- Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] Announcing LedgerSMB 1.3.10
Chris, On 2012-02-01 14:02, Chris Travers wrote: > On Tue, Jan 31, 2012 at 6:55 PM, Philip Rhoades [6]> wrote: > >> Chris, >> >> On 2012-02-01 13 [1]:21, Chris Travers wrote: >> > Hi Philip; >> > >> > Something is obviously not as expected here. 1.3.10 addresses >> issues >> > of missing extensions directories by detecting the PostgreSQL >> server >> > version and if it is 9.0 or lower, it tries to look for the >> > tablefunc.sql, but if it is 9.1 or above, it looks for >> > tablefunc.control. If you are running 9.1, and it is still >> doing >> > this, then something isnt right. Either you arent pointing to >> the >> >>> place where tablefunc.control is located, or something else is >> going >> > on. >> > >> > I will be responding to the database troubleshooting steps on the >> > other thread on -devel. >> >> I was doing the RPM testing on a Fedora 16 i686 virtual machine but >> after those issues were resolved, I moved on to a real install on >> my >> live F16 x86_64 which I really need to get going now . . > > Try: > > select version(); > > and > > if 9.1: > > CREATE EXTENSION tablefunc; > > do that in a new database. > > If that works you can drop the database and I will send you some > lines > to comment out. -bash-4.2$ dropdb ext_test -bash-4.2$ createdb ext_test -bash-4.2$ psql ext_test psql (9.1.2) Type "help" for help. ext_test=# select version(); version - PostgreSQL 9.1.2 on x86_64-redhat-linux-gnu, compiled by gcc (GCC) 4.6.2 20111027 (Red Hat 4.6.2-1), 64-bit (1 row) ext_test=# CREATE EXTENSION tablefunc; ERROR: type "tablefunc_crosstab_2" already exists - same as before . . Thanks, Phil. -- Philip Rhoades GPO Box 3411 Sydney NSW 2001 Australia E-mail: p...@pricom.com.au -- Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] Announcing LedgerSMB 1.3.10
On Tue, Jan 31, 2012 at 7:29 PM, Philip Rhoades wrote: > Chris, > > > On 2012-02-01 14:02, Chris Travers wrote: > > On Tue, Jan 31, 2012 at 6:55 PM, Philip Rhoades > [6]> wrote: > > > >> Chris, > >> > >> On 2012-02-01 13 [1]:21, Chris Travers wrote: > >> > Hi Philip; > >> > > >> > Something is obviously not as expected here. 1.3.10 addresses > >> issues > >> > of missing extensions directories by detecting the PostgreSQL > >> server > >> > version and if it is 9.0 or lower, it tries to look for the > >> > tablefunc.sql, but if it is 9.1 or above, it looks for > >> > tablefunc.control. If you are running 9.1, and it is still > >> doing > >> > this, then something isnt right. Either you arent pointing to > >> the > >> > >>> place where tablefunc.control is located, or something else is > >> going > >> > on. > >> > > >> > I will be responding to the database troubleshooting steps on the > >> > other thread on -devel. > >> > >> I was doing the RPM testing on a Fedora 16 i686 virtual machine but > >> after those issues were resolved, I moved on to a real install on > >> my > >> live F16 x86_64 which I really need to get going now . . > > > > Try: > > > > select version(); > > > > and > > > > if 9.1: > > > > CREATE EXTENSION tablefunc; > > > > do that in a new database. > > > > If that works you can drop the database and I will send you some > > lines > > to comment out. > > > -bash-4.2$ dropdb ext_test > -bash-4.2$ createdb ext_test > -bash-4.2$ psql ext_test > psql (9.1.2) > Type "help" for help. > > ext_test=# select version(); >version > > - > PostgreSQL 9.1.2 on x86_64-redhat-linux-gnu, compiled by gcc (GCC) > 4.6.2 20111027 (Red Hat 4.6.2-1), 64-bit > (1 row) > > ext_test=# CREATE EXTENSION tablefunc; > ERROR: type "tablefunc_crosstab_2" already exists > Interesting. Is it possible that tablefunc had been loaded into template1 and then this was upgraded? If so, you will need to try this (first on ext_test, and then if successful on template1): CREATE EXTENSION tablefunc FROM unpackaged; DROP EXTENSION tablefunc; If that seems to work, repeat the create extension test before repeating the two commands above in template1. Best Wishes, Chris Travers > > - same as before . . > > Thanks, > > Phil. > -- > Philip Rhoades > > GPO Box 3411 > Sydney NSW 2001 > Australia > E-mail: p...@pricom.com.au > > > -- > Keep Your Developer Skills Current with LearnDevNow! > The most comprehensive online learning library for Microsoft developers > is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, > Metro Style Apps, more. Free future releases when you subscribe now! > http://p.sf.net/sfu/learndevnow-d2d > ___ > Ledger-smb-users mailing list > Ledger-smb-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users > -- Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
