Ubuntu HH, prestalo mi fungovat gksudo, nejde mysql [vyřešeno]

[existpierre]

Zdravim, z nicoho nic mi nejde v jave nacitat mysql driver, dal som /etc/init.d/mysql restart, stopne ok, ale failne to pri startovani, bez priciny, ziadnu chybu nevypise.

 Ked chcem dat gksudo gedit, tak nereaguje dlho, nakoniec sa to pusti ale uplne mi ten gedit mrzne, v konzole vypise toto:

(gedit:8734): GtkSourceView-WARNING **: no color named '000000'

(gedit:8734): GtkSourceView-WARNING **: no color named '000000'

Neviete v com moze byt problem ? Suvisia tieto problemy medzi sebou. pls help


tuto je vystup z logu:

Kód: [Vybrat]

peter@peter-laptop:~$ sudo /etc/init.d/mysql start
 * Starting MySQL database server mysqld                                                                     [fail]
peter@peter-laptop:~$ tail -n50 /var/log/syslog
May 28 20:32:25 peter-laptop /etc/init.d/mysql[9794]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
May 28 20:32:25 peter-laptop /etc/init.d/mysql[9794]:
May 28 20:34:02 peter-laptop mysqld_safe[10112]: started
May 28 20:34:02 peter-laptop mysqld[10115]: 090528 20:34:02  InnoDB: Started; log sequence number 0 43665
May 28 20:34:02 peter-laptop mysqld[10115]: 090528 20:34:02 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
May 28 20:34:02 peter-laptop mysqld[10115]: 090528 20:34:02 [ERROR] Do you already have another mysqld server running on port: 3306 ?
May 28 20:34:02 peter-laptop mysqld[10115]: 090528 20:34:02 [ERROR] Aborting
May 28 20:34:02 peter-laptop mysqld[10115]:
May 28 20:34:02 peter-laptop mysqld[10115]: 090528 20:34:02  InnoDB: Starting shutdown...
May 28 20:34:04 peter-laptop mysqld[10115]: 090528 20:34:04  InnoDB: Shutdown completed; log sequence number 0 43665
May 28 20:34:04 peter-laptop mysqld[10115]: 090528 20:34:04 [Note] /usr/sbin/mysqld: Shutdown complete
May 28 20:34:04 peter-laptop mysqld[10115]:
May 28 20:34:04 peter-laptop mysqld_safe[10147]: ended
May 28 20:34:16 peter-laptop /etc/init.d/mysql[10287]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
May 28 20:34:16 peter-laptop /etc/init.d/mysql[10287]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
May 28 20:34:16 peter-laptop /etc/init.d/mysql[10287]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
May 28 20:34:16 peter-laptop /etc/init.d/mysql[10287]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
May 28 20:34:16 peter-laptop /etc/init.d/mysql[10287]:
May 28 20:38:25 peter-laptop mysqld_safe[10640]: started
May 28 20:38:25 peter-laptop mysqld[10643]: 090528 20:38:25  InnoDB: Started; log sequence number 0 43665
May 28 20:38:25 peter-laptop mysqld[10643]: 090528 20:38:25 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
May 28 20:38:25 peter-laptop mysqld[10643]: 090528 20:38:25 [ERROR] Do you already have another mysqld server running on port: 3306 ?
May 28 20:38:25 peter-laptop mysqld[10643]: 090528 20:38:25 [ERROR] Aborting
May 28 20:38:25 peter-laptop mysqld[10643]:
May 28 20:38:25 peter-laptop mysqld[10643]: 090528 20:38:25  InnoDB: Starting shutdown...
May 28 20:38:27 peter-laptop mysqld[10643]: 090528 20:38:27  InnoDB: Shutdown completed; log sequence number 0 43665
May 28 20:38:27 peter-laptop mysqld[10643]: 090528 20:38:27 [Note] /usr/sbin/mysqld: Shutdown complete
May 28 20:38:27 peter-laptop mysqld[10643]:
May 28 20:38:27 peter-laptop mysqld_safe[10674]: ended
May 28 20:38:39 peter-laptop /etc/init.d/mysql[10815]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
May 28 20:38:39 peter-laptop /etc/init.d/mysql[10815]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
May 28 20:38:39 peter-laptop /etc/init.d/mysql[10815]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
May 28 20:38:39 peter-laptop /etc/init.d/mysql[10815]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
May 28 20:38:39 peter-laptop /etc/init.d/mysql[10815]:
May 28 20:39:07 peter-laptop mysqld_safe[10913]: started
May 28 20:39:07 peter-laptop mysqld[10916]: 090528 20:39:07  InnoDB: Started; log sequence number 0 43665
May 28 20:39:07 peter-laptop mysqld[10916]: 090528 20:39:07 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
May 28 20:39:07 peter-laptop mysqld[10916]: 090528 20:39:07 [ERROR] Do you already have another mysqld server running on port: 3306 ?
May 28 20:39:07 peter-laptop mysqld[10916]: 090528 20:39:07 [ERROR] Aborting
May 28 20:39:07 peter-laptop mysqld[10916]:
May 28 20:39:07 peter-laptop mysqld[10916]: 090528 20:39:07  InnoDB: Starting shutdown...
May 28 20:39:09 peter-laptop mysqld[10916]: 090528 20:39:09  InnoDB: Shutdown completed; log sequence number 0 43665
May 28 20:39:09 peter-laptop mysqld[10916]: 090528 20:39:09 [Note] /usr/sbin/mysqld: Shutdown complete
May 28 20:39:09 peter-laptop mysqld[10916]:
May 28 20:39:09 peter-laptop mysqld_safe[10952]: ended
May 28 20:39:21 peter-laptop /etc/init.d/mysql[11092]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
May 28 20:39:21 peter-laptop /etc/init.d/mysql[11092]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
May 28 20:39:21 peter-laptop /etc/init.d/mysql[11092]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
May 28 20:39:21 peter-laptop /etc/init.d/mysql[11092]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
May 28 20:39:21 peter-laptop /etc/init.d/mysql[11092]:


