Can't log onto Aggregate V1.0 with google account on Tomcat server

Hi M8's

I have completed the installment of Tomcat7.0 with MySQL and added the
the Aggregate War file, as descriteped in the readme file and the
windows installer(Aggregate V1.0). In my browser I get the Aggregate
logon page. (I'm running the server on window7 64-bit)

But when trying to log in the server, with my google account, I get
this Error:

"You do not have permission for this action. Error: Invalid
request" (typed in res)

Any help would be very much appreciated here, now that I got this
far!!!

/Martin

With MySQL, be sure you have downloaded the MySQL Connector/J from here:
http://dev.mysql.com/downloads/connector/j/
Then explode the zip and copy the jar file (e.g.,
mysql-connector-java-5.xx.xx.jar ) to the Tomcat lib directory (e.g.,
C:\Program Files\Tomcat\apache-tomcat-7.xx.xxx\lib )

This is an often-overlooked step during the install.

If you did do that and still cannot log in, then look in the
catalina-yyyy-mm-dd.log in the logs directory (e.g., C:\Program
Files\Tomcat\apache-tomcat-7.xx.xxx\logs ). This file will likely contain
an error that will indicate the problem.

Mitch

··· On Fri, Nov 4, 2011 at 7:12 AM, Martin Mosgaard Knudsen < martinmosgaard@gmail.com> wrote:

Hi M8's

I have completed the installment of Tomcat7.0 with MySQL and added the
the Aggregate War file, as descriteped in the readme file and the
windows installer(Aggregate V1.0). In my browser I get the Aggregate
logon page. (I'm running the server on window7 64-bit)

But when trying to log in the server, with my google account, I get
this Error:

"You do not have permission for this action. Error: Invalid
request" (typed in res)

Any help would be very much appreciated here, now that I got this
far!!!

/Martin

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

--
Mitch Sundt
Software Engineer


University of Washington
mitchellsundt@gmail.com

And after copying, you probably need to stop and restart your Tomcat server.

If the problem is not obvious from the log, send it to me (
mitchellsundt@gmail.com ) as an attachment and I'll take a look.

Mitch

··· On Fri, Nov 4, 2011 at 10:11 AM, Mitch Sundt wrote:

With MySQL, be sure you have downloaded the MySQL Connector/J from here:
http://dev.mysql.com/downloads/connector/j/
Then explode the zip and copy the jar file (e.g.,
mysql-connector-java-5.xx.xx.jar ) to the Tomcat lib directory (e.g.,
C:\Program Files\Tomcat\apache-tomcat-7.xx.xxx\lib )

This is an often-overlooked step during the install.

If you did do that and still cannot log in, then look in the
catalina-yyyy-mm-dd.log in the logs directory (e.g., C:\Program
Files\Tomcat\apache-tomcat-7.xx.xxx\logs ). This file will likely contain
an error that will indicate the problem.

Mitch

On Fri, Nov 4, 2011 at 7:12 AM, Martin Mosgaard Knudsen < martinmosgaard@gmail.com> wrote:

Hi M8's

I have completed the installment of Tomcat7.0 with MySQL and added the
the Aggregate War file, as descriteped in the readme file and the
windows installer(Aggregate V1.0). In my browser I get the Aggregate
logon page. (I'm running the server on window7 64-bit)

But when trying to log in the server, with my google account, I get
this Error:

"You do not have permission for this action. Error: Invalid
request" (typed in res)

Any help would be very much appreciated here, now that I got this
far!!!

/Martin

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

--
Mitch Sundt
Software Engineer
http://www.OpenDataKit.org
University of Washington
mitchellsundt@gmail.com

--
Mitch Sundt
Software Engineer


University of Washington
mitchellsundt@gmail.com

Hi Mitch

I have the "mysql-connector-java-5.1.18-bin.jar" file inserted in the
Tomcat lib folder as you descriped. I'm running the "MySQL server,
version 5.5". I can see in the Database that tables have been created
for the ODK Aggregate - so that's good, I think/hope :slight_smile:

I'm sending the Tomcat log to you so you can have a look at it(from
today). It doesn't say much to me!?

Thank for replying.

/Martin

··· On 4 Nov., 18:14, Mitch Sundt wrote: > And after copying, you probably need to stop and restart your Tomcat server. > > If the problem is not obvious from the log, send it to me ( > mitchellsu...@gmail.com ) as an attachment and I'll take a look. > > Mitch > > On Fri, Nov 4, 2011 at 10:11 AM, Mitch Sundt wrote: > > > > > > > > > > > With MySQL, be sure you have downloaded the MySQL Connector/J from here: > >http://dev.mysql.com/downloads/connector/j/ > > Then explode the zip and copy the jar file (e.g., > > mysql-connector-java-5.xx.xx.jar ) to the Tomcat lib directory (e.g., > > C:\Program Files\Tomcat\apache-tomcat-7.xx.xxx\lib ) > > > This is an often-overlooked step during the install. > > > If you did do that and still cannot log in, then look in the > > catalina-yyyy-mm-dd.log in the logs directory (e.g., C:\Program > > Files\Tomcat\apache-tomcat-7.xx.xxx\logs ). This file will likely contain > > an error that will indicate the problem. > > > Mitch > > > On Fri, Nov 4, 2011 at 7:12 AM, Martin Mosgaard Knudsen < martinmosga...@gmail.com> wrote: > > >> Hi M8's > > >> I have completed the installment of Tomcat7.0 with MySQL and added the > >> the Aggregate War file, as descriteped in the readme file and the > >> windows installer(Aggregate V1.0). In my browser I get the Aggregate > >> logon page. (I'm running the server on window7 64-bit) > > >> But when trying to log in the server, with my google account, I get > >> this Error: > > >> "You do not have permission for this action. Error: Invalid > >> request" (typed in res) > > >> Any help would be very much appreciated here, now that I got this > >> far!!! > > >> /Martin > > >> -- > >> Post: opendatakit@googlegroups.com > >> Unsubscribe: opendatakit+unsubscribe@googlegroups.com > >> Options:http://groups.google.com/group/opendatakit?hl=en > > > -- > > Mitch Sundt > > Software Engineer > >http://www.OpenDataKit.org > > University of Washington > > mitchellsu...@gmail.com > > -- > Mitch Sundt > Software Engineerhttp://www.OpenDataKit.org > University of Washington > mitchellsu...@gmail.com

Hi there

I have not jet heard anything regarding my log file. Are you still
there Mitch or is my mails in the spam filter?

If anybody else knows about this problem, I will be glad to hear about
it!?

Here is was happens? (after instll Tomcat, Mysql, JConnection and
setting up the aggregate webapp)
I come to the "ODKAggregate/openid_login.html" page where I can grant
information from a google account.

After pressing "Allow" I get this error:
You do not have permission for this action. Error: Invalid request

I can see in my google account under "Authorized Access to your Google
Account", that the address is now listed.

I running the ODK Aggregate Webapp at port 8080 in the firewall.

/Martin

··· On 6 Nov., 19:31, Martin Mosgaard Knudsen wrote: > Hi Mitch > > I have the "mysql-connector-java-5.1.18-bin.jar" file inserted in the > Tomcat lib folder as you descriped. I'm running the "MySQL server, > version 5.5". I can see in the Database that tables have been created > for the ODK Aggregate - so that's good, I think/hope :) > > I'm sending the Tomcat log to you so you can have a look at it(from > today). It doesn't say much to me!? > > Thank for replying. > > /Martin > > On 4 Nov., 18:14, Mitch Sundt wrote: > > > > > > > > > And after copying, you probably need to stop and restart your Tomcat server. > > > If the problem is not obvious from the log, send it to me ( > > mitchellsu...@gmail.com ) as an attachment and I'll take a look. > > > Mitch > > > On Fri, Nov 4, 2011 at 10:11 AM, Mitch Sundt wrote: > > > > With MySQL, be sure you have downloaded the MySQL Connector/J from here: > > >http://dev.mysql.com/downloads/connector/j/ > > > Then explode the zip and copy the jar file (e.g., > > > mysql-connector-java-5.xx.xx.jar ) to the Tomcat lib directory (e.g., > > > C:\Program Files\Tomcat\apache-tomcat-7.xx.xxx\lib ) > > > > This is an often-overlooked step during the install. > > > > If you did do that and still cannot log in, then look in the > > > catalina-yyyy-mm-dd.log in the logs directory (e.g., C:\Program > > > Files\Tomcat\apache-tomcat-7.xx.xxx\logs ). This file will likely contain > > > an error that will indicate the problem. > > > > Mitch > > > > On Fri, Nov 4, 2011 at 7:12 AM, Martin Mosgaard Knudsen < martinmosga...@gmail.com> wrote: > > > >> Hi M8's > > > >> I have completed the installment of Tomcat7.0 with MySQL and added the > > >> the Aggregate War file, as descriteped in the readme file and the > > >> windows installer(Aggregate V1.0). In my browser I get the Aggregate > > >> logon page. (I'm running the server on window7 64-bit) > > > >> But when trying to log in the server, with my google account, I get > > >> this Error: > > > >> "You do not have permission for this action. Error: Invalid > > >> request" (typed in res) > > > >> Any help would be very much appreciated here, now that I got this > > >> far!!! > > > >> /Martin > > > >> -- > > >> Post: opendatakit@googlegroups.com > > >> Unsubscribe: opendatakit+unsubscribe@googlegroups.com > > >> Options:http://groups.google.com/group/opendatakit?hl=en > > > > -- > > > Mitch Sundt > > > Software Engineer > > >http://www.OpenDataKit.org > > > University of Washington > > > mitchellsu...@gmail.com > > > -- > > Mitch Sundt > > Software Engineerhttp://www.OpenDataKit.org > > University of Washington > > mitchellsu...@gmail.com

I have not received the log file. Please send to me at
mitchellsundt@gmail.com

Mitch

··· On Wed, Nov 9, 2011 at 7:07 AM, Martin Mosgaard Knudsen < martinmosgaard@gmail.com> wrote:

Hi there

I have not jet heard anything regarding my log file. Are you still
there Mitch or is my mails in the spam filter?

If anybody else knows about this problem, I will be glad to hear about
it!?

Here is was happens? (after instll Tomcat, Mysql, JConnection and
setting up the aggregate webapp)
I come to the "ODKAggregate/openid_login.html" page where I can grant
information from a google account.

After pressing "Allow" I get this error:
You do not have permission for this action. Error: Invalid request

I can see in my google account under "Authorized Access to your Google
Account", that the address is now listed.

I running the ODK Aggregate Webapp at port 8080 in the firewall.

/Martin

On 6 Nov., 19:31, Martin Mosgaard Knudsen martinmosga...@gmail.com wrote:

Hi Mitch

I have the "mysql-connector-java-5.1.18-bin.jar" file inserted in the
Tomcat lib folder as you descriped. I'm running the "MySQL server,
version 5.5". I can see in the Database that tables have been created
for the ODK Aggregate - so that's good, I think/hope :slight_smile:

I'm sending the Tomcat log to you so you can have a look at it(from
today). It doesn't say much to me!?

Thank for replying.

/Martin

On 4 Nov., 18:14, Mitch Sundt msu...@cs.washington.edu wrote:

And after copying, you probably need to stop and restart your Tomcat
server.

If the problem is not obvious from the log, send it to me (
mitchellsu...@gmail.com ) as an attachment and I'll take a look.

Mitch

On Fri, Nov 4, 2011 at 10:11 AM, Mitch Sundt <msu...@cs.washington.edu wrote:

With MySQL, be sure you have downloaded the MySQL Connector/J from
here:

http://dev.mysql.com/downloads/connector/j/
Then explode the zip and copy the jar file (e.g.,
mysql-connector-java-5.xx.xx.jar ) to the Tomcat lib directory (e.g.,
C:\Program Files\Tomcat\apache-tomcat-7.xx.xxx\lib )

This is an often-overlooked step during the install.

If you did do that and still cannot log in, then look in the
catalina-yyyy-mm-dd.log in the logs directory (e.g., C:\Program
Files\Tomcat\apache-tomcat-7.xx.xxx\logs ). This file will likely
contain

an error that will indicate the problem.

Mitch

On Fri, Nov 4, 2011 at 7:12 AM, Martin Mosgaard Knudsen < martinmosga...@gmail.com> wrote:

Hi M8's

I have completed the installment of Tomcat7.0 with MySQL and added
the

the Aggregate War file, as descriteped in the readme file and the
windows installer(Aggregate V1.0). In my browser I get the Aggregate
logon page. (I'm running the server on window7 64-bit)

But when trying to log in the server, with my google account, I get
this Error:

"You do not have permission for this action. Error: Invalid
request" (typed in res)

Any help would be very much appreciated here, now that I got this
far!!!

/Martin

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options:http://groups.google.com/group/opendatakit?hl=en

--
Mitch Sundt
Software Engineer
http://www.OpenDataKit.org
University of Washington
mitchellsu...@gmail.com

--
Mitch Sundt
Software Engineerhttp://www.OpenDataKit.org
University of Washington
mitchellsu...@gmail.com

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

--
Mitch Sundt
Software Engineer

University of Washington
mitchellsundt@gmail.com

I also am having this problem: everything's installed fine, the
database is created and populated, and Google lists my Aggregate
domain as being authorised, but after clicking 'Sign in with Google'
in openid_login.html I get sent back to a 403 error page. Upon
reloading that, I get the red text mentioned earlier in this thread:
"You do not have permission for this action. Error: Invalid request".
It's like the OpenID authentication is working fine, but the local
authorisation isn't being determined correctly? My user seems to have
the 'granted authorities' of GROUP_SITE_ADMINS and
ROLE_SITE_ACCESS_ADMIN.

Any ideas on what's going wrong?

  • Sam.
··· On Nov 9, 11:07 pm, Martin Mosgaard Knudsen wrote: > If anybody else knows about this problem, I will be glad to hear about > it!? > > Here is was happens? (after instll Tomcat, Mysql, JConnection and > setting up the aggregate webapp) > I come to the "ODKAggregate/openid_login.html" page where I can grant > information from a google account. > > After pressing "Allow" I get this error: > You do not have permission for this action. Error: Invalid request > > I can see in my google account under "Authorized Access to your Google > Account", that the address is now listed. > > I running the ODK Aggregate Webapp at port 8080 in the firewall.

--
Sam Wilson, Developer.
Utility Asset Management Pty Ltd,
2 Clontarf Road Beconsfield 6162,
Western Australia.
swilson@utilityasset.com.au

sam,

if you have tried the suggestions in the thread and are still stuck,
please file a detailed bug report at
http://code.google.com/p/opendatakit/issues/list and attach a log file
there.

yaw

··· On Thu, Nov 10, 2011 at 03:53, samwilson wrote: > On Nov 9, 11:07 pm, Martin Mosgaard Knudsen wrote: >> If anybody else knows about this problem, I will be glad to hear about >> it!? >> >> Here is was happens? (after instll Tomcat, Mysql, JConnection and >> setting up the aggregate webapp) >> I come to the "ODKAggregate/openid_login.html" page where I can grant >> information from a google account. >> >> After pressing "Allow" I get this error: >> You do not have permission for this action. Error: Invalid request >> >> I can see in my google account under "Authorized Access to your Google >> Account", that the address is now listed. >> >> I running the ODK Aggregate Webapp at port 8080 in the firewall. > > I also am having this problem: everything's installed fine, the > database is created and populated, and Google lists my Aggregate > domain as being authorised, but after clicking 'Sign in with Google' > in openid_login.html I get sent back to a 403 error page. Upon > reloading that, I get the red text mentioned earlier in this thread: > "You do not have permission for this action. Error: Invalid request". > It's like the OpenID authentication is working fine, but the local > authorisation isn't being determined correctly? My user seems to have > the 'granted authorities' of GROUP_SITE_ADMINS and > ROLE_SITE_ACCESS_ADMIN. > > Any ideas on what's going wrong? > > - Sam. > > -- > Sam Wilson, Developer. > Utility Asset Management Pty Ltd, > 2 Clontarf Road Beconsfield 6162, > Western Australia. > swilson@utilityasset.com.au > > -- > Post: opendatakit@googlegroups.com > Unsubscribe: opendatakit+unsubscribe@googlegroups.com > Options: http://groups.google.com/group/opendatakit?hl=en >

[mailto:opendatakit@googlegroups.com] On Behalf Of Yaw Anokwa
google account on Tomcat server

if you have tried the suggestions in the thread and are still stuck,
please file a detailed bug report at
http://code.google.com/p/opendatakit/issues/list and attach a log file
there.

yaw

Thanks. I've raised an issue: http://code.google.com/p/opendatakit/issues/detail?id=420

Hopefully what I've put there makes sense!

  • Sam.
··· > -----Original Message----- > From: opendatakit@googlegroups.com > Sent: Thursday 2011-11-10 13:24 > Subject: Re: [ODK Community] Re: Can't log onto Aggregate V1.0 with