SOLVED Fog 1.2 to Fog 1.58 mysql export, after fog.sql import everithing ok, but no hosts in Web Ui

[robo]

Hallo. Please i need some assistence!
After successful exporting mysql db from host running fog 1.2 and after successful import to host running fog 1.58, mysql query see my host and mac table, the count is ok but on the new fog 1.58 web ui nothing lists in hosts.
Thanks

[Sebastian Roth]

@robo Good to know you have fixed this another way. Though I am still wondering if this is a reproducible issue and we might want to fix that in the code. On the other hand 1.2.0 is really old and I am not sure how many people still use it.

[robo]

@Sebastian-Roth
Thank you for your effort. Last night i v tested a new configuration.
The problematic one where
;ubuntu 19.10 amd64 srv from scratch + git branch fog 1.5.8 + mysql import
The configuration from last night;
ubuntu 18.04 LTS amd64 srv, from scratch + manual install fog 1.3+ mysql import + upgrade thru git on the latest master branch fog 1.5.8.
With the second configuration, no problems for now, i must deeply check, but it seems there is no issues.
If there is another issue i v ask for help.
Thank you Sebastian
MfG Boris

[Sebastian Roth]

@robo Could you possibly provide the SQL dump so I can test? Please upload to a file share and send me a private message with the link.

[robo]

@Sebastian-Roth

On FOG 1.2 side, export script with $var (crontab):
"/usr/bin/mysqldump -u $USER --password=$PASSWORD --allow-keywords -f $DATABASE > $SAVEDIR/$DATABASE-$(date ‘+%Y%m%d’).sql

On FOG 1.5.8, import via terminal:
“mysql -D fog -u fogmaster -p*************** < /images/dev/fog-20200402.sql”

When you check in mysql query, everything is by number count ok, the hosts by nummbers are present also mac addresses. Web UI works, groups, images and so on are present, users, login ok, but list all host empty. Thru groups i see members and hostnames, when i cklick on choosen host i get empty “all host” page.

Thanks, Danke Sebastian

[robo]

On FOG 1.2 side, export script with $var (crontab):
"/usr/bin/mysqldump -u $USER --password=$PASSWORD --allow-keywords -f $DATABASE > $SAVEDIR/$DATABASE-$(date ‘+%Y%m%d’).sql

On FOG 1.5.8, import via terminal:
“mysql -D fog -u fogmaster -p*************** < /images/dev/fog-20200402.sql”

When you check in mysql query, everything is by number count ok, the hosts by nummbers are present also mac addresses. Web UI works, groups, images and so on are present, users, login ok, but list all host empty. Thru groups i see members and hostnames, when i cklick on choosen host i get empty “all host” page.

Thanks, Danke Sebastian

[Sebastian Roth]

@robo Which commands did you use to ex- and import the database? We can’t help you without knowing what exactly you did.