[Martin 'Želva' Malý]

Nebyla to zase jenom nějaká přechodná aktualizace?

[stderr]

K MySQL Ti to v logu pise:

Kód: [Vybrat]

error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
bud zkus killnout vsechny mysql procesy (neco tam bezi) a pak znovu nastartovat nebo to nekdy bylo nekorektne ukonceny, pak ten socket nekam presun (pro jistotu nemazat) a zkus nastartovat znovu..
s gksudo by to nemelo mit spojitost...

[existpierre]

skusil som a nic, socket sa tam nenachadza. skusil som tnto navod: http://ubuntuforums.org/showthread.php?t=276470&page=5 a takisto nic

a s tym rootom tiez neviem, s gui apps v roote sa neda pracovat

[existpierre]

tak mysql sa mi podarilo rozbehat, namiesto 127.0.0.1 som dal svoju IP adresu wifi, bo som menil modem za wifi router. takze uz mysqld ide spustit. K databaze uz pristupujem z konzoly alebo query browsera. No stale mam problem, ze s nou java nevie komunikovat. Nechapem preco, vsak to slo bez problemov.

a s tym sudom, hladal som uz vsade, nikde som nic nenasiel, napriklad synaptic nemrzne, gedit ano, alebo instalacia mysql servera mi tiez hodila chybovy kod 6.

tu je odchytene exception z mojho programu

[petergula]

No stale mam problem, ze s nou java nevie komunikovat.

Tak sem skus hodit, co Ti ten java program presne vypise v logu(hod sem stacktrace) a aky pripajaci retazec v jave pouzivas, popr. aky java connector.

[existpierre]

takto sa pripajam, s tymto nebol vobec problem, fungovalo to. a zrazu nie..

Kód: [Vybrat]

    private static Connection getMySqlConnection() { // vytvorenie sql spojenia
        String driver = "org.gjt.mm.mysql.Driver";
        String url = "jdbc:mysql://localhost/sklad_dataDEV";
        String username = "root";
        String password = "wwwwww";
        Connection conn = null;
        try{
        Class.forName(driver);
         conn = DriverManager.getConnection(url, username, password);
          } catch (Exception ex) {
            DialogErr("Chyba pri načítaní mySQL driveru: ", "getMySqlConnection()", ex);
            System.exit(1);
        }
        return conn;
    }
