How do i get Mysql up and running help needed

[John Bons]

Hi All,

I want to runb mysql on my nas running alt-f rc4. But i am running against i think the simple problem of starting the environment.
I installed the mysql environment via the packages menu.
I dont know were to start.

[root@NAS]# mysqld start
141109 16:39:08 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
141109 16:39:08 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

141109 16:39:08 [ERROR] Aborting

141109 16:39:08 [Note] mysqld: Shutdown complete


When i try to start the client
[root@NAS]# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (111)
[root@NAS]#

can anybody help me out with this?

[João Cardoso]

You should use 'rcmysqld <start|stop|status|enable|disable>', or use the Services->System->mysql Start/Stop button 

[root@DNS-323]# rcmysqld start

Creating MySQL system tables...

Installing MySQL system tables...

141109 16:33:32 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.

OK

Filling help tables...

141109 16:33:34 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.

OK

To start mysqld at boot time you have to copy

support-files/mysql.server to the right place for your system

 

Under Alt-F use 'rcmysqld enable' to start it at boot time, or check the "Boot Enable" checkbutton im Services->System->mysqld

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !

To do so, start the server, then issue the following commands:

/usr/bin/mysqladmin -u root password 'new-password'

/usr/bin/mysqladmin -u root -h DNS-323 password 'new-password'

Alternatively you can run:

/usr/bin/mysql_secure_installation

which will also give you the option of removing the test

databases and anonymous user created by default.  This is

strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:

cd /usr ; /usr/bin/mysqld_safe &

the 'rcmysqld start'  script does all that is needed

You can test the MySQL daemon with mysql-test-run.pl

cd /usr/mysql-test ; perl mysql-test-run.pl

Please report any problems with the /usr/bin/mysqlbug script!

Starting mysqld_safe: OK.

 

[root@DNS-323]# mysql

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 2

Server version: 5.1.73 Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> 

[James Pike]

Joao, when I try to set the admin password, I'm getting stuck at the error 

error: 'Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)'

I've Googled this error, and there are literally hundreds of answers, and I've tried the ones I understood, but to no avail. Since none of them were Alt-F specific, I'm not sure how to implement some of them. If you could help with this, I'd be very much appreciative. Thanks.

[João Cardoso]

On Sunday, 23 July 2017 17:22:12 UTC+1, James Pike wrote:

Joao, when I try to set the admin password, I'm getting stuck at the error 

error: 'Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)'

That means that the server is not running?

You have to install both the mysql and mysql-server packages and start the mysql server.

Have you started it?  Does /var/run/mysql/mysql.sock exists?

If you start it from the command line using "rcmysqld start", the (initial only) printed messages are the default mysql generated ones, not Alt-F generated.

The server is started to run as the 'mysql' user, and should accept connections from the local host.

There is no Alt-F customization whatsoever, apart that the rcmysqld init script launches the server to run as the mysql user, so you can use any tutorial and configure /etc/mysql/my.cnf as you wish.

[James Pike]

rcmysqld start = Starting mysqld safe: OK

Does /var/run/mysql/mysql.sock exists? No, I even ran a search using Filezilla (logged in as root) and there is no mysql.sock file found.

I'm at a loss why I can't get this to work properly. 

My main goal for this, is to get OwnCloud to use MySQL/Maria instead of SQLite (which takes forever to load pages). So if you (or anyone else reading this) know of a down and dirty way of getting this going, I'd be much appreciative.

