gmane.comp.finance.ledger.smb.devel

Re: Testing out 1.4 with apache 2.4

2013-05-19T05:07:27

Your quick.

Here is a humble start. I have not checked it against apache 2.2.
It finds my apache 2.4
<begin patch>

--- install.sh  2013-05-18 21:28:47.534096177 -0700
+++ install.sh~ 2013-05-18 21:28:27.125094539 -0700
< at >< at > -21,9 +21,18 < at >< at >
 make

 echo "Configuring Apache"
+#Check apache version
+version=$(apache2 -v | grep "Server version")
+if [[ $version =~ "2.4" ]];
+then echo "Configuring for new Apache 2.4 series: " $version
+        config_file='ledgersmb-httpd-2.4.conf.template'
+else echo "Configuring for Apache2 series: " $version
+       let config_file='ledgersmb-httpd.conf.template'
+fi
+echo "Selected "$config_file

 #sed "s|WORKING_DIR|$CWD|" ledgersmb-httpd.conf.template >
ledgersmb-httpd.conf
-sed  "s|/ledgersmb|/$APACHE_ALIAS|g;s|WORKING_DIR|$CWD|g"
ledgersmb-httpd.conf.template > ledgersmb-httpd.conf
+sed  "s|/ledgersmb|/$APACHE_ALIAS|g;s|WORKING_DIR|$CWD|g" $config_file >
ledgersmb-httpd.conf

 echo "Which user does your web server run as?"
 read username



</end patch>

I realized my po

Re: Testing out 1.4 with apache 2.4

Erik Huelsmann — 2013-05-18T21:50:47

Hi Turtle,



Committed: r5825.

(install.sh, INSTALL and other docs remain to be updated. Care to send a
patch?)



Bye,


Erik.
------------------------------------------------------------------------------
AlienVault Unified Security Management (USM) platform delivers complete
security visibility with the essential security capabilities. Easily and
efficiently configure, manage, and operate all of your security controls
from a single console and one unified framework. Download a free trial.
http://p.sf.net/sfu/alienvault_d2d_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f< at >public.gmane.org
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel

Re: Testing out 1.4 with apache 2.4

2013-05-18T21:31:17

Got it working with the help of reading recent 1.4 posts here.
The only thing I did was set up my test user manually in postgres to get
past the apache auth dialog.

I set every setting I could find to "DEBUG" in Sysconfig.pm and
ledgersmb.conf

And found lots of info appearing here:

/tmp/ledgersmb $ ls -lat
total 212
-rw-r--r--  1 apache apache 85913 May 15 14:00 dblog
-rw-r--r--  1 apache apache 65706 May 15 14:00 lsmb_roles.sql
drwxr-xr-x  2 apache apache   120 May 15 13:56 .
-rw-r--r--  1 apache apache 16398 May 15 13:56 dblog_stdout
-rw-r--r--  1 apache apache 39533 May 15 13:56 dblog_stderr
drwxrwxrwt 14 root   root     320 May 15 13:55 ..

I could post the files if your interested.

Right now I am checking out the new customer / vendor page. I get the a
few errors when adding a customer:
<begin error>

