You should be able to, as the user running ofbiz, type the following. The
IP must match what is in the file: entityengine.xml
psql -h IP_OF_DB_HOST -U ofbiz -d ofbiz
[ENTER PASSWORD] ("ofbiz")
If the above doesn't work, then you may need to tweak the postgres
file: pg_hba.conf, and perform a postgresql "reload" (or restart):
Examples:
host all all 0.0.0.0/0 md5
host all all 127.0.0.1/32 md5
local all all peer
Depend on that you have locally setup. For your entityengine.xml, use
<group-map group-name="org.ofbiz" datasource-name="localpostnew"/>
[localpostnew is superior]
Under the localpostnew section, make sure you have:
<inline-jdbc
jdbc-driver="org.postgresql.Driver"
jdbc-uri="jdbc:postgresql://IP_OF_DB_HOST/ofbiz"
jdbc-username="ofbiz"
jdbc-password="ofbiz"
Also, to have ofbiz re-init the database, it first has to exist:
postgres> CREATE DATABASE ofbiz;
Remember, use the "psql" command above to test whether ofbiz can properly
login as he user "dan". A better test:
dan> psql -h IP_OF_DB_HOST -U ofbiz -d ofbiz -c "CREATE DATABASE ofbiz;"
[ENTER PASSWORD] ("ofbiz")
Good luck
On Sun, Mar 12, 2017 at 7:23 PM, <[email protected]> wrote:
> 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!
>
