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
    ,

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

Recent Discussions

12 Aug, 2018 06:10 PM
18 Jul, 2018 03:01 AM
12 Jul, 2018 07:39 AM
10 Jul, 2018 07:29 AM
09 Jul, 2018 03:38 PM

 

09 Jul, 2018 09:46 AM
10 Apr, 2018 04:19 PM
28 Mar, 2018 10:39 AM
15 Mar, 2018 08:23 AM
26 Feb, 2018 11:19 AM
07 Feb, 2018 02:33 AM