| 61 | == infoparameterclients(sql_user,sql_pass,database,repo,namecompany,clientproxy,clientntp,mcastaddress,mcastmethod,mcastmaxbitrate,hostnamemethod,hostnamefile,hosnamevariables,cloneimagentfs,cloneimageext23) == |
| 62 | DESCRIPCION: datos ubicados en EAC.conf que ahora se pasan como parametros del kernel. |
| 63 | |
| 64 | |
66 | | ** `infonetaulas` (id_aula, descripcion, subred, netmask, broadcast, gateway, repo_image, repo_client)[[BR]] |
| 70 | == `infonetaulas` (id_aula, descripcion, subred, netmask, broadcast, gateway, repo_image, repo_client) == |
90 | | == Informacion sobre Equipos == |
| 94 | = Informacion sobre Equipos = |
| 95 | ==EAC -> `infonetequipos` ( hostname, macaddress, ipaddress, arranque, aula, startpage, vga, acpi, pci) == |
| 96 | * PRIMARY KEY (`hostname`), UNIQUE KEY `mac` (`macaddress`), UNIQUE KEY `ip` (`ipaddress`) |
| 97 | * DESCRIPCION: información para usarlo el BootServer para configurar el fichero pxe especifico de un equipo. arranque=menuboot, aula+starpage=scripts que debe ejecutar, vga, acpi y pci son parametros detectados por el cliente la primera vez que ese equipo arranca.[[BR]] |
98 | | CREATE TABLE IF NOT EXISTS `infonetequipos` ( |
99 | | `hostname` varchar(32) collate utf8_spanish_ci NOT NULL, |
100 | | `macaddress` varchar(18) collate utf8_spanish_ci NOT NULL, |
101 | | `ipaddress` varchar(15) collate utf8_spanish_ci NOT NULL, |
102 | | `arranque` varchar(7) collate utf8_spanish_ci NOT NULL default 'pxe', |
103 | | `aula` tinyint(4) NOT NULL, |
104 | | `startpage` varchar(50) collate utf8_spanish_ci default 'default.sh', |
105 | | `vga` varchar(5) collate utf8_spanish_ci default '791', |
106 | | `acpi` enum('on','off') collate utf8_spanish_ci NOT NULL default 'on', |
107 | | `pci` enum('msi','nomsi') collate utf8_spanish_ci NOT NULL default 'msi', |
108 | | PRIMARY KEY (`hostname`), |
109 | | UNIQUE KEY `mac` (`macaddress`), |
110 | | UNIQUE KEY `ip` (`ipaddress`) |
111 | | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci; |
| 102 | HIDRA `ordenadores` (idordenador, nombreordenador, ip, mac, idaula`, idperfilhard` idservidordhcp, idservidorrembo, grupoid,idconfiguracion , idmenu, idparticion, cache |
113 | | -- |
114 | | -- Dumping data for table `infonetequipos` |
115 | | -- |
116 | | |
117 | | INSERT INTO `infonetequipos` (`hostname`, `macaddress`, `ipaddress`, `arranque`, `aula`, `startpage`, `vga`, `acpi`, `pci`) VALUES |
118 | | ('r60', '00:13:77:66:4e:60', '172.16.72.152', 'ramfs', 1, 'default.sh', '791', 'on', 'msi'); |