tag:jbilling.tenderapp.com,2012-10-15:/discussions/problems/99-config-jbilling-with-postgresqljBilling: Discussion 2018-08-17T15:46:57Ztag:jbilling.tenderapp.com,2012-10-15:Comment/273948672013-07-09T19:39:55Z2013-07-09T19:39:57Zconfig jbilling with postgresql<div><p>I try to use JBilling 3.0.2 and have this in my
jbilling-DataSource.groovy.</p>
<p>dialect = "org.hibernate.dialect.PostgreSQLDialect"<br>
driverClassName = "org.postgresql.Driver" username = "jsi" password
= "password" url =
"<a>jdbc:postgresql://localhost:5432/jsi&quot</a>;</p>
<p>It connects and I dont get any errors in startup... but I have
another problem..<br>
<a href=
"http://jbilling.tenderapp.com/discussions/problems/111-exception-when-creating-a-new-usercompany">
http://jbilling.tenderapp.com/discussions/problems/111-exception-wh...</a></p></div>klpcraptag:jbilling.tenderapp.com,2012-10-15:Comment/273948672013-08-06T14:01:11Z2013-08-06T14:01:11Zconfig jbilling with postgresql<div><p>Hello,</p>
<p>Did follow the suggestion made in the last comment? That is a
correct configuration for a PostgreSQL database.</p>
<p>Hope this answers your question!</p>
<p>Let us know if we can help you with anything else.</p>
<p>Regards,</p>
<p>jBilling Technical Support Team</p></div>Technical Supporttag:jbilling.tenderapp.com,2012-10-15:Comment/273948672016-08-07T19:11:13Z2016-08-07T19:11:14Zconfig jbilling with postgresql<div><p>Hi ,</p>
<p>I have downloaded jbilling-community-4.1.1 and I have installed
JAVA 1.8 and Postgree Sql9.3. Then I have changed
"jbilling-DataSource.groovy" for postgree sql database (attached
here also).<br>
But after running startup.bat , http://localhost:8080/ page is
opened but http://localhost:8080/jbilling/signup page can not
open.<br>
I have attached console of tomcat where some exceptions are
showing.</p>
<p>Can you please guide to solve this problem..</p>
<p>Reg,<br>
Santanu</p></div>Santanutag:jbilling.tenderapp.com,2012-10-15:Comment/273948672016-08-08T14:35:16Z2016-08-08T14:35:17Zconfig jbilling with postgresql<div><p>Hi</p>
<p>The error is clear: Connection; nested exc</p>
<p>eption is java.sql.SQLException: An attempt by a client to
checkout a<br>
Connection has timed out.</p>
<p>Can you share your DataSource.groovy file after your
changes?</p>
<p>Web Data.</p></div>Vikas@WebDataTechnologiesLLPtag:jbilling.tenderapp.com,2012-10-15:Comment/273948672018-07-11T13:59:00Z2018-07-11T13:59:01Zconfig jbilling with postgresql<div><p>Hello</p>
<p>Trying to setup jbilling 4.1.1 CE with postgresql.</p>
<p>Datasource groovy is attached with the logs. There is an JDBC nested exception on startup.</p>
<p>Can anyone help ?</p>
<p>Thanks</p></div>Smithtag:jbilling.tenderapp.com,2012-10-15:Comment/273948672018-07-11T14:50:14Z2018-07-11T14:50:14Zconfig jbilling with postgresql<div><p>is your postgres local server lestining on 5432 port on localhost<br>
check your pg_hba conf file , and to be sure try to connect to this server<br>
using psql client or pgadmin using localhost and not 127.0.0.1</p></div>ahmed.drira@gmail.comtag:jbilling.tenderapp.com,2012-10-15:Comment/273948672018-07-11T15:17:52Z2018-07-11T15:17:53Zconfig jbilling with postgresql<div><p>PostgreSQL is on local server on port 5432</p>
<p>pg_hba is as follows :</p>
<h1><a name="ipv4-local-connections-" class="anchor" href="#ipv4-local-connections-"></a>IPv4 local connections:</h1>
<p>host all all 127.0.0.1/32 trust</p>
<h1><a name="ipv6-local-connections-" class="anchor" href="#ipv6-local-connections-"></a>IPv6 local connections:</h1>
<p>host all all ::1/128 trust</p>
<p>I am able to connect to postgre using 'localhost'.</p>
<p>Some more info:</p>
<p>JDK 1.8.0_172<br>
Grails 3.3.6<br>
Groovy 2.4.15<br>
Postgre 10.4</p>
<p>Apparently, Postgre has its own Apache Tomcat embedded client which was blocking port 8080. So I had to stop this instance of apache and now log reads (see attached files). Cant connect to postgre.</p></div>Smithtag:jbilling.tenderapp.com,2012-10-15:Comment/273948672018-07-11T16:33:49Z2018-07-11T16:33:49Zconfig jbilling with postgresql<div><p>You have to configure your server to login using password and not trust in<br>
the pg_hba file<br>
The be sure that this user 'jbilling'exist and authorized to authenticate<br>
himself on this server from localhost using password</p>
<p>Thinkvyou have to change md5 otherwise trust...</p></div>ahmed.drira@gmail.comtag:jbilling.tenderapp.com,2012-10-15:Comment/273948672018-07-11T16:40:49Z2018-07-11T16:40:51Zconfig jbilling with postgresql<div><p>I was able to get to the login screen.</p>
<p>I had to copy the posgresql jar file to /webapps/jbilling/WEB-INF/lib/</p>
<p>Now, there are no companies so can't login.</p>
<p>Any help is greatly appreciated.</p>
<p>Thanks</p></div>Smithtag:jbilling.tenderapp.com,2012-10-15:Comment/273948672018-07-12T07:39:10Z2018-07-12T07:39:10Zconfig jbilling with postgresql<div><p>you can run the init-db script , or i think there is a signup screen ,<br>
try /signup path ... then you can create your first user and first company<br>
,</p></div>ahmed.drira@gmail.comtag:jbilling.tenderapp.com,2012-10-15:Comment/273948672018-08-17T15:46:55Z2018-08-17T15:46:57Zconfig jbilling with postgresql<div><p>Quite similar problem here with Postgresql.<br>
I have windows 10 and jre 1.8, incl. Postgresql 10 (64bit).</p>
<p>What I did:<br>
Created a new database with pgAdmin 4 (web interface)<br>
dbname: jbilling_test<br>
username: jbillinguser<br>
pwd: jbillingpwd</p>
<p>I changed the pg_hba.conf into:</p>
<h1><a name="type-database-user-address-method" class="anchor" href="#type-database-user-address-method"></a>TYPE DATABASE USER ADDRESS METHOD</h1>
<h1><a name="ipv4-local-connections-" class="anchor" href="#ipv4-local-connections-"></a>IPv4 local connections:</h1>
<p>host all all 127.0.0.1/32 trust</p>
<h1><a name="ipv6-local-connections-" class="anchor" href="#ipv6-local-connections-"></a>IPv6 local connections:</h1>
<p>host all all ::1/128 trust</p>
<p>Then I downloaded the jbilling-community-4.1.1.zip.<br>
Extracted under C:\jbilling-community-4.1.1\</p>
<p>Then I moved the second c3po jar into a temp file name. c3p0-0.9.1.1.jar into c3p0-0.9.1.1.jar_moved</p>
<p>But does not help here, still got the same errors like above, refer to attachments.</p>
<p>Any hints to get the version 4.1.1 running?</p>
<p>Many thanks<br>
Dietmar</p></div>Dietmar