lms.mask2prefix does not exist
?m=customerlist ------------------------------ Wystąpiły błędy w obsłudze bazy danych! *Zapytanie:* SELECT id, name, inet_ntoa(address) AS address, address AS addresslong, mask, mask2prefix(inet_aton(mask)) AS prefix FROM networks ORDER BY name *Błąd:* FUNCTION lms.mask2prefix does not exist ------------------------------
?m=nodelist ------------------------------ Wystąpiły błędy w obsłudze bazy danych! *Zapytanie:* SELECT id, name, inet_ntoa(address) AS address, address AS addresslong, mask, mask2prefix(inet_aton(mask)) AS prefix FROM networks ORDER BY name *Błąd:* FUNCTION lms.mask2prefix does not exist ------------------------------
/?m=netlist ------------------------------ 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 ------------------------------
blad pojawil sie po aktualizacji z 1.11.1 do 1.11.2
*Wersja LMS: 1.11.2 Neera (1.914/1.22) *Wersja LMSDB: 1.11.2 Neera (1.44/1.50) * Wersja MySQL: 5.0.54-log *Wersja PHP: 5.2.5-pl1-gentoo *Wersja Smarty: 2.6.18
Pomocy, jak to zlikwidowac?
!DSPAM:47a1b7be316088362916074!
node wrote:
?m=customerlist
Wystąpiły błędy w obsłudze bazy danych! *Zapytanie:* SELECT id, name, inet_ntoa(address) AS address, address AS addresslong, mask, mask2prefix(inet_aton(mask)) AS prefix FROM networks ORDER BY name
*Błąd:* FUNCTION lms.mask2prefix does not exist
wykonać polecenia z pliku lib/upgradedb/mysql.2008012200.php
i napisać jakie zwracają błędy. Prawdopodobnie problem z uprawnieniami w bazie.
A.L.E.C pisze:
node wrote:
?m=customerlist
Wystąpiły błędy w obsłudze bazy danych! *Zapytanie:* SELECT id, name, inet_ntoa(address) AS address, address AS addresslong, mask, mask2prefix(inet_aton(mask)) AS prefix FROM networks ORDER BY name
*Błąd:* FUNCTION lms.mask2prefix does not exist
wykonać polecenia z pliku lib/upgradedb/mysql.2008012200.php
i napisać jakie zwracają błędy. Prawdopodobnie problem z uprawnieniami w bazie.
wykonane z prawami lms:
mysql> CREATE FUNCTION mask2prefix(mask bigint) RETURNS smallint DETERMINISTIC RETURN bit_count(mask); ERROR 1419 (HY000): You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)
natomiast baza i uprawnienia sa nadane wg wskazowek dokumentacji. mysql> CREATE DATABASE lms CHARACTER SET utf8 COLLATE utf8_polish_ci; mysql> GRANT USAGE ON lms.* TO lms@localhost; mysql> GRANT ALL ON lms.* TO lms@localhost IDENTIFIED BY 'twoje_hasło';
aktualne uprawnienia to ALL PRIVILEGES nie widze wsrod nich jednak flagi "SUPER": SELECT INSERT UPDATE DELETE CREATE ALTER INDEX DROP CREATE TEMPORARY TABLES CREATE VIEW SHOW VIEW CREATE ROUTINE ALTER ROUTINE EXECUTE LOCK TABLES REFERENCES
czy ALL PRIVILEGES jest indywidualne dla danego srodowiska?
!DSPAM:47a1cc5622311465223968!
node wrote:
wykonane z prawami lms:
mysql> CREATE FUNCTION mask2prefix(mask bigint) RETURNS smallint DETERMINISTIC RETURN bit_count(mask); ERROR 1419 (HY000): You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)
aktualne uprawnienia to ALL PRIVILEGES nie widze wsrod nich jednak flagi "SUPER":
zazwyczaj tak się dzieje przy aktualizacji mysqla, spróbuj mysql_fix_privilege_tables, potem usuń użytkownika lms i dodaj ponownie. Jeśli to nie pomoże to włącz log_bin_trust_function_creators w my.cnf.
uczestnicy (2)
-
A.L.E.C -
node