I'm about to set up a low traffic web server onto an old Android phone in a chrooted environment. A Debian is installed onto the phone and works properly for some months (so this is a kind of special Linux environment).
Apache2 and Python are up and running.
But when I start mysqld:
root@Motoluxe:~# /usr/sbin/mysqld
... [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.
... [Note] /usr/sbin/mysqld (mysqld 5.5.49-0+deb7u1) starting as process 31419 ...
... [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.
... [Note] Plugin 'FEDERATED' is disabled.
... InnoDB: The InnoDB memory heap is disabled
... InnoDB: Mutexes and rw_locks use GCC atomic builtins
... InnoDB: Compressed tables use zlib 1.2.7
... InnoDB: Using Linux native AIO
... InnoDB: Initializing buffer pool, size = 128.0M
... InnoDB: Completed initialization of buffer pool
... InnoDB: highest supported file format is Barracuda.
... InnoDB: Waiting for the background threads to start
... InnoDB: 5.5.49 started; log sequence number 1598476
... [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
... [Note] - '127.0.0.1' resolves to '127.0.0.1';
... [ERROR] Failed to create a socket for IPv4 '127.0.0.1': errno: 13.
... [ERROR] Can't create IP socket: Permission denied
... [ERROR] Aborting
... InnoDB: Starting shutdown...
... InnoDB: Shutdown completed; log sequence number 1598476
... [Note] /usr/sbin/mysqld: Shutdown complete
In /etc/mysql/my.conf:
#skip-networking
...
socket = /var/run/mysqld/mysqld.sock
In /var/run:
drwxrwxrwx 2 mysql mysql 4096 jún 19 10:07 mysqld
So in theory the socket can be written.
(If I enable skip-networking mysql starts but i cannot connect to it from python via pymysql.connect)
It is noteworthy that /etc/groups seems to be incomplete and I saw groups without a name having just an ID (in directory listings), so some kind of mysql-is-not-being-in-that-group-that-owes-a-network-resource-type problem is conceivable.
Other network using programs, include apache2 work.
PS Enabling python to connect with skip-networking enabled should be a workaround.