Attribute (name) is required at constructor LedgerSMB::Entity::Person::new
(defined at LedgerSMB/Entity/Person.pm line 180) line 119.
LedgerSMB::Entity::Person::new('LedgerSMB::Entity::Person',
'_scrip

Re: Testing out 1.4 with apache 2.4

Erik Huelsmann — 2013-05-18T20:57:57

[ ... ]


Thanks for the submission! I'll send a second configuration file to the
repository in a bit.

Bye,


Erik.
------------------------------------------------------------------------------
AlienVault Unified Security Management (USM) platform delivers complete
security visibility with the essential security capabilities. Easily and
efficiently configure, manage, and operate all of your security controls
from a single console and one unified framework. Download a free trial.
http://p.sf.net/sfu/alienvault_d2d_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f< at >public.gmane.org
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel

Re: Testing out 1.4 with apache 2.4

2013-05-18T20:52:15

Thanks yes.
I am looking into updating the Gentoo ebuild to possible call a modified
version of that script.

Here is what I got working:
##
#Ledgersmb-1.4 config for apache2 2.4 series
##
 <Directory /var/www/localhost/htdocs/ledgersmb-1.4/>

  # 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
    Require ip 127.0.0.1
    Require host localhost
    Require all denied
   #Require all granted#for testing

# Prevent unauthorized access to configuration
# and access control files
  <Files ~ "\.conf$">
    Require all

Re: Testing out 1.4 with apache 2.4

Erik Huelsmann — 2013-05-18T20:43:44

Hi,

On Sat, May 18, 2013 at 9:45 PM, <turtle-16DslRxB7FRCUcnqO4TvNdBPR1lH4CV8< at >public.gmane.org> wrote:


Not that I'm aware of, but ...



... reading the page you reference, you probably want to change the lines

Order Deny,Allow
Allow from 127.0.0.1
Allow from localhost

to

Require ip 127.0.0.1
Require host localhost


Also the install script install.sh might want to check apache versions
It looks like you shouldn't need to find any other configuration issues, if
I'm reading the page correctly. You'll need to enable/load the modules
mod_authz_host and mod_authz_core, though for the above to work.

At first I didn't understand why the install.sh should be changed, but you
mean to detect the version and pick the right configuration file to install?



Thanks for your report!

Bye,


Erik.
------------------------------------------------------------------------------
AlienVault Unified Security Management (USM) platform delivers complete
security visibility with the essential security capabilities. Easily a

Testing out 1.4 with apache 2.4

2013-05-18T19:45:28

Greetings all this weekend I am testing out 1.4 on apache 2.4 with
postgres 9.2 is there a ledgersmb-httpd.conf configured to apache 2.4 ?
That would have converted the outdated Allow Deny format to the "Require"
format?
Also the install script install.sh might want to check apache versions
unless I missed something.

http://httpd.apache.org/docs/2.4/upgrading.html

Cheers
Turtle


------------------------------------------------------------------------------
AlienVault Unified Security Management (USM) platform delivers complete
security visibility with the essential security capabilities. Easily and
efficiently configure, manage, and operate all of your security controls
from a single console and one unified framework. Download a free trial.
http://p.sf.net/sfu/alienvault_d2d

Re: A little trouble installing 1.4.

Erik Huelsmann — 2013-05-17T21:32:27

Great! Good to hear it's mostly working now. I'm sure Chris and I will find
the problem with the user-creation tomorrrow morning.

Bye,

Erik.


On Fri, May 17, 2013 at 10:42 PM, Chris Calef <chris.calef-Re5JQEeQqe8AvxtiuMwx3w< at >public.gmane.org> wrote:

------------------------------------------------------------------------------
AlienVault Unified Security Management (USM) platform delivers complete
security visibility with the essential security capabilities. Easily and
efficiently configure, manage, and operate all of your security controls
from a single console and one unified framework. Download a free trial.
http://p.sf.net/sfu/alienvault_d2d_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f< at >public.gmane.org
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel

Re: A little trouble installing 1.4.

Chris Calef — 2013-05-17T20:42:13

And... DING DING DING!

"This database operation has completed successfully. LedgerSMB may now be
used."

Thanks very much for all the help, that did it!

Just in case any other part time SQL newbies follow along here, the precise
syntax on create user for my version of postgres is:

create user ccalef with password 'mypasswordhere';  (no quotes on username,
single quotes on password, and "with" added.)

Yay!  Now, on to the real work...  :-)

Cheers,
Chris C



On Fri, May 17, 2013 at 12:57 PM, Erik Huelsmann <ehuels-Re5JQEeQqe8AvxtiuMwx3w< at >public.gmane.org> wrote:

------------------------------------------------------------------------------
AlienVault Unified Security Management (USM) platform delivers complete
security visibility with the essential security capabilities. Easily and
efficiently configure, manage, and operate all of your security controls
from a single console and one unified framework. Download a free trial.
http://p.sf.net/sfu/alienvault_d2d_______________________________________________

Re: A little trouble installing 1.4.

Erik Huelsmann — 2013-05-17T19:57:41


[username] designates the user you want to use to log into ledgersmb; in
your case that could be ccalef (mine is ehuelsmann). So, it wants you to
log into your database:

$ *su postgres*
$ *psql*
postgres=#  *create user "ccalef" password "yourpasswordhere";*
posgres=# *\q*
$


And then start the process for creating your database through setup.pl.
When setup.pl asks you for your initial user, use ccalef as the user,
select "Yes" for "Import" and fill out all the other fields.


Hope that explains it.


Bye,


Erik.
------------------------------------------------------------------------------
AlienVault Unified Security Management (USM) platform delivers complete
security visibility with the essential security capabilities. Easily and
efficiently configure, manage, and operate all of your security controls
from a single console and one unified framework. Download a free trial.
http://p.sf.net/sfu/alienvault_d2d_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel-5

Re: A little trouble installing 1.4.

Chris Calef — 2013-05-17T19:53:27

I went back and tried saying Yes to Import, not sure how that is supposed
to work, but with a  new database name it fails because database doesn't
exist, and with a new user on an existing database I get the same "can't
grant permissions to a non existent user" message.



