Just wanted to state that I’ve made a slight feature adjustment/improvement to the LDAP plugin.
You can now decide to use an AD displayName field for the environment.
Hopefully this makes sense and makes things a little nicer. It does mean to see the changes and make changes, you will have to remove and re-add the plugin. This isn’t overly difficult, just try to remember to get your configuration before hand.
Just an example:
And for creating the new LDAP item:
Try the guts of the script on an affected profile. It won’t hurt anything but might fix it.
rmdir /s /q "C:\Users\<name>\AppData\Local\Microsoft\Windows\WebCache"
@JJ-Fullmer Well what I can do is this. I can reset the FOS Linux kernel back to 4.19.65 base then only apply the usb-c changes to see if its the realtek driver or the usb-c changes causing the troubles. If you have the hardware to test on.
The other thing as like you said, we’ll need the nic vendor and hardware ID either from windows or via FOS Linux lspci or lsusb depending on how the nic is attached.
Finally I got some hours to concentrate on this topic. Turns out it’s not just the root DB password that cannot be set using identical SQL syntax across different DB versions but also the process of creating new user account and granting access. Here is a first proposal of a script to use. So far only tested on MySQL 8.0 (CentOS 8):
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ANSI';
USE fog ;
DROP PROCEDURE IF EXISTS fog.drop_user_if_exists ;
CREATE PROCEDURE fog.drop_user_if_exists()
DECLARE foo BIGINT DEFAULT 0 ;
WHERE User = 'fogdbuser' and Host = '%';
IF foo = 0 THEN
CREATE USER 'fogdbuser'@'%' IDENTIFIED BY 'Passw0rd';
GRANT ALL PRIVILEGES ON fog.* TO 'fogdbuser'@'%';
CALL fog.drop_user_if_exists() ;
DROP PROCEDURE IF EXISTS fog.drop_users_if_exists ;
SET SQL_MODE=@OLD_SQL_MODE ;
Anyone keen to test in their machines (shouldn’t cause any trouble to your DB!) is more than welcome to!! Use:
mysql -u root -p <script.sql
mysql -u fogdbuser -pPassw0rd fog -e "SELECT * FROM images"
mysql -u root -p -e "DROP USER 'fogdbuser'@'%'"
Note: I am constantly updating the initial post to show the state of testing we have done so far.