Best posts made by Fernando Gietz

Hi,

some info about this, actually my “poor” server is drowned by the high use of mysql. We have noticed the start of the new academic year and the computer are waking up

Now the mysql consumes the 300% of the CPU, we have 8 vcore in the server.

# mysqladmin status;
Uptime: 229755  Threads: 62  Questions: 181260860  Slow queries: 9385  Opens: 155223  Flush tables: 2  Open tables: 400  Queries per second avg: 788.931

Is possible have the mysql server out of the fog server, use an external instance?

@Wayne-Workman I agree with you, and it is a little confusing.

But the philosophy of Location plugin is different.
From https://wiki.fogproject.org/wiki/index.php?title=Location_Plugin:

The location plugin is for use in multi-node fog setups that have a large distance or limited amount of bandwidth between each node’s network. The location plugin allows you to restrict a host’s storage node selection when imaging or other tasks occur.

At first I tried to use Location plugin to do the filters in the searches, and worked well but the Locations have limitations. The big one is that you can only define one location per storage node And I need more granularity. In my case I have one storage node to manage 7000 hosts in 50 buildings with 60 technicians. I don’t need the Location plugin but I need the Site plugin.

We could extend the scope of Location plugin and rewrite the plugin

Hello @neiliob1973 ,

which version of dnsmasq are you using? Do you use dnsmasq as proxy?

Some info about this problem:

Please enter the TFTP issues with Cisco WS-C2960X-48TS-L
Compiling dnsmasq 2.76 if you need uefi support

Some reports, like “imaging log”, don’t have pre filters and try to show all the entries in the database, normally you have a lot of entries in the database and the server doesn’t have memory to run it.

In the dev-branch, not stable branch, I made some changes in the reports to have some pre-filters, with these pre-filters you can limit more the search parameters and be more exhaustive and use less memory

@Wayne-Workman said in Site Plugin:

@Fernando-Gietz Ok then - but perhaps a different name then? How about “Site Control” similarly named after “Access Control”.

Yes, is a good idea. I need change somethings in the code … rename all clases XD

I have installed fog under RHEL 7 and the installation script doesn’t detect well the OS.
To solve it, please change the lib/commons/input.sh line 24:

"Redhat" change to "Red Hat"

14500 computers in the database are a lot of. I had troubles in the past when I tried to list my 8000 computers, this was solved with the php-fpm module but maybe in you case the problem is other (timeouts in the database or used memory)

Any error in the apache logs?

Well I have finished the beta version, you can test it from the last RC version (1.4.0-RC12).

What does the site plugin do?
The site plugin allows you to restrict/control the access and the searches of hosts to one or more sites. When you associate one user to a site, this user only can see the hosts which are linked/located to this site. This plugin restricts the access to hosts in the task menu too, the user only can see the tasks of his hosts.

Brief operation instructions

1. Install the plugin
2. Go to Site Manager Menu
3. Create a New Site
   3.1) Enter the site name and his description
4. Link the hosts to the site. You can do it from the host menu or from group menu
   4.1) From host menu: Enter in the host General tab and select the site from “Associate Host to a site” dropbox
   4.2) From group menu: with this option you can link multiple hosts to one site. Go to the “Site Association” tab and select the site from the dropbox.
5. Link users to one site
   5.1) Go to Site Manager menu.
   5.2) Search or list the Sites. Choose the site.
   5.3) Go to membership tab
   5.4) Check the checkbox to show the user list
   5.5) Select the users which you want to link to the Site
   5.6) click the “Add User to Site” button
6. Restrict the access to the users
   6.1) Go to User Menu
   6.2) Search the user and select it. In the list you can see the sites that are inked to the user and if is a restrinc user.
   6.3) Go to General tab
   6.4) If you want to restrict the user, check the “Is restricted user” checkbox
   6.5) Click “Update” button

With the last revision I can see the multicast scheduled tasks

Thanks !!!

I will not drop the msShutdown and msMaxwait columns (I don´t know if in this version are neccesary), I will only add the new columns. Try with this:

ALTER TABLE multicastSessions
ADD COLUMN msAnon3 VARCHAR(250) AFTER msNFSGroupID;

ALTER TABLE multicastSessions
ADD COLUMN msAnon4 VARCHAR(250) AFTER msAnon3;

Hi falco,

sorry for my late answer, I don’t see this message until now.

With the new version of FOG 1.4.0-RC-12 I don’t have problems when I add a new rule.

It is solved with the last version 6150

Hola @oliver!

Es mejor que te expreses en inglés ya que la mayoría de los usuarios de la comunidad de FOG project no sabe hablar español o tiene conocimientos muy pequeños de él.

Hay dos usuarios fog, uno usuario del sistema linux y otro que es el administrador de la consolo web. son usuarios diferentes con claves diferentes. El usuario fog de linux, llamado fogproject en versiones superiores a la 1.5.5, se encarga de mover y copiar los ficheros de /images usando FTP. La contraseña que aparece en /opt/fog/.fogsettings no está encriptada, parece pero no, es un churro bien largo creado aleatoriamente. Tienes que comprobar que el usuario fog en esa maquina accede con esa contraseña.