On Fri, May 17, 2013 at 12:41 PM, Chris Calef <chris.calef-Re5JQEeQqe8AvxtiuMwx3w< at >public.gmane.org> wrote:

------------------------------------------------------------------------------
AlienVault Unified Security Management (USM) platform delivers complete
security visibility with the essential security capabilities. Easily and
efficiently configure, manage, and operate all of your security controls
from a single console and one unified framework. Download a free trial.
http://p.sf.net/sfu/alienvault_d2d_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f< at >public.gmane.org
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel

Re: A little trouble installing 1.4.

Chris Calef — 2013-05-17T19:41:11

Hm,

"This can be worked around easily enough by logging in with psql (as
postgres, any db), and CREATE USER '[username]' before creating the
database. Then you can select 'yes' in the import option and this works
properly. However it does need to be fixed before next beta."

Does [username] refer to my database user, ie "ledgersmb"?  Because that
user already exists.  Or does it refer to my (within ledgersmb) system user?



On Fri, May 17, 2013 at 12:27 PM, Erik Huelsmann <ehuels-Re5JQEeQqe8AvxtiuMwx3w< at >public.gmane.org> wrote:

------------------------------------------------------------------------------
AlienVault Unified Security Management (USM) platform delivers complete
security visibility with the essential security capabilities. Easily and
efficiently configure, manage, and operate all of your security controls
from a single console and one unified framework. Download a free trial.
http://p.sf.net/sfu/alienvault_d2d_______________________________________________
Ledger-smb-devel mailing list
Ledger

Re: A little trouble installing 1.4.

Erik Huelsmann — 2013-05-17T19:27:49


Committed that fix as well.


