Re: [Maria-developers] mariadb-server not installable on Debian Testing AMD64
Thomas Hackert <thackert@nexgo.de> writes:
I am not sure, how (and if) I can upload to f.a.o., so I will attach it to this mail. Sorry for the inconvenience ... :(
No inconvenience at all, mail is perfect. And indeed, the strace was illuminating. I think the issue is right here: [pid 32673] bind(14, {sa_family=AF_INET, sin_port=htons(3306), sin_addr=inet_addr("127.0.0.1")}, 16) = -1 EADDRNOTAVAIL (Cannot assign requested address) The server fails to start, because it cannot setup a socket to listen on the loopback interface on 127.0.0.1 The manpage for bind(2) says: EADDRNOTAVAIL A nonexistent interface was requested or the requested address was not local. I get the same error on my machine if I try to bind a socket to a non-existing interface. You can try this netcat command to do the same bind, it will probably fail in the same way: nc -l -s 127.0.0.1 -p 3306 So the problem most likely is that your system has a non-standard networking setup, with the normal loopback address 127.0.0.1 not configured. The default configuration file has this line: bind-address = 127.0.0.1 This will fail if the address 127.0.0.1 is not available on the system (normally it is). So I think you can edit /etc/mysql/my.cnf and change this line to use a valid IP address, or replace it with skip-networking to not use any IP address. Then try starting the server and see if it works. If it does, `apt-get install -f` might fix the installation. Can you confirm that your system has no 127.0.0.1 address? (It is somewhat annoying that the install fails in this case, but it does seem a rather rare setup). The second question is why you did not get any error log output with messages about this problem. I suppose this might be because you had no syslog installed. Elena gave you suggestions for how to resolve/investigate this further. But let me know if you have more problems with this. Thanks for your persistence in helping me get to the bottom of this! - Kristian.
Kristian Nielsen <knielsen@knielsen-hq.org> writes:
The second question is why you did not get any error log output with messages about this problem. I suppose this might be because you had no syslog installed. Elena gave you suggestions for how to resolve/investigate this further. But let me know if you have more problems with this.
Ah, I see in your other mail you already got the log output working. "error: 99: Cannot assign requested address" - again, this indicates EADDRNOTAVAIL, suggesting that 127.0.0.1 is missing on the system. So check the network config, and perhaps use different bind address in my.cnf or skip-networking. - Kristian.
Hello Kristian, *, On Tue, Feb 05, 2013 at 07:36:18PM +0100, Kristian Nielsen wrote:
Kristian Nielsen <knielsen@knielsen-hq.org> writes:
The second question is why you did not get any error log output with messages about this problem. I suppose this might be because you had no syslog installed. Elena gave you suggestions for how to resolve/investigate this further. But let me know if you have more problems with this.
Ah, I see in your other mail you already got the log output working.
yes, indeed :)
"error: 99: Cannot assign requested address" - again, this indicates EADDRNOTAVAIL, suggesting that 127.0.0.1 is missing on the system.
But does it mean, I have to install bind to use mariadb-server? I would prefer to not install it ... ;)
So check the network config, and perhaps use different bind address in my.cnf or skip-networking.
Well, in my /etc/networks I have the line <quote> loopback 127.0.0.0 </quote> . But if I use the address, the router has assigned to my Desktop PC (192.168.X.YYY ... ;) ), it works :) Then I can use "apt-get -f install" to fix the installation. But still wondering, if this could not be fixed (say: a pre-install script, which checks the system for a working network and/or which IP address is assigned to the machine or the like ... ;) ), so lusers do not have to do "bad hacks" to install their mariadb-server package ... ;) Thanks again for your help and have a nice day Thomas. -- BOFH excuse #443: Zombie processes detected, machine is haunted.
Thomas Hackert <thackert@nexgo.de> writes:
"error: 99: Cannot assign requested address" - again, this indicates EADDRNOTAVAIL, suggesting that 127.0.0.1 is missing on the system.
But does it mean, I have to install bind to use mariadb-server? I would prefer to not install it ... ;)
No, it has nothing to do with bind. It means that the default configuration file is set up with an IP address that is invalid on your system.
Well, in my /etc/networks I have the line <quote> loopback 127.0.0.0 </quote> . But if I use the address, the router has assigned to my Desktop PC (192.168.X.YYY ... ;) ), it works :) Then I can use "apt-get -f install" to fix the installation. But still wondering, if this could not be fixed (say: a pre-install script, which checks the system for a working network and/or which IP address is assigned to the machine or the like
In principle, yes. However, I am reluctant to change this. It sounds like your system has a broken network setup, I have never seen before a correctly configured system without 127.0.0.1 address. Also note that this comes from the original Debian MySQL packages, so changing it also is dangerous in case we break compatibility. If you want, you can send me the output of ifconfig -a so I can check if there is something special with your network setup. My guess would be that you would find other programs have similar problems with missing 127.0.0.1 address. - Kristian.
Hello Kristian, *, On Wed, Feb 06, 2013 at 08:19:07AM +0100, Kristian Nielsen wrote:
Thomas Hackert <thackert@nexgo.de> writes:
"error: 99: Cannot assign requested address" - again, this indicates EADDRNOTAVAIL, suggesting that 127.0.0.1 is missing on the system.
But does it mean, I have to install bind to use mariadb-server? I would prefer to not install it ... ;)
No, it has nothing to do with bind.
O.K.
It means that the default configuration file is set up with an IP address that is invalid on your system.
O.K.
Well, in my /etc/networks I have the line <quote> loopback 127.0.0.0 </quote> . But if I use the address, the router has assigned to my Desktop PC (192.168.X.YYY ... ;) ), it works :) Then I can use "apt-get -f install" to fix the installation. But still wondering, if this could not be fixed (say: a pre-install script, which checks the system for a working network and/or which IP address is assigned to the machine or the like
In principle, yes. However, I am reluctant to change this. It sounds like your system has a broken network setup,
Maybe, but I can go online and all without any problem ... ;)
I have never seen before a correctly configured system without 127.0.0.1 address. Also note that this comes from the original Debian MySQL packages, so changing it also is dangerous in case we break compatibility.
O.K.
If you want, you can send me the output of
ifconfig -a
so I can check if there is something special with your network setup. My guess
This gives me (I have only used $X and $Y to hold some privacy ... ;) ): <quote> eth0 Link encap:Ethernet Hardware Adresse 00:1a:4d:63:c0:ae inet Adresse:192.168.$X.$YYY Bcast:192.168.$X.255 Maske:255.255.255.0 inet6-Adresse: fe80::21a:4dff:fe63:c0ae/64 Gültigkeitsbereich:Verbindung UP BROADCAST RUNNING MULTICAST MTU:1500 Metrik:1 RX packets:46295454 errors:0 dropped:0 overruns:0 frame:0 TX packets:47876507 errors:0 dropped:0 overruns:0 carrier:0 Kollisionen:0 Sendewarteschlangenlänge:1000 RX bytes:28966400302 (26.9 GiB) TX bytes:29041333971 (27.0 GiB) Interrupt:40 Basisadresse:0x8000 lo Link encap:Lokale Schleife LOOPBACK MTU:16436 Metrik:1 RX packets:0 errors:0 dropped:0 overruns:0 frame:0 TX packets:0 errors:0 dropped:0 overruns:0 carrier:0 Kollisionen:0 Sendewarteschlangenlänge:0 RX bytes:0 (0.0 B) TX bytes:0 (0.0 B) </quote>
would be that you would find other programs have similar problems with missing 127.0.0.1 address.
Not until now ... ;) Thanks again Thomas. -- I tell them to turn to the study of mathematics, for it is only there that they might escape the lusts of the flesh. -- Thomas Mann, "The Magic Mountain"
Thomas Hackert <thackert@nexgo.de> writes:
lo Link encap:Lokale Schleife LOOPBACK MTU:16436 Metrik:1 RX packets:0 errors:0 dropped:0 overruns:0 frame:0 TX packets:0 errors:0 dropped:0 overruns:0 carrier:0 Kollisionen:0 Sendewarteschlangenlänge:0 RX bytes:0 (0.0 B) TX bytes:0 (0.0 B)
Right, so the loopback interface does not have any IP address at all / it is not up. I think this is an error, at least I've never before heard of a system with no loopback address ? - Kristian.
Hello Kristian, *, On Wed, Feb 06, 2013 at 04:15:50PM +0100, Kristian Nielsen wrote: should we not switch to PM, as this is not mariadb related stuff, which we are talking about ;?
Thomas Hackert <thackert@nexgo.de> writes:
lo Link encap:Lokale Schleife LOOPBACK MTU:16436 Metrik:1 RX packets:0 errors:0 dropped:0 overruns:0 frame:0 TX packets:0 errors:0 dropped:0 overruns:0 carrier:0 Kollisionen:0 Sendewarteschlangenlänge:0 RX bytes:0 (0.0 B) TX bytes:0 (0.0 B)
Right, so the loopback interface does not have any IP address at all / it is not up.
But then I have not the faintest idea, why ... :(
I think this is an error, at least I've never before heard of a system with no loopback address ?
Maybe because I have purged all exim, at and other server related stuff (+ its dependencies) after my Debian installation as usual ;? But I never stumbled upon any problem until now ... ;) And I can ping either 127.0.0.1 or localhost without any problem (I am trying to find out, what I should/could change via http://tldp.org/LDP/nag2/x-087-2-iface.interface.html ... ;) ). Have a nice evening Thomas. -- Common sense is instinct, and enough of it is genius. -- Josh Billings
participants (2)
-
Kristian Nielsen -
Thomas Hackert