Comprueba que /images2, el directorio, tiene permisos 777 para que el usuario fog de linux pueda acceder a él.

As @wayne-workman said me, I post the output of my dual system: W10 LTSB 2016 and Ubuntu 16.04

root@U032668:~# gdisk -l /dev/sda
GPT fdisk (gdisk) version 1.0.1

Partition table scan:
  MBR: protective
  BSD: not present
  APM: not present
  GPT: present

Found valid GPT with protective MBR; using GPT.
Disk /dev/sda: 500118192 sectors, 238.5 GiB
Logical sector size: 512 bytes
Disk identifier (GUID): 611A1A7F-D5E7-4EB5-87EF-D447B71A8595
Partition table holds up to 128 entries
First usable sector is 34, last usable sector is 500118158
Partitions will be aligned on 2048-sector boundaries
Total free space is 924269 sectors (451.3 MiB)

Number  Start (sector)    End (sector)  Size       Code  Name
   1          923648         1128447   100.0 MiB   EF00  EFI system partition
   2         1128448         1161215   16.0 MiB    0C01  Microsoft reserved ...
   3         1161216       205961215   97.7 GiB    0700  Basic data partition
   4       205961216       483586047   132.4 GiB   8300  
   5       483586048       500117503   7.9 GiB     8200  
root@U032668:~# lsblk
NAME   MAJ:MIN RM   SIZE RO TYPE MOUNTPOINT
sda      8:0    0 238,5G  0 disk 
├─sda1   8:1    0   100M  0 part /boot/efi
├─sda2   8:2    0    16M  0 part 
├─sda3   8:3    0  97,7G  0 part 
├─sda4   8:4    0 132,4G  0 part /
└─sda5   8:5    0   7,9G  0 part [SWAP]
sr0     11:0    1  1024M  0 rom  
root@U032668:~# blkid
/dev/sda1: UUID="A47A-9C4F" TYPE="vfat" PARTLABEL="EFI system partition" PARTUUID="90659379-55aa-43cc-a916-7909278e69d2"
/dev/sda2: PARTLABEL="Microsoft reserved partition" PARTUUID="ff774eb9-c85f-4dae-aac5-9a8efd46e7b4"
/dev/sda3: UUID="385A3AFA5A3AB48A" TYPE="ntfs" PARTLABEL="Basic data partition" PARTUUID="54366076-6bce-46ae-9046-8528edf1876f"
/dev/sda4: UUID="e3fa93df-c9a8-4b1c-bcaf-7886256709cb" TYPE="ext4" PARTUUID="c1db2263-cf34-4d82-9954-2484e2c8bdde"
/dev/sda5: UUID="c2fec154-bb2c-454c-ad54-8ca7ab1af203" TYPE="swap" PARTUUID="530e6d65-e5d7-4f4c-bb3b-44ccc6305467"
root@U032668:~# pvdisplay
El programa «pvdisplay» no está instalado. Puede instalarlo escribiendo:
apt install lvm2
root@U032668:~# lgdisplay
No se ha encontrado la orden «lgdisplay», quizás quiso decir:
 La orden «lvdisplay» del paquete «lvm2» (main)
 La orden «vgdisplay» del paquete «lvm2» (main)
lgdisplay: no se encontró la orden
root@U032668:~# lvdisplay
El programa «lvdisplay» no está instalado. Puede instalarlo escribiendo:
apt install lvm2

This issue is solved in version 6150

Please check if you have free space in /var.
I had this problem sometimes in the past.

@ragnurenson , @fenix_team I have fixed the bugs in working branch. Works so fine that now I am using it XD

Site plugin version 1.5.5_1

Problem solved, the /var folder was full. Now I can update the version.

Hi @lenels2eng ,

No, you can not hide the tabs. AccessControl plugin only can “hide” the menu, the icon in the top, and submenu entries, the options that are in the left.

Hi @george1421,

I tried to do it and worked fine!! You can use an external database changing the both files: /var/www/html/fog/lib/fog/config.class.php adn /opt/fog/.fogsettings.

snmysqluser='<MySQL_user>'
snmysqlpass='<password_of_your_MySQL_user>'
snmysqlhost='<ip_of_your_MySQL_Server>'

I don’t do any fresh install lastly, then I don’t know if the installer asks you about the location of your MySQL server or by default is always localhost. If the installer is not prepare to use an external database, I will suggest to implement this feature in future versions.

I want to take advantage of the occasion to say that the mariadb version, 5.5 is obsolete, I updated it to the last stable version the last month, MariaDB 10.3. Maybe will be interesant to update the installer to install this last version of MariaDB.

Under RedHat 7 the packages are MariaDB-client and MariaDB-server.