As of right now, when I try to set OwnCloud up, and tell it to use MySQL/Maria, I get a database not found error. Since I can't get the MySQL to run properly, I can't set up a database for OwnCloud to use. :-(

[João Cardoso]

On Tuesday, 25 July 2017 19:59:14 UTC+1, James Pike wrote:

rcmysqld start = Starting mysqld safe: OK

Does /var/run/mysql/mysql.sock exists? No,

So for some reason the mysqld server isn't run. If you don't any data/database yet and want to start fresh (instead of diagnosing what is wrong) you can do:

ipkg --force-depends remove mysql mysql-libs mysql-server # remove all mysql packages
rm -rf /var/lib/mysql /usr/lib/mysql /usr/share/mysql /usr/lib/libmysqlclient* # remove mysql databases and other mysql info, otherwise they will be reused at re-install
ipkg install mysql mysql-server # re-install fresh
rcmysqld start # start the server, it prints some info, run instead the suggested interactive
mysql_secure_installation # answer the qeustions and assign a root user password
mysql -u root -p # check that you can login to mysql using the root user; the password given above will be asked
 mysql> quit # leave mysql
 Bye

Now install php and lighttpd using the webUI; configure lighttpd using the webUI (Services->Network->lighttpd, Configure), creating and supplying a server root, such as /mnt/sda2/webData. Start lighttpd using the webUI.

At this point, you will be reusing the owncloud previous data and setup, stored at the lighttpd server root, you might have to remove or rename them; reinstalling owncloud without removing or renaming that folders does not means a fresh owncloud install -- <server-root>/owncloud-config <server-root>/owncloud-data. Owncloud itself is stored at /opt/owncloud, and links to data and config are created:

/opt/owncloud/config -> /mnt/sda2/webdata/owncloud-config, /opt/owncloud/data -> /mnt/sda2/webdata/owncloud-data

Preserving owncloud is not /will not be covered here.

Now install owncloud, but don't start it.

Go back to lighttpd configuration webUI enable the xmlwriter, mysql and pdo_mysql (only one should be needed, experiment after having owncloud working) extensions and Submit

Go again to lighttpd configuration and hit the WebPage button. Hit the owncloud link, and enter the owncloud admin user/pass, mysql user root and its password, the owncloud database name, keep the localhost.

It works for me.

It's slow even on a dns-320l. Its php "fault", not sqlite I believe. php (or perl or python) is an interpreted language, and that *is* slow.

[James Pike]

ipkg --force-depends remove mysql mysql-libs mysql-server # remove all mysql packages
rm -rf /var/lib/mysql /usr/lib/mysql /usr/share/mysql /usr/lib/libmysqlclient* # remove mysql databases and other mysql info, otherwise they will be reused at re-install
ipkg install mysql mysql-server # re-install fresh
rcmysqld start # start the server, it prints some info, run instead the suggested interactive
mysql_secure_installation # answer the qeustions and assign a root user password 

All that goes well, until I try to enter the password for root, then I get the socket error again. 

--
You received this message because you are subscribed to a topic in the Google Groups "Alt-F" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/alt-f/u2PLreOvwc4/unsubscribe.
To unsubscribe from this group and all its topics, send an email to alt-f+unsubscribe@googlegroups.com.
Visit this group at https://groups.google.com/group/alt-f.
For more options, visit https://groups.google.com/d/optout.

[João Cardoso]

On Wednesday, 26 July 2017 16:54:09 UTC+1, James Pike wrote:

ipkg --force-depends remove mysql mysql-libs mysql-server # remove all mysql packages
rm -rf /var/lib/mysql /usr/lib/mysql /usr/share/mysql /usr/lib/libmysqlclient* # remove mysql databases and other mysql info, otherwise they will be reused at re-install
ipkg install mysql mysql-server # re-install fresh
rcmysqld start # start the server, it prints some info, run instead the suggested interactive
mysql_secure_installation # answer the qeustions and assign a root user password 

All that goes well, until I try to enter the password for root, then I get the socket error again. 

What is the verbatim output of

rcmysqld start

rcmysqld status

cat /var/log/mysql/mysqld.log

ls -ld /var/run/mysql

ls -l /var/run/mysql

cat /var/run/mysql/mysqld.pid

pidof mysqld

[James Pike]

It looks like there's 2 versions of MySQL, but I even used the command you gave to uninstall it, and remove all traces. So I'm even more stumped now.

[root@DNS-323]# rcmysqld start
Starting mysqld_safe: OK.
[root@DNS-323]# rcmysqld status
mysqld stopped
[root@DNS-323]# cat /var/log/mysql/mysqld.log
170720 18:57:24 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170720 18:57:24 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
170720 18:57:24 [ERROR] Can't start server : Bind on unix socket: Address already in use
170720 18:57:24 [ERROR] Do you already have another mysqld server running on socket: mysql ?
170720 18:57:24 [ERROR] Aborting
170720 18:57:24 [Note] /usr/sbin/mysqld: Shutdown complete
170720 18:57:25 mysqld_safe mysqld from pid file /var/run/mysql/mysqld.pid ended
170720 18:59:44 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170720 18:59:45 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
170720 18:59:45 [ERROR] Can't start server : Bind on unix socket: Address already in use
170720 18:59:45 [ERROR] Do you already have another mysqld server running on socket: mysql ?
170720 18:59:45 [ERROR] Aborting
170720 18:59:45 [Note] /usr/sbin/mysqld: Shutdown complete
170720 18:59:45 mysqld_safe mysqld from pid file /var/run/mysql/mysqld.pid ended
170723 12:18:17 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170723 12:18:18 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
170723 12:18:18 [ERROR] Can't start server : Bind on unix socket: Address already in use
170723 12:18:18 [ERROR] Do you already have another mysqld server running on socket: mysql ?
170723 12:18:18 [ERROR] Aborting
170723 12:18:18 [Note] /usr/sbin/mysqld: Shutdown complete
170723 12:18:18 mysqld_safe mysqld from pid file /var/run/mysql/mysqld.pid ended
170725 14:51:31 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170725 14:51:31 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
170725 14:51:31 [ERROR] Can't start server : Bind on unix socket: Address already in use
170725 14:51:31 [ERROR] Do you already have another mysqld server running on socket: mysql ?
170725 14:51:31 [ERROR] Aborting
170725 14:51:31 [Note] /usr/sbin/mysqld: Shutdown complete
170725 14:51:31 mysqld_safe mysqld from pid file /var/run/mysql/mysqld.pid ended
170726 11:49:42 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170726 11:49:42 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
170726 11:49:42 [ERROR] Can't start server : Bind on unix socket: Address already in use
170726 11:49:42 [ERROR] Do you already have another mysqld server running on socket: mysql ?
170726 11:49:42 [ERROR] Aborting
170726 11:49:42 [Note] /usr/sbin/mysqld: Shutdown complete
170726 11:49:42 mysqld_safe mysqld from pid file /var/run/mysql/mysqld.pid ended
170726 13:56:09 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170726 13:56:09 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
170726 13:56:09 [ERROR] Can't start server : Bind on unix socket: Address already in use
170726 13:56:09 [ERROR] Do you already have another mysqld server running on socket: mysql ?
170726 13:56:09 [ERROR] Aborting
170726 13:56:09 [Note] /usr/sbin/mysqld: Shutdown complete
170726 13:56:09 mysqld_safe mysqld from pid file /var/run/mysql/mysqld.pid ended
170726 13:56:48 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170726 13:56:48 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
170726 13:56:48 [ERROR] Can't start server : Bind on unix socket: Address already in use
170726 13:56:48 [ERROR] Do you already have another mysqld server running on socket: mysql ?
170726 13:56:48 [ERROR] Aborting
170726 13:56:48 [Note] /usr/sbin/mysqld: Shutdown complete
170726 13:56:48 mysqld_safe mysqld from pid file /var/run/mysql/mysqld.pid ended
[root@DNS-323]# ls -ld /var/run/mysql
drwxrwxrwx    2 mysql    mysql           40 Jul 20 18:57 /var/run/mysql
[root@DNS-323]# ls -l /var/run/mysql
total 0
[root@DNS-323]# cat /var/run/mysql/mysqld.pid
cat: can't open '/var/run/mysql/mysqld.pid': No such file or directory
[root@DNS-323]# pidof mysqld
[root@DNS-323]#

[James Pike]

After removing MySQL:

[root@DNS-323]# rm -rf /var/lib/mysql /usr/lib/mysql /usr/share/mysql /usr/lib/libmysqlclient*
[root@DNS-323]# rcmysqld start
-sh: rcmysqld: not found
[root@DNS-323]# rcmysqld status
-sh: rcmysqld: not found
[root@DNS-323]# cat /var/log/mysql/mysqld.log

[root@DNS-323]# ls -ld /var/run/mysql

drwxrwxrwx    2 28       35              40 Jul 20 18:57 /var/run/mysql

[root@DNS-323]# ls -l /var/run/mysql
total 0
[root@DNS-323]# cat /var/run/mysql/mysqld.pid
cat: can't open '/var/run/mysql/mysqld.pid': No such file or directory
[root@DNS-323]# pidof mysqld
[root@DNS-323]#

[João Cardoso]

On Wednesday, 26 July 2017 19:00:01 UTC+1, James Pike wrote:

It looks like there's 2 versions of MySQL, but I even used the command you gave to uninstall it, and remove all traces. So I'm even more stumped now.

[root@DNS-323]# rcmysqld start
Starting mysqld_safe: OK.
[root@DNS-323]# rcmysqld status
mysqld stopped
[root@DNS-323]# cat /var/log/mysql/mysqld.log
170720 18:57:24 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170720 18:57:24 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
170720 18:57:24 [ERROR] Can't start server : Bind on unix socket: Address already in use
170720 18:57:24 [ERROR] Do you already have another mysqld server running on socket: mysql ?

netstat -lnp 

will tell you all processes listening on tcp and unix sockets, you have to discover which one is using the port or socket and kill it.

On my running system, the unix socket mysql.sock and tcp port 3306 belongs to process with pid 2892 and name mysqld

[root@DNS-320L]# netstat -lnp | grep mysql

tcp   0      0 192.168.1.93:3306       0.0.0.0:*               LISTEN      2892/mysqld

unix  2      [ ACC ]     STREAM     LISTENING       5892 2892/mysqld         /var/run/mysql/mysql.sock

[James Pike]

I don't see anything. I'm even more confused now. LOL

[root@DNS-323]# netstat -lnp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name
tcp        0      0 0.0.0.0:515             0.0.0.0:*               LISTEN      742/inetd
tcp        0      0 0.0.0.0:901             0.0.0.0:*               LISTEN      742/inetd
tcp        0      0 0.0.0.0:902             0.0.0.0:*               LISTEN      742/inetd
tcp        0      0 0.0.0.0:873             0.0.0.0:*               LISTEN      742/inetd
tcp        0      0 0.0.0.0:139             0.0.0.0:*               LISTEN      835/smbd
tcp        0      0 0.0.0.0:8080            0.0.0.0:*               LISTEN      1499/lighttpd
tcp        0      0 0.0.0.0:80              0.0.0.0:*               LISTEN      742/inetd
tcp        0      0 0.0.0.0:21              0.0.0.0:*               LISTEN      742/inetd
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      742/inetd
tcp        0      0 0.0.0.0:23              0.0.0.0:*               LISTEN      742/inetd
tcp        0      0 0.0.0.0:8443            0.0.0.0:*               LISTEN      1499/lighttpd
tcp        0      0 0.0.0.0:443             0.0.0.0:*               LISTEN      742/inetd
tcp        0      0 0.0.0.0:445             0.0.0.0:*               LISTEN      835/smbd
tcp        0      0 0.0.0.0:990             0.0.0.0:*               LISTEN      742/inetd
netstat: /proc/net/tcp6: No such file or directory
udp        0      0 0.0.0.0:123             0.0.0.0:*                           758/ntpd
udp        0      0 192.168.0.255:137       0.0.0.0:*                           809/nmbd
udp        0      0 192.168.0.3:137         0.0.0.0:*                           809/nmbd
udp        0      0 0.0.0.0:137             0.0.0.0:*                           809/nmbd
udp        0      0 192.168.0.255:138       0.0.0.0:*                           809/nmbd
udp        0      0 192.168.0.3:138         0.0.0.0:*                           809/nmbd
udp        0      0 0.0.0.0:138             0.0.0.0:*                           809/nmbd
netstat: /proc/net/udp6: No such file or directory
netstat: /proc/net/raw6: No such file or directory
Active UNIX domain sockets (only servers)
Proto RefCnt Flags       Type       State         I-Node PID/Program name    Path
unix  2      [ ACC ]     STREAM     LISTENING       1958 1500/php-cgi        /var/lib/lighttpd/sockets/php.socket-0
unix  2      [ ACC ]     STREAM     LISTENING       1960 1501/php-cgi        /var/lib/lighttpd/sockets/php.socket-1
unix  2      [ ACC ]     STREAM     LISTENING       1962 1502/php-cgi        /var/lib/lighttpd/sockets/php.socket-2
unix  2      [ ACC ]     STREAM     LISTENING       1964 1503/php-cgi        /var/lib/lighttpd/sockets/php.socket-3
unix  2      [ ACC ]     STREAM     LISTENING       1154 809/nmbd            /var/run/samba/unexpected

On Wed, Jul 26, 2017 at 2:19 PM, João Cardoso <whoami...@gmail.com> wrote:

On Wednesday, 26 July 2017 19:00:01 UTC+1, James Pike wrote:

It looks like there's 2 versions of MySQL, but I even used the command you gave to uninstall it, and remove all traces. So I'm even more stumped now.

[root@DNS-323]# rcmysqld start
Starting mysqld_safe: OK.
[root@DNS-323]# rcmysqld status
mysqld stopped
[root@DNS-323]# cat /var/log/mysql/mysqld.log
170720 18:57:24 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170720 18:57:24 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
170720 18:57:24 [ERROR] Can't start server : Bind on unix socket: Address already in use
170720 18:57:24 [ERROR] Do you already have another mysqld server running on socket: mysql ?

netstat -lnp 

will tell you all processes listening on tcp and unix sockets, you have to discover which one is using the port or socket and kill it.

On a running system, the unix socket mysql.sock and tcp port 3306 should belong to process with pid 2892 and name mysqld

[James Pike]

[João Cardoso]

On Wednesday, 26 July 2017 19:25:56 UTC+1, James Pike wrote:

I don't see anything. I'm even more confused now. LOL

Yes, no process seem to be using the resource needed by mysql.

But when a file (unix socket /var/... in this case) is deleted and still in use, its directory entry will disappear but the file still exists -- that might be what is happening. Or there might be a side effect of the "dirty tricks" that you have read and applied? Don't know, reboot the box (yeah, looks like ms-windows now)

[James Pike]

Rebooted the box, repeated the steps you gave, and when I got to the root password again, got the socket error.
Do you think a clean install of Atl-F1.0 would help? I upgrade to the RC6, then 1.0. 

[João Cardoso]

On Wednesday, 26 July 2017 20:24:18 UTC+1, James Pike wrote:

Rebooted the box, repeated the steps you gave,

You should have verified the existence of /var/run/mysql/mysql.sock and the contents of /var/log/mysql/mysqld.log right after the *fresh* install and rcmysqld start.

For reference, I get:

[root@DNS-320L]# ls -l /var/run/mysql/mysql.sock 

srwxrwxrwx    1 mysql    mysql            0 Jul 26 21:35 /var/run/mysql/mysql.sock

[root@DNS-320L]# cat /var/log/mysql/mysqld.log 

170726 21:35:01 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

170726 21:35:01 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.

170726 21:35:01 [Note] Event Scheduler: Loaded 0 events

170726 21:35:01 [Note] /usr/sbin/mysqld: ready for connections.

Version: '5.1.73-log'  socket: '/var/run/mysql/mysql.sock'  port: 3306  Source distribution

 

and when I got to the root password again,

What password did you enter? The root (superuser) password? mysql has a blank password by default, the initial password question asked by mysql_secure_installation should be answered with a simple <enter>. (don't know why mysql calls it the root user, it is the mysql admin user, not the root user. But I'm no mysql expert).

And to use mysql I don't even need to run mysql_secure_installation or run any other command, a plain 'mysql' command after installation and starting puts me right on the mysql prompt.

 

got the socket error.

But if that (password) was the error you should get a " Access denied for user..." message, not the socket error.

Have you edited the /etc/mysql/my.cnf?

Do you think a clean install of Atl-F1.0 would help?

I don't think that is related. At most something in the Alt-F folder (use Packages->Alt-F webui to disable or delete it, if you want to try).

I can't diagnose it any further, sorry.

[João Cardoso]

Of course I get your error if I stop the mysql server and try to acess it:

[root@DNS-320L]# rcmysqld stop

Stopping mysqld: OK.

[root@DNS-320L]# mysql

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)

