config jbilling with postgresql

sacpv04's Avatar

sacpv04

19 Jun, 2013 10:25 AM

Dear all,
please help in this solution, I try to config jbilling work with postgresql, I have followed jbilling ducument and here is my datasource
dataSource {
    dialect = "org.hibernate.dialect.PostgreSQLDialect"
    driverClassName = "org.postgresql.Driver"
    username = "postgres"
    password = "123"
    url = "jdbc:postgresql://localhost:5432/ach"
    pooled = true
    configClass = GrailsAnnotationConfiguration.class
    dbCreate = "none"
}
I am using postgresql 9.2 on ubuntu 12.04. I dowloaded postgresql connector 9.2 and c3p0 0.9.2 and copy them to webapp/jbilling/lib to replace the old library.
see my catalina log below.
thankyou very much

  1. 1 Posted by klpcrap on 09 Jul, 2013 07:39 PM

    klpcrap's Avatar

    I try to use JBilling 3.0.2 and have this in my jbilling-DataSource.groovy.

    dialect = "org.hibernate.dialect.PostgreSQLDialect"
        driverClassName = "org.postgresql.Driver"
        username = "jsi"
        password = "password"
        url = "jdbc:postgresql://localhost:5432/jsi"

    It connects and I dont get any errors in startup... but I have another problem..
    http://jbilling.tenderapp.com/discussions/problems/111-exception-when-creating-a-new-usercompany

  2. Support Staff 2 Posted by Technical Suppo... on 06 Aug, 2013 02:01 PM

    Technical Support's Avatar

    Hello,

    Did follow the suggestion made in the last comment? That is a correct configuration for a PostgreSQL database.

    Hope this answers your question!

    Let us know if we can help you with anything else.

    Regards,

    jBilling Technical Support Team

  3. 3 Posted by Santanu on 07 Aug, 2016 07:11 PM

    Santanu's Avatar

    Hi ,

    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).
    But after running startup.bat , http://localhost:8080/ page is opened but http://localhost:8080/jbilling/signup page can not open.
    I have attached console of tomcat where some exceptions are showing.

    Can you please guide to solve this problem..

    Reg,
    Santanu

  4. 4 Posted by Vikas@WebDataTe... on 08 Aug, 2016 02:35 PM

    Vikas@WebDataTechnologiesLLP's Avatar

    Hi

    The error is clear: Connection; nested exc

    eption is java.sql.SQLException: An attempt by a client to checkout a
    Connection has timed out.

    Can you share your DataSource.groovy file after your changes?

    Web Data.

  5. 5 Posted by Smith on 11 Jul, 2018 01:59 PM

    Smith's Avatar

    Hello

    Trying to setup jbilling 4.1.1 CE with postgresql.

    Datasource groovy is attached with the logs. There is an JDBC nested exception on startup.

    Can anyone help ?

    Thanks

  6. 6 Posted by ahmed.drira@gma... on 11 Jul, 2018 02:50 PM

    ahmed.drira@gmail.com's Avatar

    is your postgres local server lestining on 5432 port on localhost
    check your pg_hba conf file , and to be sure try to connect to this server
    using psql client or pgadmin using localhost and not 127.0.0.1

  7. 7 Posted by Smith on 11 Jul, 2018 03:17 PM

    Smith's Avatar

    PostgreSQL is on local server on port 5432

    pg_hba is as follows :
    # IPv4 local connections:
    host all all 127.0.0.1/32 trust
    # IPv6 local connections:
    host all all ::1/128 trust

    I am able to connect to postgre using 'localhost'.

    Some more info:

    JDK 1.8.0_172
    Grails 3.3.6
    Groovy 2.4.15
    Postgre 10.4

    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.

  8. 8 Posted by ahmed.drira@gma... on 11 Jul, 2018 04:33 PM

    ahmed.drira@gmail.com's Avatar

    You have to configure your server to login using password and not trust in
    the pg_hba file
    The be sure that this user 'jbilling'exist and authorized to authenticate
    himself on this server from localhost using password

    Thinkvyou have to change md5 otherwise trust...

  9. 9 Posted by Smith on 11 Jul, 2018 04:40 PM

    Smith's Avatar

    I was able to get to the login screen.

    I had to copy the posgresql jar file to /webapps/jbilling/WEB-INF/lib/

    Now, there are no companies so can't login.

    Any help is greatly appreciated.

    Thanks

  10. 10 Posted by ahmed.drira@gma... on 12 Jul, 2018 07:39 AM

    ahmed.drira@gmail.com's Avatar

    you can run the init-db script , or i think there is a signup screen ,
    try /signup path ... then you can create your first user and first company
    ,

  11. 11 Posted by Dietmar on 17 Aug, 2018 03:46 PM

    Dietmar's Avatar

    Quite similar problem here with Postgresql.
    I have windows 10 and jre 1.8, incl. Postgresql 10 (64bit).

    What I did:
    Created a new database with pgAdmin 4 (web interface)
    dbname: jbilling_test
    username: jbillinguser
    pwd: jbillingpwd

    I changed the pg_hba.conf into:
    # TYPE DATABASE USER ADDRESS METHOD

    # IPv4 local connections:
    host all all 127.0.0.1/32 trust
    # IPv6 local connections:
    host all all ::1/128 trust

    Then I downloaded the jbilling-community-4.1.1.zip.
    Extracted under C:\jbilling-community-4.1.1\

    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

    But does not help here, still got the same errors like above, refer to attachments.

    Any hints to get the version 4.1.1 running?

    Many thanks
    Dietmar

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Already uploaded files

  • catalina.out 238 KB

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac

 

27 Aug, 2018 06:50 PM
19 Aug, 2018 04:13 PM
19 Aug, 2018 04:04 PM
17 Aug, 2018 03:46 PM
12 Aug, 2018 06:10 PM
18 Jul, 2018 03:01 AM