error creating account

[David Clark]

I am running KillBill (http://localhost:8080) and Kaui (http://localhost:9090) via Docker, writing to a local MariaDB account using the DDL from the KillBill site.   I have not touched the shiro.ini file (not sure if thats needed or not).   I am trying to create an account against my tenant (only one configured) but I am getting an error when I use the KillBill Java client.

Background:

I log into Kaui and create a tenant

edentalmanager

8dfc986a-356f-43a0-a9a1-65352eaa6d3b

myApiKey

When I look into the kaui database, I see:

  kaui_tenants contains the edentalmanager with this tenant_id and api_key

  kaui_users contains admin user

  kaui_allowed_user contains the admin and another username edmtest (created for tenant 'edentalmanager')

I look at the killbill database and do not see any users or user_roles - is this a problem?

I then use this code to create an account:

final KillBillHttpClient killBillHttpClient =
                new KillBillHttpClient("http://localhost:8080", "admin", "password", "myApiKey", "myApiSecret");

final KillBillClient killBillClient = new KillBillClient(killBillHttpClient);

final String requestId = randomString();
final RequestOptions options =
                RequestOptions.builder().withRequestId(requestId).withCreatedBy(createdBy).withReason("test")
                                .withHeader(JaxrsResource.HDR_CREATED_BY, "demo")
                                .withHeader(JaxrsResource.HDR_REASON, "test")
                                .withHeader(JaxrsResource.HDR_COMMENT, "No comments")
                                .withHeader(JaxrsResource.HDR_API_KEY, "myApiKey")

                                .withHeader(JaxrsResource.HDR_API_SECRET, "myApiSecret").withComment("No comments")

                                .build();

Account account = new Account();
account.setName("Joes Medical Shack");
account.setFirstNameLength(4);  // don't know what this is for
account.setExternalKey("joesMedShack");
account.setCurrency("USD");

Account newAccount = client.createAccount(account, options)

Here is the error:

java.sql.SQLSyntaxErrorException: Unknown column 't.parent_account_id' in 'field list'

I am confused on a couple of points here:

1. I can only get this far if I use the admin/password values - the user I created for this tenant doesn't seem to work
2. I don't know where the tenant id should be used.
3. The connections all see to work, because I am not getting those types of exceptions.  But I don't see why they killbill database is not being used for users.  I do see the killbill.sessions table filled with data from my testing so I am sure that is correctly accessed.

I have watched all the YouTube videos and gone thru the documentation but for some reason the accounts will not create, effectively blocking me.

[David Clark]

Just an update to help troubleshoot this:

I am using the java client 0.39 in which the Account.java does have a field "parentAccountId"  but the DDL script I downloaded does not seem to match this or several other fields.  What versions of the client and DDL should I be using - knowing that I need to be on KillBill 0.18 as soon as its released.

[Pierre-Alexandre Meyer]

Hi David,

We are still in the process of releasing 0.18.x, that's why it hasn't been publicized yet. We will update the website, DDL, etc. in the coming weeks.

In the meantime, if your database is on 0.16.x, make sure to apply the DDL script from the release page (https://github.com/killbill/killbill/releases/tag/killbill-0.18.0). Also, in each repository, the README will tell you which version to use (see https://github.com/killbill/killbill-client-java/blob/master/README.md for instance).

Hope that helps!

--
You received this message because you are subscribed to the Google Groups "Kill Bill users mailing-list" group.
To unsubscribe from this group and stop receiving emails from it, send an email to killbilling-users+unsubscribe@googlegroups.com.
To post to this group, send email to killbilling-users@googlegroups.com.
Visit this group at https://groups.google.com/group/killbilling-users.

To view this discussion on the web visit https://groups.google.com/d/msgid/killbilling-users/7a728068-204f-4c28-b95c-0cb35cfe86f1%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--

Pierre

[di...@wso2telco.com]

> I can only get this far if I use the admin/password values - the user I created for this tenant doesn't seem to workI don't know where the tenant id should be used.The connections all see to work, because I am not getting those types of exceptions.  But I don't see why they killbill database is not being used for users.  I do see the killbill.sessions table filled with data from my testing so I am sure that is correctly accessed.

> I have watched all the YouTube videos and gone thru the documentation but for some reason the accounts will not create, effectively blocking me.
>
>
>
>
>
>
> --
>
> You received this message because you are subscribed to the Google Groups "Kill Bill users mailing-list" group.
>

> To unsubscribe from this group and stop receiving emails from it, send an email to killbilling-us...@googlegroups.com.
>
> To post to this group, send email to killbill...@googlegroups.com.

>
> Visit this group at https://groups.google.com/group/killbilling-users.
>
> To view this discussion on the web visit https://groups.google.com/d/msgid/killbilling-users/7a728068-204f-4c28-b95c-0cb35cfe86f1%40googlegroups.com.
>
>
>
> For more options, visit https://groups.google.com/d/optout.
>
>
>
>
>
> --
>
>
> Pierre

Hi Meyer,


any update about DDL files for 0.18.4 release?

Thanks

[Pierre-Alexandre Meyer]

Hi Dilan,

The DDL can be found at http://docs.killbill.io/0.18/ddl.sql.

Since 0.18.x is the current stable release version, the latest documentation at http://docs.killbill.io/ now applies.

On Fri, Jul 28, 2017 at 4:56 AM, dilan via Kill Bill users mailing-list <killbill...@googlegroups.com> wrote:

Hi Meyer,


any update about DDL files for 0.18.4 release?

Thanks

--

Pierre