guacamole-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hawkins, Richard" <richard.hawk...@medctrbarbour.org>
Subject RE: 9.11 testing
Date Thu, 19 Jan 2017 05:08:02 GMT
Yea.  Looks like it is an issue with the Mariadb that centos 7 uses.  I install on unbuntu
16 server without any issues..

That will have to be looked at..  THANKS!



-----Original Message-----
From: Mike Jumper [mailto:mike.jumper@guac-dev.org]
Sent: Tue 1/17/2017 9:38 AM
To: user@guacamole.incubator.apache.org
Subject: RE: 9.11 testing
 
What version of MySQL / MariaDB are you using?


On Jan 17, 2017 05:43, "Hawkins, Richard" <richard.hawkins@medctrbarbour.org>
wrote:

> Looks like the same script to me..
>
> When I run the sql to update...  Her I ran as guacadmin and root..
>
> [root@guac upgrade]# mysql -u guacadmin -p guac_db <
> upgrade-pre-0.9.11.sql
> Enter password:
> ERROR 1067 (42000) at line 24: Invalid default value for 'password_date'
> [root@guac upgrade]# mysql -u root -p guac_db < upgrade-pre-0.9.11.sql
> Enter password:
> ERROR 1067 (42000) at line 24: Invalid default value for 'password_date'
>
> When I try to access the site..   /var/log/messages displays this..
>
> Jan 17 07:27:14 guac server: 07:27:14.448 [http-bio-8080-exec-9] ERROR
> o.a.g.rest.RESTExceptionWrapper - Unexpected internal error:
> Jan 17 07:27:14 guac server: ### Error querying database.  Cause:
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column
> 'password_date' in 'field list'
> Jan 17 07:27:14 guac server: ### The error may exist in
> org/apache/guacamole/auth/jdbc/user/UserMapper.xml
> Jan 17 07:27:14 guac server: ### The error may involve defaultParameterMap
> Jan 17 07:27:14 guac server: ### The error occurred while setting
> parameters
> Jan 17 07:27:14 guac server: ### SQL: SELECT
> user_id,             username,             password_hash,
> password_salt,             password_date,             disabled,
> expired,             access_window_start,
> access_window_end,             valid_from,
> valid_until,             timezone         FROM guacamole_user
> WHERE             username = ?
> Jan 17 07:27:14 guac server: ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
> Unknown column 'password_date' in 'field list'
> Jan 17 07:27:14 guac server: Jan 17, 2017 7:27:14 AM
> com.sun.jersey.spi.container.ContainerResponse logException
> Jan 17 07:27:14 guac server: SEVERE: Mapped exception to response: 500
> (Internal Server Error)
> Jan 17 07:27:14 guac server: org.apache.guacamole.rest.APIException
>
> Thanks..
>
>
>
>
>
> -----Original Message-----
> From: Mike Jumper [mailto:mike.jumper@guac-dev.org
> <mike.jumper@guac-dev.org>]
> Sent: Sun 1/15/2017 11:47 PM
> To: user@guacamole.incubator.apache.org
> Subject: Re: 9.11 testing
>
> On Sun, Jan 15, 2017 at 5:40 AM, Hawkins, Richard
> <richard.hawkins@medctrbarbour.org> wrote:
> >
> > I have been playing around with the latest code.  9.11
> >
>
> 0.9.11*
>
> > I have everything compiled and starting but I am just getting a blank
> > screen.
> >
> > The last time I saw this I needed to update the sql database using the
> > "upgrade-pre-0.9.10.sql"  file
> >
>
> Very plausible. Checking the Tomcat logs should yield some information
> supporting this, too.
>
> > So this time I use the "upgrade-pre-0.9.11.sql"  using the normal
> > command..   mysql -u admin -p guac_db < upgrade-pre-0.9.11.sql
> >
> > But it always comes back..   ERROR 067 (42000) at line 80:  Invalid
> > default value for 'password_date'
> >
>
> Odd ... There isn't a line 80. That script is 49 lines at the moment:
>
> https://github.com/apache/incubator-guacamole-client/blob/
> 72199577634f387cfa809a0c6544aa2c108abf9d/extensions/
> guacamole-auth-jdbc/modules/guacamole-auth-jdbc-mysql/
> schema/upgrade/upgrade-pre-0.9.11.sql
>
> Does the script you're using differ from the above?
>
> - Mike
>
>


Mime
View raw message