(I don't know why my "company" comes up blank, related issue?)
That might very well be a related issue, yes. Chris was working on it today
but didn't find out what exactly was going wrong. He filed issue 826 for it
(https://sourceforge.net/p/ledger-smb/bugs/826/) so he could continue in
the morning.

The issue also contains a workaround description.

That should get you going!


Please let me know if you have any other issues!

Bye,


Erik.
------------------------------------------------------------------------------
AlienVault Unified Security Management (USM) platform delivers complete
security visibility with the essential security capabilities. Easily and
efficiently configure, manage, and operate all of your security controls
from a single console and one unified framework. Download a free trial.
http://p.sf.net/sfu/alienvault_d2d_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f< at >public.gmane.or

Re: A little trouble installing 1.4.

Chris Calef — 2013-05-17T19:20:49

Also, just so you know, I'm still getting a database created, but no users
added, at the point where it crashes (which is just after filling in the
new user information and clicking okay).


On Fri, May 17, 2013 at 12:19 PM, Chris Calef <chris.calef-Re5JQEeQqe8AvxtiuMwx3w< at >public.gmane.org> wrote:

------------------------------------------------------------------------------
AlienVault Unified Security Management (USM) platform delivers complete
security visibility with the essential security capabilities. Easily and
efficiently configure, manage, and operate all of your security controls
from a single console and one unified framework. Download a free trial.
http://p.sf.net/sfu/alienvault_d2d_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f< at >public.gmane.org
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel

Re: A little trouble installing 1.4.

Chris Calef — 2013-05-17T19:19:33

Hmm... well, we got rid of all the errors in dblog!

There was one more error after your commit, the same issue but with
"journal__save_recurring_print" instead of "journal__save_recurring"... I
went ahead and did the same RETURN * thing after that and the error went
away.

However, my browser still returns the same message:
Error!

*Error from Function:
ERROR: Cannot grant permissions to a non-existant user. More information
has been reported in the error logs at LedgerSMB.pm line 987. *

dbversion: 1.4.0, company:

(I don't know why my "company" comes up blank, related issue?)

Even though dblog and the other files in there all looked good, my apache
error.log had a lot of intersting information in it:

--------------------------------------------------------------------------------

[Fri May 17 12:11:07 2013] [error] [client 127.0.0.1] DBD::Pg::st execute
failed: ERROR:  column "version" does not exist, referer:
http://localhost/lsmb14/setup.pl
[Fri May 17 12:11:07 2013] [error] [client 127.0.0.1] LINE 1:

Re: A little trouble installing 1.4.

Erik Huelsmann — 2013-05-17T18:51:16

Hi Chris,

Nobody was working on it, so I took the liberty to commit a fix. Could you
tell me if it works now?

Bye,

Erik.


On Fri, May 17, 2013 at 8:31 PM, Chris Calef <chris.calef-Re5JQEeQqe8AvxtiuMwx3w< at >public.gmane.org> wrote:

------------------------------------------------------------------------------
AlienVault Unified Security Management (USM) platform delivers complete
security visibility with the essential security capabilities. Easily and
efficiently configure, manage, and operate all of your security controls
from a single console and one unified framework. Download a free trial.
http://p.sf.net/sfu/alienvault_d2d_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f< at >public.gmane.org
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel

Re: A little trouble installing 1.4.

Chris Calef — 2013-05-17T18:31:23

Hi, not sure if people are still in the middle of working on this, but I
saw there were updates so I tried it again.  Results: not _quite_ there,
but only one error this time!

The offending statement is this:


psql:sql/modules/Transaction_Templates.sql:161: ERROR:  return type
mismatch in function declared to return recurring
DETAIL:  Function's final statement must be SELECT or INSERT/UPDATE/DELETE
RETURNING.
CONTEXT:  SQL function "journal__save_recurring"


Cheers,
Chris C






On Fri, May 17, 2013 at 5:32 AM, Chris Travers <chris.travers-Re5JQEeQqe8AvxtiuMwx3w< at >public.gmane.org>wrote:

------------------------------------------------------------------------------
AlienVault Unified Security Management (USM) platform delivers complete
security visibility with the essential security capabilities. Easily and
efficiently configure, manage, and operate all of your security controls
from a single console and one unified framework. Download a free trial.
http://p.sf.net/sfu/alienvault_d2d_____________________

Copyright year for locale/po/hu.po ?

Robert J. Clay — 2013-05-17T15:13:57

   I'm sorry I didn't notice this when it came out but shouldn't the
copyright year in locale/po/hu.po be "2013"? (If not something like
"2003, 2013"?)


--
Robert J. Clay
rjclay-Re5JQEeQqe8AvxtiuMwx3w< at >public.gmane.org

------------------------------------------------------------------------------
AlienVault Unified Security Management (USM) platform delivers complete
security visibility with the essential security capabilities. Easily and
efficiently configure, manage, and operate all of your security controls
from a single console and one unified framework. Download a free trial.
http://p.sf.net/sfu/alienvault_d2d

Re: A little trouble installing 1.4.

Chris Travers — 2013-05-17T12:32:54

Just letting folks know:

With svn 5815 I was able to create a new fresh db.  It took a bit longer
because the new Roles.sql format doesn't get processed as quickly as the
old format (however, it is now transactional and does a bunch of sanity
checks which make it better for working with addons, etc).

I still ran into one significant setup bug but it has a fairly simple
workaround.  I expect to get it fixed soon.  The bug report is at
https://sourceforge.net/p/ledger-smb/bugs/826/ for anyone who wants to
follow, and the workaround is listed there.

Best Wishes,.
Chris Travers


On Fri, May 17, 2013 at 3:52 AM, Chris Travers <chris.travers-Re5JQEeQqe8AvxtiuMwx3w< at >public.gmane.org>wrote:

------------------------------------------------------------------------------
AlienVault Unified Security Management (USM) platform delivers complete
security visibility with the essential security capabilities. Easily and
efficiently configure, manage, and operate all of your security controls
from a single console and one

Re: A little trouble installing 1.4.

Chris Travers — 2013-05-17T10:52:41

Just letting everyone know, I am working on the Roles.sql, entirely
rewriting it so that it runs repeatably and transactionally.

I expect to have it committed shortly.

Best Wishes,
Chris Travers




On Thu, May 16, 2013 at 11:46 PM, Erik Huelsmann <ehuels-Re5JQEeQqe8AvxtiuMwx3w< at >public.gmane.org> wrote:

------------------------------------------------------------------------------
AlienVault Unified Security Management (USM) platform delivers complete
security visibility with the essential security capabilities. Easily and
efficiently configure, manage, and operate all of your security controls
from a single console and one unified framework. Download a free trial.
http://p.sf.net/sfu/alienvault_d2d_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f< at >public.gmane.org
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel

Re: A little trouble installing 1.4.

Erik Huelsmann — 2013-05-17T06:46:55

Hi Chris,

Still got quite a few errors, although you fixed several with that
Fixed this one and found another one (just by inspecting the code).


Found a spurious semicolon. Removed. That should fix it.


I'll do these in the course of the day: I want to be sure to remove the
right bits in that table.

Bye,

Erik.
------------------------------------------------------------------------------
AlienVault Unified Security Management (USM) platform delivers complete
security visibility with the essential security capabilities. Easily and
efficiently configure, manage, and operate all of your security controls
from a single console and one unified framework. Download a free trial.
http://p.sf.net/sfu/alienvault_d2d_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f< at >public.gmane.org
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel