relinquished
Posts: 151
Joined: Sun Apr 07, 2013 6:32 pm

mysql

Wed Mar 05, 2014 11:51 am

salve ragazzi scusate ancora il disturbo, ma avendo rinstallato quasi tutti i programmi da capo sono arrivato al punto dove ho installato mysql come database , pero mon riesco ad accedere dal pc tramite un programma che di solito usavo per gestire il database , lindirizzo ip e lo stesso che avevo su laltra distribuzione , e lutente gia e stato creato con gli stessi parametri , il databse e lo stesso , pero non capisco perche non riesco a connettermi

relinquished
Posts: 151
Joined: Sun Apr 07, 2013 6:32 pm

Re: mysql

Wed Mar 05, 2014 11:53 am

quando provo a connettermi mi da questo messaggio di errore

errore sql(2003) nell' istruzione n' 0: can't connect to mysql server on 192.168.1.7 (10061)

Angelus88
Posts: 442
Joined: Mon May 13, 2013 9:25 am
Location: Ivrea, TO (Italy)

Re: mysql

Wed Mar 05, 2014 1:54 pm

Il dubbio che mi viene è che il demone mysqld non sia avviato o che sia avviato su una porta diversa.

Apri il terminale e prova il comando

Code: Select all

sudo netstat -tulpn | grep mysqld
Se non ti da nulla, il demone di mysql server non è in esecuzione.

Se ti da un rigo, leggi dove dice 127.0.0.1:XXXX e al posto delle XXXX dovrebbe apparirti la porta su cui gira il demone che è la porta che devi usare con il programma con cui gestisci i database usando quindi l'ip 192.168.1.7:XXXX invece di 192.168.1.7:10061 perché probabilmente non è 10061 la porta.

relinquished
Posts: 151
Joined: Sun Apr 07, 2013 6:32 pm

Re: mysql

Wed Mar 05, 2014 2:28 pm

ho fatto na cavolata , ho disinstallato mysql e provato a rinstallare ma mi da sempre questo errore finale

Code: Select all

root@raspberrypi:~# sudo apt-get install mysql
Reading package lists... Done
Building dependency tree
Reading state information... Done
E: Unable to locate package mysql
root@raspberrypi:~# sudo apt-get install mysql-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following extra packages will be installed:
  libaio1 libdbd-mysql-perl libdbi-perl libhtml-template-perl libmysqlclient16 libnet-daemon-perl
  libplrpc-perl mysql-client-5.5 mysql-common mysql-server-5.5 mysql-server-core-5.5
Suggested packages:
  libipc-sharedcache-perl libterm-readkey-perl tinyca
The following NEW packages will be installed:
  libaio1 libdbd-mysql-perl libdbi-perl libhtml-template-perl libmysqlclient16 libnet-daemon-perl
  libplrpc-perl mysql-client-5.5 mysql-common mysql-server mysql-server-5.5 mysql-server-core-5.5
