It seems that the user "odk_user" does not have access to the
database. Could you make sure that you have created this user and a
database with the same name ?
···
On 22 January 2013 15:27, avadhani ramakrishna wrote:
>
Is it possible to create an Aggregate server in localhost? else it should
need public IP ? Please help me the way to resolve this 401 issue....By the
way i am using MySql server 5.5 only... NOT 5.2...
Thanks for reply... Anyway these issues are with Aggregate1.2.0 installer
file. So, i have used Aggregate 1.0.2(deprecated one) and using 1.0.2,
server is working fine. I will try with what you have suggested by using
1.2.0. Please try to release a new version of Aggregate installer with
"Time issue" fix.
Thanks
Avadhani Ramakrishna.
···
On Tuesday, 22 January 2013 19:53:04 UTC+5:30, avadhani ramakrishna wrote:
>
> I have installed tomcat 6.0 and mysql 5.2 and instead of using Aggregate
> server to store the data, i am using Tomcat server in localhost.
>
> Steps followed after installing Tomcat and MySql:
> 1. ODK Aggregate v1.2.0 windows-installer.exe and provided all the
> information required and got a Aggregate.war file in local ODK Aggregate
> directory.
> 2. Accessed Mysql from the command prompt and accessed MySql with "mysql
> --user root --password password"
> 3. Created the database.
> 4. Copied the Aggregate.war into my tomcat\webapps directory, started the
> service.
> 5. A page is displayed with "Login using Aggregate Account", "Login with
> Google", "Anonymous Access".
> 6. I clicked "Sign in with Google" and entered the Credentials.
>
> Now, I got an error like this: *HTTP Status 401 - Authentication Failed:
> Log in failed - identity could not be verified.*
> *
> *
> *Googled a lot, but of no use.I am adding catalina.log file. Please
> verify and help me.*
>
Try "Login using Aggregate Account" logging in with the username that you created during ODK Aggregate instillation and use default password "Aggregate" or "aggregate", after logging in can create new users and passwords and change password of the current user too.
The database configuration script would have set up that 'odk_user@localhost'
account. Please verify that the script produced the same output as
indicated in the README.html. If you need to re-run the script, to get
back to a clean state, you will need to run mysql as root and:
drop database YOUR_DATABASE_NAME_GOES_HERE;
drop user 'odk_user'@'localhost';
Then re-run the script and verify that it produces the output indicated in
the README.html.
Also, we have tested with MySQL 5.1 and 5.5. While I don't know any reason
why the database configuration script would not execute successfully on
5.2, is there any reason you have not used 5.5?
We determined this from this error in the catalina log:
Caused by:
org.opendatakit.common.persistence.exception.ODKDatastoreException:
org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get
JDBC Connection; nested exception is java.sql.SQLException: Unable to open
a test connection to the given database. JDBC url =
jdbc:mysql://localhost/sims_db?autoDeserialize=true, username = odk_user.
Terminating connection pool. Original Exception: ------
java.sql.SQLException: Access denied for user 'odk_user'@'localhost' (using
password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
Mitch
···
On Tue, Jan 22, 2013 at 7:21 AM, Guillaume Lederrey < guillaume.lederrey@gmail.com> wrote:
Hello !
It seems that the user "odk_user" does not have access to the
database. Could you make sure that you have created this user and a
database with the same name ?
You are getting closer. The issues with MySQL are fixed.
There seems to be an issue with the clock on your system:
Jan 23, 2013 12:18:10 PM org.openid4java.consumer.AbstractNonceVerifier seen
WARNING: Nonce is too old: 2013-01-23T06:39:51ZQHJ8rLvMBxp7hA
Jan 23, 2013 12:18:10 PM org.openid4java.consumer.ConsumerManagerImpl verify
SEVERE: Nonce verification failed.
Please verify that the timezone is set correctly for your computer and that
the local time is as expected; whether or not it is correct, 'set it' to
the correct time.
Also check your computer's BIOS clock (reachable during boot, typically
with the F2 key http://www.mydigitallife.info/comprehensive-list-of-how-key-to-press-to-access-bios-for-various-oem-and-computer-systems/)
to confirm that the BIOS clock time is set correctly.
Finally, if neither of those is incorrect, check to see if the Windows Time
service is running. Search for 'Ser' in your Start Menu run box, and click
on "Services" then scroll down to find the Windows Time service. If this is
running, the system may be getting its time from some other machine on your
network.
Please let me know which of these is wrong, as this is a particularly
vexing problem that I have no first-hand understanding of.
As the timestamps above indicate, the local time is 12:18:10 PM, but the
Nonce timestamp is UTC 6:38:51 which is a very very strange offset from
local time (20 minutes?).
Mitch
···
On Tue, Jan 22, 2013 at 11:47 PM, avadhani ramakrishna < avadhanirk.507@gmail.com> wrote:
Is it possible to create an Aggregate server in localhost? else it should
need public IP ? Please help me the way to resolve this 401 issue....By the
way i am using MySql server 5.5 only... NOT 5.2...
Sorry, there is no 'time issue fix'. I have no system that demonstrates
this problem that I can test against, and, as far as I can tell, it is an
issue with individual machines.
···
On Wed, Jan 23, 2013 at 8:23 PM, avadhani ramakrishna < avadhanirk.507@gmail.com> wrote:
Hello Mitch,
Thanks for reply... Anyway these issues are with Aggregate1.2.0 installer
file. So, i have used Aggregate 1.0.2(deprecated one) and using 1.0.2,
server is working fine. I will try with what you have suggested by using
1.2.0. Please try to release a new version of Aggregate installer with
"Time issue" fix.
Thanks
Avadhani Ramakrishna.
On Tuesday, 22 January 2013 19:53:04 UTC+5:30, avadhani ramakrishna wrote:
I have installed tomcat 6.0 and mysql 5.2 and instead of using Aggregate
server to store the data, i am using Tomcat server in localhost.
Steps followed after installing Tomcat and MySql:
ODK Aggregate v1.2.0 windows-installer.exe and provided all the
information required and got a Aggregate.war file in local ODK Aggregate
directory.
Accessed Mysql from the command prompt and accessed MySql with "mysql
--user root --password password"
Created the database.
Copied the Aggregate.war into my tomcat\webapps directory, started the
service.
A page is displayed with "Login using Aggregate Account", "Login with
Google", "Anonymous Access".
I clicked "Sign in with Google" and entered the Credentials.
Now, I got an error like this: HTTP Status 401 - Authentication
Failed: Log in failed - identity could not be verified.
*
* Googled a lot, but of no use.I am adding catalina.log file. Please
verify and help me.
Thats fine. I would like to ask one question regarding this
link: http://opendatakit.org/help/help-for-hire/. What is the procedure to
add our company to the list? because we are working on building data
collection application using ODK as it is a good framework to implement
data collection. Please let me know regarding this ASAP.
Thanks and Regards
Avadhani Ramakrishna
···
On Friday, 25 January 2013 03:22:32 UTC+5:30, Mitch wrote:
>
> Sorry, there is no 'time issue fix'. I have no system that demonstrates
> this problem that I can test against, and, as far as I can tell, it is an
> issue with individual machines.
>
> On Wed, Jan 23, 2013 at 8:23 PM, avadhani ramakrishna < avadhan...@gmail.com > wrote:
>
>> Hello Mitch,
>>
>> Thanks for reply... Anyway these issues are with Aggregate1.2.0 installer
>> file. So, i have used Aggregate 1.0.2(deprecated one) and using 1.0.2,
>> server is working fine. I will try with what you have suggested by using
>> 1.2.0. Please try to release a new version of Aggregate installer with
>> "Time issue" fix.
>>
>> Thanks
>> Avadhani Ramakrishna.
>>
>>
>> On Tuesday, 22 January 2013 19:53:04 UTC+5:30, avadhani ramakrishna wrote:
>>
>>> I have installed tomcat 6.0 and mysql 5.2 and instead of using Aggregate
>>> server to store the data, i am using Tomcat server in localhost.
>>>
>>> Steps followed after installing Tomcat and MySql:
>>> 1. ODK Aggregate v1.2.0 windows-installer.exe and provided all the
>>> information required and got a Aggregate.war file in local ODK Aggregate
>>> directory.
>>> 2. Accessed Mysql from the command prompt and accessed MySql with "mysql
>>> --user root --password password"
>>> 3. Created the database.
>>> 4. Copied the Aggregate.war into my tomcat\webapps directory, started
>>> the service.
>>> 5. A page is displayed with "Login using Aggregate Account", "Login with
>>> Google", "Anonymous Access".
>>> 6. I clicked "Sign in with Google" and entered the Credentials.
>>>
>>> Now, I got an error like this: *HTTP Status 401 - Authentication
>>> Failed: Log in failed - identity could not be verified.*
>>> *
>>> *
>>> *Googled a lot, but of no use.I am adding catalina.log file. Please
>>> verify and help me.*
>>>
>>
>
>
> --
> Mitch Sundt
> Software Engineer
> University of Washington
> mitche...@gmail.com
As it says at the bottom of the help for hire page, if you would like to
add your company to this list, send an email to contact@opendatakit.org.
···
On Mon, Jan 28, 2013 at 2:59 AM, avadhani ramakrishna < avadhanirk.507@gmail.com> wrote:
Thats fine. I would like to ask one question regarding this link: http://opendatakit.org/help/help-for-hire/. What is the procedure to add
our company to the list? because we are working on building data collection
application using ODK as it is a good framework to implement data
collection. Please let me know regarding this ASAP.
Thanks and Regards
Avadhani Ramakrishna
On Friday, 25 January 2013 03:22:32 UTC+5:30, Mitch wrote:
Sorry, there is no 'time issue fix'. I have no system that demonstrates
this problem that I can test against, and, as far as I can tell, it is an
issue with individual machines.
On Wed, Jan 23, 2013 at 8:23 PM, avadhani ramakrishna < avadhan...@gmail.com> wrote:
Hello Mitch,
Thanks for reply... Anyway these issues are with Aggregate1.2.0
installer file. So, i have used Aggregate 1.0.2(deprecated one) and using
1.0.2, server is working fine. I will try with what you have suggested by
using 1.2.0. Please try to release a new version of Aggregate installer
with "Time issue" fix.
Thanks
Avadhani Ramakrishna.
On Tuesday, 22 January 2013 19:53:04 UTC+5:30, avadhani ramakrishna wrote:
I have installed tomcat 6.0 and mysql 5.2 and instead of using
Aggregate server to store the data, i am using Tomcat server in localhost.
Steps followed after installing Tomcat and MySql:
ODK Aggregate v1.2.0 windows-installer.exe and provided all the
information required and got a Aggregate.war file in local ODK Aggregate
directory.
Accessed Mysql from the command prompt and accessed MySql with
"mysql --user root --password password"
Created the database.
Copied the Aggregate.war into my tomcat\webapps directory, started
the service.
A page is displayed with "Login using Aggregate Account", "Login
with Google", "Anonymous Access".
I clicked "Sign in with Google" and entered the Credentials.
Now, I got an error like this: HTTP Status 401 - Authentication
Failed: Log in failed - identity could not be verified.
*
* Googled a lot, but of no use.I am adding catalina.log file. Please
verify and help me.
--
Mitch Sundt
Software Engineer
University of Washington mitche...@gmail.com
" If you would like to add your company to this list, send an email
to contact@opendatakit.org."
···
On Mon, Jan 28, 2013 at 2:59 AM, avadhani ramakrishna wrote:
> Thats fine. I would like to ask one question regarding this link:
> http://opendatakit.org/help/help-for-hire/. What is the procedure to add our
> company to the list? because we are working on building data collection
> application using ODK as it is a good framework to implement data
> collection. Please let me know regarding this ASAP.
>
> Thanks and Regards
> Avadhani Ramakrishna
>
> On Friday, 25 January 2013 03:22:32 UTC+5:30, Mitch wrote:
>>
>> Sorry, there is no 'time issue fix'. I have no system that demonstrates
>> this problem that I can test against, and, as far as I can tell, it is an
>> issue with individual machines.
>>
>> On Wed, Jan 23, 2013 at 8:23 PM, avadhani ramakrishna wrote:
>>>
>>> Hello Mitch,
>>>
>>> Thanks for reply... Anyway these issues are with Aggregate1.2.0 installer
>>> file. So, i have used Aggregate 1.0.2(deprecated one) and using 1.0.2,
>>> server is working fine. I will try with what you have suggested by using
>>> 1.2.0. Please try to release a new version of Aggregate installer with "Time
>>> issue" fix.
>>>
>>> Thanks
>>> Avadhani Ramakrishna.
>>>
>>>
>>> On Tuesday, 22 January 2013 19:53:04 UTC+5:30, avadhani ramakrishna wrote:
>>>>
>>>> I have installed tomcat 6.0 and mysql 5.2 and instead of using Aggregate
>>>> server to store the data, i am using Tomcat server in localhost.
>>>>
>>>> Steps followed after installing Tomcat and MySql:
>>>> 1. ODK Aggregate v1.2.0 windows-installer.exe and provided all the
>>>> information required and got a Aggregate.war file in local ODK Aggregate
>>>> directory.
>>>> 2. Accessed Mysql from the command prompt and accessed MySql with "mysql
>>>> --user root --password password"
>>>> 3. Created the database.
>>>> 4. Copied the Aggregate.war into my tomcat\webapps directory, started
>>>> the service.
>>>> 5. A page is displayed with "Login using Aggregate Account", "Login with
>>>> Google", "Anonymous Access".
>>>> 6. I clicked "Sign in with Google" and entered the Credentials.
>>>>
>>>> Now, I got an error like this: HTTP Status 401 - Authentication Failed:
>>>> Log in failed - identity could not be verified.
>>>>
>>>> Googled a lot, but of no use.I am adding catalina.log file. Please
>>>> verify and help me.
>>
>>
>>
>>
>> --
>> Mitch Sundt
>> Software Engineer
>> University of Washington
>> mitche...@gmail.com