aggregate
aggregate copied to clipboard
getodk
database_hostname and database_port aren't set in jdbc.properties
If you run the Linux 64 bit Aggregate 1.4.11 installer in command line mode, the variables you set in database_hostname and database_port, don't get passed through to WEB-INF/lib/ODKAggregate-settings.jar/jdbc.properties.
Expect: jdbc.url=jdbc:mysql://12.34.56.89:3306/odk_prod?autoDeserialize=true
Actual: jdbc.url=jdbc:mysql:///odk_prod?autoDeserialize=true
There is also an installer variable:
database_host_port
That is ${database_hostname}:${database_port}
This needs to be set for command line usage, as it is initialized via a postShowPageActionList action (this is the only variable set in this way). So via CLI, it wouldn't be initialized.
This is NOT fixed in v1.4.13.
This message was created automatically by mail delivery software.
A message that you sent could not be delivered to one or more of its recipients. This is a temporary error. The following address(es) deferred:
[email protected] Domain beorse.net has exceeded the max emails per hour (289/250 (115%)) allowed. Message will be reattempted later
------- This is a copy of the message, including all the headers. ------ Received: from o3.sgmail.github.com ([192.254.112.98]:52002) by hp159.hostpapa.com with esmtps (TLSv1.2:ECDHE-RSA-AES128-GCM-SHA256:128) (Exim 4.89) (envelope-from [email protected]) id 1dgMDV-000eys-N0 for [email protected]; Fri, 11 Aug 2017 22:31:57 -0400 DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d=github.com; h=from:reply-to:to:cc:in-reply-to:references:subject:mime-version:content-type:content-transfer-encoding:list-id:list-archive:list-post:list-unsubscribe; s=s20150108; bh=qXKDf3n5yU6L/WUWgBOl02kUMpQ=; b=Bm1kvoUP5H3hQM4/ 3jJ5YnXN5j3Dd+A+0k6p4kCvTrWWMX8Xw+oqX4YkzZ81+reRZBhFlXRIsQUdFsJk 1yRuwVrIPHbQeLdeXhhI8//IA89m6RWnZBwf+7+2Lol5SplFWonWvu7cJ7cltinM kPGOb4I5qDrK7tZ9cjnbzr3VTlg= Received: by filter0555p1mdw1.sendgrid.net with SMTP id filter0555p1mdw1-16208-598E6875-2B 2017-08-12 02:31:17.60151781 +0000 UTC Received: from github-smtp2a-ext-cp1-prd.iad.github.net (github-smtp2a-ext-cp1-prd.iad.github.net [192.30.253.16]) by ismtpd0006p1iad1.sendgrid.net (SG) with ESMTP id J6Xp3XVaS9aE932sTimNtg for [email protected]; Sat, 12 Aug 2017 02:31:17.559 +0000 (UTC) Date: Sat, 12 Aug 2017 02:31:17 +0000 (UTC) From: Open Data Kit [email protected] Reply-To: opendatakit/aggregate [email protected] To: opendatakit/aggregate [email protected] Cc: Subscribed [email protected] Message-ID: opendatakit/aggregate/issues/82/[email protected] In-Reply-To: opendatakit/aggregate/issues/[email protected] References: opendatakit/aggregate/issues/[email protected] Subject: Re: [opendatakit/aggregate] database_hostname and database_port aren't set in jdbc.properties (#82) Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="--==_mimepart_598e6875704cf_38db3fb432425c2c660a1"; charset=UTF-8 Content-Transfer-Encoding: 7bit Precedence: list X-GitHub-Sender: opendatakit-bot X-GitHub-Recipient: jbeorse X-GitHub-Reason: subscribed List-ID: opendatakit/aggregate <aggregate.opendatakit.github.com> List-Archive: https://github.com/opendatakit/aggregate List-Post: mailto:[email protected] List-Unsubscribe: mailto:unsub+000519aff606b06a311bc758cc148a7087759f4ad6702fcf92cf0000000115a62a7592a169ce0ee362b8@reply.github.com, https://github.com/notifications/unsubscribe/AAUZr6hEmKHXQyrHCSZI13q9e7x5Wa1gks5sXQ51gaJpZM4O1SR1 X-Auto-Response-Suppress: All X-GitHub-Recipient-Address: [email protected] X-SG-EID: JVRD81wLmvjBgNlAmNtibjEbEEhcPGKEESixoxP2c45hazmiuEleFMDGk6Pm/9bdkpIwa90CgfZ0OX IflZw4yzixZFSZ4+TpSIOaWxaG7rAL/2gjPNoWSxmDEb5tjFbmXvvtZnmLuTV6Q0IPMlzCQfBbGCVt j/5vN46qH5QFRUttnj3GuWaaiczW0QQaHuBa335aoz9hPbjCUqjjJiZ+yPFHumWtgakGuxbENu3EZI A=
----==_mimepart_598e6875704cf_38db3fb432425c2c660a1 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit
There is also an installer variable:
database_host_port
That is ${database_hostname}:${database_port}
This needs to be set for command line usage, as it is initialized via a postShowPageActionList action (this is the only variable set in this way). So via CLI, it wouldn't be initialized.
This is NOT fixed in v1.4.13.
-- You are receiving this because you are subscribed to this thread. Reply to this email directly or view it on GitHub: https://github.com/opendatakit/aggregate/issues/82#issuecomment-321952084 ----==_mimepart_598e6875704cf_38db3fb432425c2c660a1 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Comment by mitchellsundt
Tuesday Jan 03, 2017 at 19:18 GMT
There is also an installer variable:
database_host_port
That is ${database_hostname}:${database_port}
This needs to be set for command line usage, as it is initialized via a = postShowPageActionList action (this is the only variable set in this way). = So via CLI, it wouldn't be initialized.
This is NOT fixed in v1.4.13.
&mda=
sh;
You are receiving this because you are subscribed to this thread.Reply to this email directly, view it on GitHub, or mute the thread.
This message was created automatically by mail delivery software.
A message that you sent could not be delivered to one or more of its recipients. This is a temporary error. The following address(es) deferred:
[email protected] Domain beorse.net has exceeded the max emails per hour (287/250 (114%)) allowed. Message will be reattempted later
------- This is a copy of the message, including all the headers. ------ Received: from o10.sgmail.github.com ([167.89.101.201]:61897) by hp159.hostpapa.com with esmtps (TLSv1.2:ECDHE-RSA-AES128-GCM-SHA256:128) (Exim 4.89) (envelope-from [email protected]) id 1dgMDU-000exy-0o for [email protected]; Fri, 11 Aug 2017 22:31:56 -0400 DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d=github.com; h=from:reply-to:to:cc:subject:mime-version:content-type:content-transfer-encoding:list-id:list-archive:list-post:list-unsubscribe; s=s20150108; bh=5XsWQ7gO/czJlfJ7SJRSSe2LM74=; b=MlHrU3hBxGy41sw/ pC2U78uJOcMVgyr/RZKTt5zVrZ8O8bhuN9XcjbPCDiFowa3SoGOr1rH81xGXwEya eT7UrZu0dg87/ck+DRMj9ftPX+b9wci+QK7Mc7BMeRf14XFzNCcGNVDIma8lu3mh QkSrV4tMd0FQPYl4CcUbQHuW2CM= Received: by filter0991p1mdw1.sendgrid.net with SMTP id filter0991p1mdw1-14825-598E6874-B 2017-08-12 02:31:16.372189259 +0000 UTC Received: from github-smtp2a-ext-cp1-prd.iad.github.net (github-smtp2a-ext-cp1-prd.iad.github.net [192.30.253.16]) by ismtpd0023p1mdw1.sendgrid.net (SG) with ESMTP id hos3vkh6Q8Kn72tSRF7znw for [email protected]; Sat, 12 Aug 2017 02:31:16.327 +0000 (UTC) Date: Sat, 12 Aug 2017 02:31:16 +0000 (UTC) From: Open Data Kit [email protected] Reply-To: opendatakit/aggregate [email protected] To: opendatakit/aggregate [email protected] Cc: Subscribed [email protected] Message-ID: opendatakit/aggregate/issues/[email protected] Subject: [opendatakit/aggregate] database_hostname and database_port aren't set in jdbc.properties (#82) Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="--==_mimepart_598e6873bc93f_34433fb432425c2c46558"; charset=UTF-8 Content-Transfer-Encoding: 7bit Precedence: list X-GitHub-Sender: opendatakit-bot X-GitHub-Recipient: jbeorse X-GitHub-Reason: subscribed List-ID: opendatakit/aggregate <aggregate.opendatakit.github.com> List-Archive: https://github.com/opendatakit/aggregate List-Post: mailto:[email protected] List-Unsubscribe: mailto:unsub+000519af0d4b42684dc50a7d8601fe4a58b33b978b9b6a3092cf0000000115a62a7392a169ce0ee362b8@reply.github.com, https://github.com/notifications/unsubscribe/AAUZrwdNiSK8eV47Ny0z-19LzwmE4yBVks5sXQ5zgaJpZM4O1SR1 X-Auto-Response-Suppress: All X-GitHub-Recipient-Address: [email protected] X-SG-EID: JVRD81wLmvjBgNlAmNtibjEbEEhcPGKEESixoxP2c46xfaE4RaMGU/iYqJPGo5EqgV6r5FCI++lH3h 3VQjE6YEXcU6orx8lp1aFtjddefAQVg1NSLjKpmmrnE3Ot/BgvFywkDmJcjcHSU1beN0mxhKF8jcq+ N7avs2poSpr7Q6tYp0Ujx38fnmmXifDtjr7uOC6oWg6PpDwA0Mc2YzXZpYdDaESb9PV79FbHU7J3LX o=
----==_mimepart_598e6873bc93f_34433fb432425c2c46558 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit
If you run the Linux 64 bit Aggregate 1.4.11 installer in command line mode, the variables you set in database_hostname and database_port, don't get passed through to WEB-INF/lib/ODKAggregate-settings.jar/jdbc.properties.
Expect: jdbc.url=jdbc:mysql://12.34.56.89:3306/odk_prod?autoDeserialize=true
Actual: jdbc.url=jdbc:mysql:///odk_prod?autoDeserialize=true
-- You are receiving this because you are subscribed to this thread. Reply to this email directly or view it on GitHub: https://github.com/opendatakit/aggregate/issues/82 ----==_mimepart_598e6873bc93f_34433fb432425c2c46558 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit
Monday Dec 12, 2016 at 10:19 GMT
Originally opened as opendatakit/opendatakit#1262 (1 comment(s))
If you run the Linux 64 bit Aggregate 1.4.11 installer in command line mode, the variables you set in database_hostname and database_port, don't get passed through to WEB-INF/lib/ODKAggregate-settings.jar/jdbc.properties.
Expect: jdbc.url=jdbc:mysql://12.34.56.89:3306/odk_prod?autoDeserialize=true
Actual: jdbc.url=jdbc:mysql:///odk_prod?autoDeserialize=true
—
You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHub, or mute the thread.
----==_mimepart_598e6873bc93f_34433fb432425c2c46558--
Welcome to Open Data Kit, @ggalmazor! We just sent you an invite to collaborate on this repository at https://github.com/opendatakit/aggregate/invitations. Please accept this invite in order to claim this issue and begin a fun and rewarding experience contributing to Open Data Kit!
Here are some tips to get you off to a good start:
- Please read the README.md and CONTRIBUTING.md in this repo. Those two documents have much of what you need to get started.
- Join the ODK developer Slack to get help, chat about this issue, and meet the other developers.
- Sign up and introduce yourself on the ODK community forum to meet the broader ODK community.
See you on the other side (that is, the pull request side)!
Attention! We're housekeeping! This issue will automatically be closed if no feedback is received in one week.
If this issue is important to you or you can provide more information about it, please, do so as soon as possible :)
Hello @ggalmazor, you have been unassigned from this issue because you have not updated this issue or any referenced pull requests for over 10 days.
You can reclaim this issue or claim any other issue by commenting @opendatakit-bot claim on that issue.
Thanks for your contributions, and hope to see you again soon!
@ggalmazor Can you confirm that running the installer in command line mode on Ubuntu passes the database_hostname and database_port to WEB-INF/lib/ODKAggregate-settings.jar/jdbc.properties?
