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

Re: 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/

<Directory /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.
  <Files ~ "\.conf$">
    Order Deny,Allow
    Deny from All
  </Files>
</Directory>

<Directory /usr/share/ledgersmb/users>
  Order Deny,Allow
  Deny from All
</Directory>

<Directory /usr/share/ledgersmb/bin>
  Order Deny,Allow
  Deny from All
</Directory>

<Directory /usr/share/ledgersmb/utils>
  Order Deny,Allow
  Deny from All
</Directory>

<Directory /usr/share/ledgersmb/spool>
  Order Deny,Allow
  Deny from All
</Directory>

<Directory /usr/share/ledgersmb/templates>
  Order Deny,Allow
  Deny from All
</Directory>

<Directory /usr/share/ledgersmb/LedgerSMB>
  Order Deny,Allow
  Deny from All
</Directory>

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
Solvang                        www:     http://heksebua.com
7288 Soknedal              E-post:  ..hidden..

Org: NO 995 578 107


On Tue, Jan 31, 2012 at 2:51 PM, Chris Travers <..hidden..> wrote:


On Tue, Jan 31, 2012 at 5:08 AM, Linda Ursin <..hidden..> 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
Solvang                        www:     http://heksebua.com
7288 Soknedal              E-post:  ..hidden..

Org: NO 995 578 107


On Tue, Jan 31, 2012 at 1:38 PM, Håvard Sørli <..hidden..> 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
..hidden..
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
..hidden..
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
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users