0 upgraded, 12 newly installed, 0 to remove and 1 not upgraded.
Need to get 4,401 kB/9,807 kB of archives.
After this operation, 90.8 MB of additional disk space will be used.
Do you want to continue [Y/n]? y
Get:1 http://mirrordirector.raspbian.org/raspbian/ wheezy/main libaio1 armhf 0.3.109-3 [8,944 B]
Get:2 http://mirrordirector.raspbian.org/raspbian/ wheezy/main libnet-daemon-perl all 0.48-1 [46.2 kB]
Get:3 http://mirrordirector.raspbian.org/raspbian/ wheezy/main libplrpc-perl all 0.2020-2 [36.0 kB]
Get:4 http://mirrordirector.raspbian.org/raspbian/ wheezy/main libdbi-perl armhf 1.622-1 [895 kB]
Get:5 http://mirrordirector.raspbian.org/raspbian/ wheezy/main mysql-server-core-5.5 armhf 5.5.35+dfsg-0+wheezy1 [3,343 kB]
Get:6 http://mirrordirector.raspbian.org/raspbian/ wheezy/main libhtml-template-perl all 2.91-1 [72.0 kB]
Fetched 4,401 kB in 12s (352 kB/s)
Preconfiguring packages ...
Selecting previously unselected package libaio1:armhf.
(Reading database ... 73024 files and directories currently installed.)
Unpacking libaio1:armhf (from .../libaio1_0.3.109-3_armhf.deb) ...
Selecting previously unselected package mysql-common.
Unpacking mysql-common (from .../mysql-common_5.5.35+dfsg-0+wheezy1_all.deb) ...
Selecting previously unselected package libnet-daemon-perl.
Unpacking libnet-daemon-perl (from .../libnet-daemon-perl_0.48-1_all.deb) ...
Selecting previously unselected package libplrpc-perl.
Unpacking libplrpc-perl (from .../libplrpc-perl_0.2020-2_all.deb) ...
Selecting previously unselected package libdbi-perl.
Unpacking libdbi-perl (from .../libdbi-perl_1.622-1_armhf.deb) ...
Selecting previously unselected package libmysqlclient16.
Unpacking libmysqlclient16 (from .../libmysqlclient16_5.1.62-1_armhf.deb) ...
Selecting previously unselected package libdbd-mysql-perl.
Unpacking libdbd-mysql-perl (from .../libdbd-mysql-perl_4.021-1_armhf.deb) ...
Selecting previously unselected package mysql-client-5.5.
Unpacking mysql-client-5.5 (from .../mysql-client-5.5_5.5.35+dfsg-0+wheezy1_armhf.deb) ...
Selecting previously unselected package mysql-server-core-5.5.
Unpacking mysql-server-core-5.5 (from .../mysql-server-core-5.5_5.5.35+dfsg-0+wheezy1_armhf.deb) ...
Processing triggers for man-db ...
Setting up mysql-common (5.5.35+dfsg-0+wheezy1) ...
Selecting previously unselected package mysql-server-5.5.
(Reading database ... 73408 files and directories currently installed.)
Unpacking mysql-server-5.5 (from .../mysql-server-5.5_5.5.35+dfsg-0+wheezy1_armhf.deb) ...
Selecting previously unselected package libhtml-template-perl.
Unpacking libhtml-template-perl (from .../libhtml-template-perl_2.91-1_all.deb) ...
Selecting previously unselected package mysql-server.
Unpacking mysql-server (from .../mysql-server_5.5.35+dfsg-0+wheezy1_all.deb) ...
Processing triggers for man-db ...
Setting up libaio1:armhf (0.3.109-3) ...
Setting up libnet-daemon-perl (0.48-1) ...
Setting up libplrpc-perl (0.2020-2) ...
Setting up libdbi-perl (1.622-1) ...
Setting up libmysqlclient16 (5.1.62-1) ...
Setting up libdbd-mysql-perl (4.021-1) ...
Setting up mysql-client-5.5 (5.5.35+dfsg-0+wheezy1) ...
Setting up mysql-server-core-5.5 (5.5.35+dfsg-0+wheezy1) ...
Setting up mysql-server-5.5 (5.5.35+dfsg-0+wheezy1) ...
[ ok ] Stopping MySQL database server: mysqld.
140305 14:25:06 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
140305 14:25:06 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
140305 14:25:06 [Note] Plugin 'FEDERATED' is disabled.
140305 14:25:06 InnoDB: The InnoDB memory heap is disabled
140305 14:25:06 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140305 14:25:06 InnoDB: Compressed tables use zlib 1.2.7
140305 14:25:06 InnoDB: Using Linux native AIO
140305 14:25:06 InnoDB: Initializing buffer pool, size = 128.0M
140305 14:25:06 InnoDB: Completed initialization of buffer pool
140305 14:25:06 InnoDB: highest supported file format is Barracuda.
140305 14:25:06  InnoDB: Waiting for the background threads to start
140305 14:25:07 InnoDB: 5.5.35 started; log sequence number 1595675
140305 14:25:07  InnoDB: Starting shutdown...
140305 14:25:08  InnoDB: Shutdown completed; log sequence number 1595675
insserv: warning: script 'mathkernel' missing LSB tags and overrides
insserv: There is a loop between service minidlna and mathkernel if stopped
insserv:  loop involving service mathkernel at depth 2
insserv:  loop involving service minidlna at depth 1
insserv: Stopping mathkernel depends on minidlna and therefore on system facility `$all' which can not be true!
insserv: exiting now without changing boot order!
update-rc.d: error: insserv rejected the script header
dpkg: error processing mysql-server-5.5 (--configure):
 subprocess installed post-installation script returned error exit status 1
Setting up libhtml-template-perl (2.91-1) ...
dpkg: dependency problems prevent configuration of mysql-server:
 mysql-server depends on mysql-server-5.5; however:
  Package mysql-server-5.5 is not configured yet.

dpkg: error processing mysql-server (--configure):
 dependency problems - leaving unconfigured
Errors were encountered while processing:
 mysql-server-5.5
 mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)

Angelus88
Posts: 442
Joined: Mon May 13, 2013 9:25 am
Location: Ivrea, TO (Italy)

Re: mysql

Wed Mar 05, 2014 2:44 pm

Che casino...

Ascolta, prova
sudo apt-get remove --purge mysql*
in modo che venga disinstallato tutto ciò che riguarda mysql, sia client che server.

Riavvia e riprova a reinstallare il server con

Code: Select all

sudo apt-get install mysql-server

relinquished
Posts: 151
Joined: Sun Apr 07, 2013 6:32 pm

Re: mysql

Wed Mar 05, 2014 3:10 pm

idem

Code: Select all

root@raspberrypi:~# sudo apt-get install mysql-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following extra packages will be installed:
  libdbd-mysql-perl libmysqlclient16 mysql-client-5.5 mysql-common
  mysql-server-5.5 mysql-server-core-5.5
Suggested packages:
  libterm-readkey-perl tinyca
The following NEW packages will be installed:
  libdbd-mysql-perl libmysqlclient16 mysql-client-5.5 mysql-common
  mysql-server mysql-server-5.5 mysql-server-core-5.5
0 upgraded, 7 newly installed, 0 to remove and 1 not upgraded.
Need to get 0 B/8,749 kB of archives.
After this operation, 88.1 MB of additional disk space will be used.
Do you want to continue [Y/n]? y
Preconfiguring packages ...
Selecting previously unselected package mysql-common.
(Reading database ... 73232 files and directories currently installed.)
Unpacking mysql-common (from .../mysql-common_5.5.35+dfsg-0+wheezy1_all.deb) ...
Selecting previously unselected package libmysqlclient16.
Unpacking libmysqlclient16 (from .../libmysqlclient16_5.1.62-1_armhf.deb) ...
Selecting previously unselected package libdbd-mysql-perl.
Unpacking libdbd-mysql-perl (from .../libdbd-mysql-perl_4.021-1_armhf.deb) ...
Selecting previously unselected package mysql-client-5.5.
Unpacking mysql-client-5.5 (from .../mysql-client-5.5_5.5.35+dfsg-0+wheezy1_armhf.deb) ...
Selecting previously unselected package mysql-server-core-5.5.
Unpacking mysql-server-core-5.5 (from .../mysql-server-core-5.5_5.5.35+dfsg-0+wheezy1_armhf.deb) ...
Processing triggers for man-db ...
Setting up mysql-common (5.5.35+dfsg-0+wheezy1) ...
Selecting previously unselected package mysql-server-5.5.
(Reading database ... 73421 files and directories currently installed.)
Unpacking mysql-server-5.5 (from .../mysql-server-5.5_5.5.35+dfsg-0+wheezy1_armhf.deb) ...
Selecting previously unselected package mysql-server.
Unpacking mysql-server (from .../mysql-server_5.5.35+dfsg-0+wheezy1_all.deb) ...
Processing triggers for man-db ...
Setting up libmysqlclient16 (5.1.62-1) ...
Setting up libdbd-mysql-perl (4.021-1) ...
Setting up mysql-client-5.5 (5.5.35+dfsg-0+wheezy1) ...
Setting up mysql-server-core-5.5 (5.5.35+dfsg-0+wheezy1) ...
Setting up mysql-server-5.5 (5.5.35+dfsg-0+wheezy1) ...
[ ok ] Stopping MySQL database server: mysqld.
140305 15:06:26 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
140305 15:06:26 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
140305 15:06:26 [Note] Plugin 'FEDERATED' is disabled.
140305 15:06:26 InnoDB: The InnoDB memory heap is disabled
140305 15:06:26 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140305 15:06:26 InnoDB: Compressed tables use zlib 1.2.7
140305 15:06:26 InnoDB: Using Linux native AIO
140305 15:06:26 InnoDB: Initializing buffer pool, size = 128.0M
140305 15:06:26 InnoDB: Completed initialization of buffer pool
140305 15:06:26 InnoDB: highest supported file format is Barracuda.
140305 15:06:26  InnoDB: Waiting for the background threads to start
140305 15:06:27 InnoDB: 5.5.35 started; log sequence number 1595675
140305 15:06:27  InnoDB: Starting shutdown...
140305 15:06:28  InnoDB: Shutdown completed; log sequence number 1595675
insserv: warning: script 'mathkernel' missing LSB tags and overrides
insserv: There is a loop between service minidlna and mathkernel if stopped
insserv:  loop involving service mathkernel at depth 2
insserv:  loop involving service minidlna at depth 1
insserv: Stopping mathkernel depends on minidlna and therefore on system facility `$all' which can not be true!
insserv: exiting now without changing boot order!
update-rc.d: error: insserv rejected the script header
dpkg: error processing mysql-server-5.5 (--configure):
 subprocess installed post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of mysql-server:
 mysql-server depends on mysql-server-5.5; however:
  Package mysql-server-5.5 is not configured yet.

dpkg: error processing mysql-server (--configure):
 dependency problems - leaving unconfigured
Errors were encountered while processing:
 mysql-server-5.5
 mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)

Angelus88
Posts: 442
Joined: Mon May 13, 2013 9:25 am
Location: Ivrea, TO (Italy)

Re: mysql

Wed Mar 05, 2014 3:15 pm

Prova

Code: Select all

sudo dpkg -P minidlna
e di nuovo disinstalla e reinstalla mysql con i comandi che ti ho scritto prima

relinquished
Posts: 151
Joined: Sun Apr 07, 2013 6:32 pm

Re: mysql

Wed Mar 05, 2014 4:33 pm

ora con quel comando di verifica ho questo risultato

Code: Select all

tcp        0      0 0.0.0.0:3306            0.0.0.0:*               LISTEN      6247/mysqld

relinquished
Posts: 151
Joined: Sun Apr 07, 2013 6:32 pm

Re: mysql

Wed Mar 05, 2014 4:42 pm

ok di nuovo grazie mille ora funziona

relinquished
Posts: 151
Joined: Sun Apr 07, 2013 6:32 pm

Re: mysql

Wed Mar 05, 2014 4:43 pm

ma quale era il problema ??

Angelus88
Posts: 442
Joined: Mon May 13, 2013 9:25 am
Location: Ivrea, TO (Italy)

Re: mysql

Thu Mar 06, 2014 7:30 am

relinquished wrote:ora con quel comando di verifica ho questo risultato

Code: Select all

tcp        0      0 0.0.0.0:3306            0.0.0.0:*               LISTEN      6247/mysqld
Ok la porta è quindi la 3306 da usare per collegarti.

Non so dirti esattamente da cosa è stato causato ma cercando su internet proponevano quella soluzione ;)

Return to “Italiano”