but then,

[root@DNS-320L]# rcmysqld start

Starting mysqld_safe: OK.

[root@DNS-320L]# mysql

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 1

Server version: 5.1.73-log Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> 

 

I upgrade to the RC6, then 1.0. 

[James Pike]

Well, I'm still getting the error. Tried just hitting enter at the root password prompt, and got the error again.

I've noticed if I start the server...it instantly shuts down again with that error:

[ERROR] Can't start server : Bind on unix socket: Address already in use

[ERROR] Do you already have another mysqld server running on socket: mysql ?

[ERROR] Aborting

But you saw, there's nothing using that socket. I'm gonna have to wait until later tonight (This NAS is my TV Show streamer, and my grandsons are watching Blue's Clues from it, right now. LOL) and I'm just going to wipe the drives, and install a clean install of 1.0. Something had to of gotten screwed up. I'm going to use you directions above, to install it, and see how it goes. Hopefully it'll take.  

[João Cardoso]

On Thursday, 27 July 2017 00:18:07 UTC+1, James Pike wrote:

Well, I'm still getting the error. Tried just hitting enter at the root password prompt, and got the error again.

I've noticed if I start the server...it instantly shuts down again with that error:

[ERROR] Can't start server : Bind on unix socket: Address already in use
[ERROR] Do you already have another mysqld server running on socket: mysql ?
[ERROR] Aborting

But you saw, there's nothing using that socket. I'm gonna have to wait until later tonight (This NAS is my TV Show streamer, and my grandsons are watching Blue's Clues from it, right now. LOL) and I'm just going to wipe the drives,

You don't need to wipe the drives, just go to Packages->Alt-F, and on section "Packages Installed On" hit the Delete button; if you get an error saying that it was not possible, uncheck the "Boot Enable", Submit and then reboot. The Alt-F folder will not be used after the reboot and you Delete it.

That is the only place on disk where Alt-F saves packages and packages data.

 

and install a clean install of 1.0. Something had to of gotten screwed up. I'm going to use you directions above, to install it, and see how it goes.

I have just done the above and reinstalled mysql and mysql-server using only the webUI, started it using only the webui and it worked fine. To check the installation you only need that, there is no need to use any command (only 'mysql' to get a prompt and see that is working, or 'rcmysqld status'). Read the log.

ah, I'm assuming you are not using any ffp or entware or debian packages...

 

Hopefully it'll take.  

[P Perazim]

Is it possible to use the alt-f httpd as a web server to supply debian repositories to my net?

I was just going to link the repositories under /var/www/html but it is not there.

Thanks for any insight.

Perazim

[Joao Cardoso]

On Aug 2, 2017 4:19 PM, "'P Perazim' via Alt-F" <al...@googlegroups.com> wrote:

Is it possible to use the alt-f httpd as a web server

I belive you can as long as you supply the full url.

But why not install lighttpd alt-f package and use it instead? Packages>alt-f then Services>network>lighttpd, Configure.

To change the default port number you might have also to use services>network>html, Configure

to supply debian repositories to my net?

That can't tell

I was just going to link the repositories under /var/www/html but it is not there.

Try /usr/www

Thanks for any insight.

Perazim

--
You received this message because you are subscribed to the Google Groups "Alt-F" group.
To unsubscribe from this group and stop receiving emails from it, send an email to alt-f+unsubscribe@googlegroups.com.

[P Perazim]

I got lighttpd running on a non-standard port.

I had asked but not heard about the max drive size in alt-f. I think you were on vacation. WD has announced drives as large as 14TB.

Thanks,

Perazim
 

[Joao Cardoso]

On Aug 4, 2017 4:27 PM, "'P Perazim' via Alt-F" <al...@googlegroups.com> wrote:

I got lighttpd running on a non-standard port.

I had asked but not heard about the max drive size in alt-f.

It was tested with a virtual 8TB disk, and I think to remember that someone used it on a real 6TB disk.

drives with "4K native"  (4Kn, generally expensive enterprise 

-level drives) sectors are not supported by the webui, ony 512e and 512n.

I think you were on vacation.

I still am 😊

WD has announced drives as large as 14TB.

Thanks,

Perazim
 

--