SQL Error on fresh installation

[Zaarin]

@Sebastian-Roth Here is the answer of dpkg:

ii  mysql-client                       5.7.12-0ubuntu1                                   all          MySQL database client (metapackage depending on the latest version)
ii  mysql-client-5.7                   5.7.12-0ubuntu1                                   amd64        MySQL database client binaries
ii  mysql-client-core-5.7              5.7.12-0ubuntu1                                   amd64        MySQL database core client binaries
ii  mysql-common                       5.7.12-0ubuntu1                                   all          MySQL database common files, e.g. /etc/mysql/my.cnf
ii  mysql-server                       5.7.12-0ubuntu1                                   all          MySQL database server (metapackage depending on the latest version)
ii  mysql-server-5.7                   5.7.12-0ubuntu1                                   amd64        MySQL database server binaries and system database setup
ii  mysql-server-core-5.7              5.7.12-0ubuntu1                                   amd64        MySQL database server binaries
ii  php-mysql                          1:7.0+36+deb.sury.org~xenial+1                    all          MySQL module for PHP [default]
ii  php7.0-mysql                       7.0.5-3+donate.sury.org~xenial+1                  amd64        MySQL module for PHP

Thanks for taking time.

Zaza.

[Sebastian Roth]

@Zaarin Sorry, didn’t mean you with the mysql version but it’s still good to know. Please give us a little more time to look into this. Feels like this might be quite a big issue, @Tom-Elliott…

PS: I put your long post into a code box so we don’t need to scroll all that much to see the new answers…

[Wayne Workman]

@Sebastian-Roth said in SQL Error on fresh installation:

On the other hand I am wondering how @Wayne-Workman was able to bring up a 16.04 server without any issues yesterday?!?

to be fair, I haven’t gotten to the fog installation part. I was just nailing down the partitioning.

Let me try here at work real fast (I’ve got far, far, far more powerful servers to play with here).

[Zaarin]

Hello,

To help you a little bit more, here is what I found for some errors:

http://dev.mysql.com/doc/refman/5.7/en/alter-table.html

As of MySQL 5.7.4, the IGNORE clause for ALTER TABLE is removed and its use produces an error.

Unfortunately, the 5.7.12 is the default version on Ubuntu 16.04.

Zaza

[Sebastian Roth]

@Zaarin Good catch but this is not our only issue with mysql 5.7.x I am afraid… I am still not sure if this is something we will be able to fix “soon”?!?

[Quazz]

@Sebastian-Roth Stearing people clear from ubuntu 16.04 seems like the best bet right now.

[Zaarin]

Not really a problem if it’s not fix soon. You know now.

I spoke with my boss and it’s OK to switch back to an former version of Ubuntu. As I cannot found (or I need glasses) the information about compatibility, what is the last version of Ubuntu supported? I will use the fog 0.32 to be able to deploy without any registration.

Thanks for your help,

Zaza.

[Quazz]

@Zaarin 15.10 should work fine, alternatively you could install something like CentOS 7 or such instead if you feel up to that. It should run into less of such issues.

You can deploy without registration in trunk as well, by the way.

[Zaarin]

Hi,

Interesting. This morning I switched back to the 14.04 because I cannot see your post due to an error on the forum. Sorry.

My network is strangely configured because I have a tftp server on windows, a computer database on another and the fog server who only serves to send the packet.

I used that link:

https://wiki.fogproject.org/wiki/index.php/Bypass_Host_Registration

I have an application to manage the database, the tftp config file and the wol. So I run the multicast process in fog and then my application for the tftp and the wol. All is fine without any user action.

I don’t use the fog server as a tftp because I don’t want any menu on the pxe boot in a normal use. Students are ingenious to lose time when they start the computer.

Is that possible with the trunk version? If not, don’t worry but I have no time to change my work immediately. (100 pc to install and 100 old to remove, office 2016 to test and to install, alone…).

Thanks for your help,

Zaza.

[Sebastian Roth]

@Zaarin As you managed to configure your services with an older version of FOG I don’t see why this shouldn’t work with FOG trunk as well. I am pretty sure it will. If not out of the box I am sure we can make it work without too much of a hassle.

[Zaarin]

Hi,

I let you know. I install the trunk version.

Thanks for your help,

Zaza.