working-1.6 - Login issues with big database

[EduardoTSeoane]

@Tom-Elliott @Sebastian-Roth
First problem with my data base.
Login two slow, I need to increase ProxyTimeout and Timeout get a successfull login

[Sebastian Roth]

@EduardoTSeoane @Tom-Elliott I reckon we should come to a decision with this first. On several occasions we have seen that FOG is not great at handling such huge setups yet. I’d hope we can dig into this and find a good solution. Though I don’t fancy we do this for 1.5.x and 1.6! I opt for focusing on working-1.6 now. But that means we won’t backport anything to 1.5.x! Shall we?

[Sebastian Roth]

@EduardoTSeoane Ok, as I have a bit of time right now I started looking at this.

As a quick was to solve this you can edit /var/www/html/fog/lib/router/route.class.php, jump to line 819 and comment the third columns block as you see below:

...
        case 'storagenode':
            $columns[] = ['db' => 'ngID', 'dt' => 'storagegroupID'];
            $columns[] = ['db' => 'ngName', 'dt' => 'storagegroupName'];
            /*$columns[] = [
                'db' => 'ngmID',
                'dt' => 'online',
                'formatter' => function ($d, $row) {
                    return self::getClass('StorageNode', $d)->get('online');
                }
            ];*/
            $columns[] = [
...

This will make login work way faster I am sure!

I will have to double check if this change might cause trouble in some other places before I push out this as official commit.

Please give it a try and let us know what you think.

[Sebastian Roth]

@EduardoTSeoane Be aware, I already found issues with this quick fix. It will make the web UI a lot faster in a couple of places it also has drawbacks that I need to find and fix…

[Sebastian Roth]

@EduardoTSeoane Ok, found and hopefully fixed all the issues now. I just pushed out a new commit to working-1.6 - please update to the latest and let us know what you think.

[Sebastian Roth]

@EduardoTSeoane Found more issues. Will work in this tomorrow and commit more fixes.

[EduardoTSeoane]

@Sebastian-Roth ok im out ungió Next week. I test It Next week

[Sebastian Roth]

@EduardoTSeoane Did you get to try this out?

[Sebastian Roth]

@EduardoTSeoane Is this still an issue?