Hi,
...logged in to psql as user postgres...
psql (9.4.9)Type "help" for help. postgres=# \du
List of roles Role name | Attributes |
Member of
-----------+------------------------------------------------+----------- ofbiz
| Create role, Create DB, Replication | {} dan | Create
role, Create DB, Replication | {} postgres | Superuser, Create
role, Create DB, Replication | {}
Earlier I had fewer permissions, errors changed to transaction errors after
adding more permissions/roles to user ofbiz in PostgreSQL. I'm wondering, since
I'm running ofbiz from my regular system account user (user ofbiz exists only
in PostgreSQL and is not a system account), yet seeing failures in file reads
from my regular user (ofbiz is located in ~dan/ofbiz/), if perhaps some aspect
of the SQL query is somehow unable to read files because of an suid within
ofbiz? Ofbiz is run in "~dan/ofbiz/" as user dan via "./gradlew
loadDefault"...I would think that any file reads would be as user dan, but
apparently this isn't true. Example failure:
2017-03-12 19:07:26,728 |main |EntityDataLoadContainer
|I| [loadData]: Error loading XML Resource
"file:/home/dan/ofbiz/framework/security/data/SecurityPermissionSeedData.xml";
Error was: A transaction error occurred reading data
Basically user "dan" running gradlew cannot read his own file verified to be
accessible in
/home/dan/ofbiz/framework/security/data/SecurityPermissionSeedData.xml as if he
isn't really user dan. Is gradlew performing some sort of sudo and reading
files as someone other than the user that starts gradlew?
Thanks!
----- Original Message -----From: Mike <[email protected]>To: user
<[email protected]>Sent: Mon, 13 Mar 2017 01:55:09 -0000 (UTC)Subject: Re:
Current PostgreSQL Instructions
What is your output using "\du ofbiz"
postgres=# \du ofbiz List of roles Role name | Attributes | Member
of-----------+------------+----------- ofbiz | Create DB | {}
On Sun, Mar 12, 2017 at 2:57 PM, <[email protected]> wrote:
> Hi,>> I'm just trying to evaluate ofbiz for some simple POS needs (which is
> of> course not really simple). I see there is a lot of ofbiz development>
> activity, and thus a lot of documents which are actually out of date.>
> Sometimes for example the instructions use "ant" directly and do not know> of
> the gradlew command. In entityengine.xml information I sometimes see>
> PostgreSQL info which refers to "org.ofbiz", but this is out of date and is>
> actually "org.apache.ofbiz". The little things like that are derailing me.>>
> To make a long story short, I have PostgreSQL running on Fedora, and>
> apache-ofbiz-16.11.01 working with Derby, but need to change to PostgreSQL>
> (and PostgreSQL is up and running with both my regular user and with>
> "ofbiz/ofbiz" name/pass), and getting connection refused (I can manually> run
> commands such as createdb and dropdb without issue). Basically there is> some
> small detail I'm missing and am wondering if there is current> documentation
> on setting up ofbiz with PostgreSQL which I'm missing?>> I really like this
> documentation...but unfortunately it is wrong (out of> date):>
> https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Technical+>
> Production+Setup+Guide>> This in turn points out a lot of facts through
> here:> https://cwiki.apache.org/confluence/display/OFBIZ/>
> Entity+Engine+Configuration+Guide>> ...but I'm more interested in getting it
> working and that information> appears to only be for people who already
> understand ofbiz setup (there are> a lot of facts there and no example which
> works with 16.11.01). I was under> the impression that if PostgreSQL were set
> up and the ofbiz name/pass is> able to create tables then the "gradlew
> loadDefault" would be able to load> sample data into PostgreSQL without
> manually creating each table. Am I> incorrect on this? Do I need to manually
> create tables? I can attach my> entityengine.xml edits, but wanted to know
> first if there are explicit> instructions somewhere for the current 16.11.01
> (I am not interested in> customization and developing new apps, I just want
> to see the minimal> sample data using PostgreSQL).>> Thanks!
