SQL Error on fresh installation

[Zaarin]

Thanks for the link but I don’t think it’s the same problem. For instance the first error is a pure sql syntax :

Update ID: 1 - 10

Database Error:

Incorrect integer value: ‘’ for column ‘uId’ at row 1

Database SQL:

INSERT INTO fog.users VALUES (’’,‘fog’, MD5(‘password’),‘0000-00-00 00:00:00’,’’)

I did a describe users in the database and I saw that uId is auto increment so the right syntax is :

INSERT INTO `fog`.`users` (uName, uPass, uCreatedDate, uCreateBy) VALUES ('fog', MD5('password'),'0000-00-00 00:00:00','')

I do step by step since this morning, maybe I will have more problem later but I want inform you that the SQL have some errors. I can correct myself some but not all because I cannot guess some default value.

Unfortunately, install another ubuntu version is not an option. Sorry.

Zaza.

[Quazz]

@Zaarin The error is mentioned in the thread somewhere, it has to do with the new mysql-server version doing things a bit differently.

[Sebastian Roth]

@Zaarin A couple of your error messages are the same as in the thread Quazz mentioned (like Incorrect integer value) but there are other errors as well. We definitely need to look into this. On the other hand I am wondering how @Wayne-Workman was able to bring up a 16.04 server without any issues yesterday?!? Different mysql-server version (dpkg -l | grep -e "mysql" -e "maria")?

[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.