SQL Error on fresh installation
-
@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"
)? -
@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.
-
@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…
-
@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).
-
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
-
@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”?!?
-
@Sebastian-Roth Stearing people clear from ubuntu 16.04 seems like the best bet right now.
-
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.
-
@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.
-
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.
-
@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.
-
Hi,
I let you know. I install the trunk version.
Thanks for your help,
Zaza.