On Mon, 18 Feb 2008 15:08:53 +0100, Dariusz Kowalczyk wrote
Po dzisiejszym upgrade mam przy wejsciu na liste sieci
Wystąpiły błędy w obsłudze bazy danych! Zapytanie: SELECT id, name, inet_ntoa(address) AS address, address AS addresslong, mask, interface, gateway, dns, dns2, domain, wins, dhcpstart, dhcpend, mask2prefix (inet_aton(mask)) AS prefix, broadcast(address, inet_aton(mask)) AS broadcastlong, inet_ntoa(broadcast(address, inet_aton(mask))) AS broadcast, pow(2,(32 - mask2prefix (inet_aton(mask)))) AS size, (SELECT COUNT(*) FROM nodes WHERE (ipaddr >= address AND ipaddr <= broadcast(address, inet_aton(mask))) OR (ipaddr_pub >= address AND ipaddr_pub <= broadcast(address, inet_aton(mask))) ) AS assigned, (SELECT COUNT(*) FROM nodes WHERE ((ipaddr >= address AND ipaddr <= broadcast(address, inet_aton (mask))) OR (ipaddr_pub >= address AND ipaddr_pub <= broadcast(address, inet_aton
(mask)))) AND (UNIX_TIMESTAMP() - lastonline < 600) ) AS online FROM networks ORDER BY name Błąd: FUNCTION lms.mask2prefix does not exist
Dariusz Kowalczyk
lms mailing list lms@lists.lms.org.pl http://lists.lms.org.pl/mailman/listinfo/lms
po recznym wklepaniu (czmu sie nie upgradneły z automaty?)
mysql> CREATE FUNCTION mask2prefix(mask bigint) RETURNS smallint DETERMINISTIC RETURN bit_count(mask); Query OK, 0 rows affected (0.00 sec)
mysql> CREATE FUNCTION broadcast(address bigint, mask bigint) RETURNS bigint DETERMINISTIC RETURN address + (pow(2, (32-mask2prefix(mask)))-1); Query OK, 0 rows affected (0.00 sec)
mam teraz
Błąd: execute command denied to user 'lms'@'localhost' for routine 'lms.mask2prefix'
Dariusz Kowalczyk
!DSPAM:47b9a6c148161010189975!