StackTrace :

Kód: [Vybrat]

init:
deps-jar:
Compiling 1 source file to /home/peter/NetBeansProjects/Gold/build/classes
compile:
run:
Chyba pri načítaní mySQL driveru: Communications link failure
com.mysql.jdbc.CommunicationsException: Communications link failure

Last packet sent to the server was 0 ms ago.
Funkcia: getMySqlConnection()

Last packet sent to the server was 0 ms ago.
        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1070)
        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2104)
        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:729)
        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:298)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:283)
        at java.sql.DriverManager.getConnection(DriverManager.java:582)
        at java.sql.DriverManager.getConnection(DriverManager.java:185)
        at gold.SkladSQL.getMySqlConnection(SkladSQL.java:660)
        at gold.SkladSQL.getSkladItemSize(SkladSQL.java:354)
        at gold.SkladSQL.getDataCombsSKLAD(SkladSQL.java:376)
        at gold.GoldView.getKARTYdata(GoldView.java:1521)
        at gold.GoldView.initComponents(GoldView.java:573)
        at gold.GoldView.<init>(GoldView.java:49)
        at gold.GoldApp.startup(GoldApp.java:19)
        at org.jdesktop.application.Application$1.run(Application.java:171)
        at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:597)
        at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
        at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160)
        at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)
Caused by: java.net.ConnectException: Connection timed out
        at java.net.PlainSocketImpl.socketConnect(Native Method)
        at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
        at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
        at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
        at java.net.Socket.connect(Socket.java:519)
        at java.net.Socket.connect(Socket.java:469)
        at java.net.Socket.<init>(Socket.java:366)
        at java.net.Socket.<init>(Socket.java:209)
        at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:257)
        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:277)
        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2030)
        ... 21 more
Java Result: 1
BUILD SUCCESSFUL (total time: 3 minutes 13 seconds)
zrejme aj po spojazdneni mysql, mi stale nejde socket, vobec sa tam nenachadza a niekde som nenasiel ako to obnovit, cez navod, kde je prikaz touch, to nepomohlo.

[petergula]

tak mysql sa mi podarilo rozbehat, namiesto 127.0.0.1 som dal svoju IP adresu wifi, bo som menil modem za wifi router.

,kde si menil 127.0.0.1 na IP adresu? Ked zmenis localhost(127.0.0.1) vo svojom java programe na tu funkcnu IP adresu, potom Ti program ide?

Kód: [Vybrat]

String url = "jdbc:mysql://localhost/sklad_dataDEV";
na

Kód: [Vybrat]

String url = "jdbc:mysql://192.168.1.1/sklad_dataDEV";
samozrejme adresa ma byt ta Tvoja, co si si ju zmenil.

V Mysql  mas povolene pripajanie aj s localhostu aj s inych strojov, alebo ako to mas nastavene?

Inak MySQL Query Browser sa pripaja tiez cez java connector na MySQL server, takze ked to ide cez neho, tak to na 99% ma ist aj z javy. Ako mas nastavene v nom pripajanie?

[existpierre]

takze ked som dal moju ip v jave namiesto localhost, nepomohlo. Pripajam sa cez mysql-connector-java-5.1.5.jar pridal som do do library v nastaveniach projektu

V Mysql  mas povolene pripajanie aj s localhostu aj s inych strojov, alebo ako to mas nastavene?

kde to pozriem? a preco mi to nechce fungovat na localhoste ako predtym? mohlo to ovplyvnit to, ze som bol na modeme a presiel som na wifi router ?

ak mi to ide v query, tak potom fakt neviem preco v netbeanse nejde

este otazka ci mysql nevyuziva aj roota v ubuntu, ze preto hodi timeout na prpojenie k mysql, ze to tak mrzne

[existpierre]

vyriesene:

ja nouma ked som skusal rozbehat new router, som reinstaloval network managera a potom som premenoval interfaces .. preto mi nic neslo, ked som to dal naspat, tak uz je vsetko v poriadku, wifi uz ide aj localhost pingujem, sudo uz pracuje spravne..