Home → Questions →

jbilling-community-4.1.1 - db-samples

• Edit

deepak.karanth

13 May, 2016 09:20 AM

In the section that describes steps to initialize the database, it is mentioned that you must run one of the scripts in the jbilling-community-3.x/jbilling/resources/db-samples/ folder.

But in jbilling-community-4.1.1, there is no such folder. Can anyone tell me where the schemes are located?

1. 1 Posted by Vikas@WebDataTe... on 14 May, 2016 12:25 PM

   

   Deepak - It may have been replaced with another folder. Check
   'jbilling-community-3.x/dbscripts'

   Vikas@WebDataTechnologiesLLP

   • Edit

2. 2 Posted by robi on 20 May, 2016 11:36 AM

   

   I have the sam problem and I have tried with
   jbilling 3x script but it is not the same, is missing some tables.

   Do you have any other proposal, please?
   Tnx, Robi

   • Edit

3. 3 Posted by Vikas@WebDataTe... on 20 May, 2016 02:41 PM

   

   Hello Robi,

   Any reason why you would want to try the jBilling 3.x instead of the newer
   and later version 4.x?

   I just checked, 4.x has the scripts. Not sure about 3.x

   [email blocked]

   • Edit

4. 4 Posted by robi on 23 May, 2016 06:25 AM

   

   Hy Vikas

   I'm trying installing jbilling3.x because I have not found script for 4.1.1.
   Where did you verify that they have scripts attached for 4.1.1.?
   And what are the extensive software recommendations?
   I have Operating System: CentOS Linux 7 (Core), Kernel: Linux 3.10.0-327.13.1.el7.x86_64, Architecture: x86-64 and
    java 1.6,java 1.7.java 1.8 I have tried all :), grails 2.4.3

   I have downloaded 4.1.1. from next link:
   https://sourceforge.net/projects/jbilling/
   I tried to use scripts from 3.3.1 but but missing a few tables for 4.4.1.

   I am very grateful to you for your quick response and all your help.
   Br, Robi

   • Edit

5. Support Staff 5 Posted by Technical Suppo... on 24 May, 2016 08:06 AM

   

   Hello Robi,

   Standard configuration for 4.1.1 is JDK 1.8, and grails 2.4.3 should suffice.
   If you download the source zip from here : https://sourceforge.net/projects/jbilling/files/jbilling%20Latest%2... you will find upgrade.sql under sql folder.
   Please follow the Note for mysql database mentioned in the header part of the script. I am also mentioning it here :

   -- MySQL does not support many of the ANSI SQL statements used in this file to upgrade the -- base schema. If you are using MySQL as your database, you will need to edit this file and -- comment out the labeled 'postgresql' statements and un-comment the ones labeled 'mysql'

   Please let us know if require any further information.

   Thanks,
   jBilling Technical Support Team

   • Edit

6. 6 Posted by Vikas@WebDataTe... on 26 May, 2016 05:29 PM

   

   Hello Robi,

   Since you have installed jDK1.8 and grails 2.4.3, I recommend you build
   from source. Follow a guide, google and you should find a few.

   Let me know if you need any help along the way.

   [email blocked]

   • Edit

7. Support Staff 7 Posted by Technical Suppo... on 27 May, 2016 06:10 AM

   

   Hello Robi,

   Please, Let us know if you are still facing same issue else we can close this ticket .

   Thank you
   jBilling Technical Support Team

   • Edit

8. 8 Posted by robi on 27 May, 2016 07:48 AM

   

   Hello
   I'm downloaded jbilling from your link and I'm still working on the script update.sql because I have some errors, especially in the ALTER TABLE statement ....(mysql error ,... , like example:
   " alter table item_price_timeline add constraint item_timeline_price_model_id_FK foreign key (price_model_id) references price_model Error Code: 1215. Cannot add foreign key constraint" )

   My version of mysql is: mysql Ver 14.14 Distrib 5.7.11, for Linux (x86_64).
   For basic DB I have taken base script of Jbilling-community-3.0.2. Is this OK?
   I have never worked with build from source, so I have to try to change upgrade.sql scripts for the purposes of MySQL.
   Please give a few more day and I will give you feedback.
   Thanks for understanding.
   BR

   • Edit

9. Support Staff 9 Posted by Technical Suppo... on 31 May, 2016 12:05 PM

   

   Hello Robi,

   My understanding from above discussion is that you are building from source from 4.1.1 version, but using DB from version 3.0.2? This would not work. You will need to build DB from the same version (4.1.1) if you are using the source of that version. Please let me know if you need additional inputs/help on this.

   Thanks,
   jBilling Technical Support Team.

   • Edit

10. 10 Posted by robi on 24 Jun, 2016 12:00 PM

    

    I wanted to upgrade a base from 3:02 to 4.1.1, because until now I have found only mysql database script for 3.02 and not for 4.1.1 version.
    Building from source not know how to do :(.

    If you cuold help me any way with mysql scripts for 4.1.1 version, and some download link for linux app I would be very thankful.
    Br, Robi

    • Edit

11. 11 Posted by pandit_dhirendr... on 04 Jan, 2021 01:01 AM

    

    For version 4.1.1, You need to use available with source under folder liquibase-3.2.3/liquibase. for reference, you can refer generate_hsql_script.sh file.

    • Edit