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: li...@heksebua.com
Org: NO 995 578 107
On Tue, Jan 31, 2012 at 2:51 PM, Chris Travers <chris.trav...@gmail.com>wrote:
>
>
> On Tue, Jan 31, 2012 at 5:08 AM, Linda Ursin <li...@heksebua.com> 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: li...@heksebua.com
>>
>> Org: NO 995 578 107
>>
>>
>> On Tue, Jan 31, 2012 at 1:38 PM, Håvard Sørli <hav...@anix.no> 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
>
>
------------------------------------------------------------------------------
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
