MySQL error on seaf startup

Seafile Server
1

Hello,
seafile isn’t working for me anymore.
I get the following error when starting ./seafile.sh:

SQLException: Failed to start connection pool -- Access denied for user 'seafile'@'5.3.51.44' (using password: YES) raised in ConnectionPool_start at src/db/ConnectionPool.c:287 failed to run "ccnet-server -t"

The mysql user is setup correctly in the configs, its possible for me to login in with mysql -u seafile -p.
It doesn’t matter if using root user or seafile user for mysql, the error is still there.

Using Debian GNU/Linux 7.11 (wheezy) and Seafile 5.0.4.

2

Does “mysql -u seafile -p -h 5.3.51.44” work? Without -h mysql uses localhost (127.0.0.1) which is different from your config.

3

Normally the seafile database user got only access rights from ‘localhost’ / ‘127.0.0.1’

4

I’ve tried this right now, and it’s not possible to log in that way.

But the host is set to 127.0.0.1 in ccnet.conf and seafile.conf already, where is the problem?

5

Fixed it now by granting seafile@’%’. I know, its a dirty way…

Now getting this error when connecting, the browser is loading nearly infinite…

[09/24/16 16:10:45] ../common/session.c(132): using config file /var/lib/seafile/haiwen/conf/ccnet.conf [09/24/16 16:10:45] ../common/session.c(455): socket file exists, delete it anyway [09/24/16 16:10:45] ../common/session.c(484): Listen on /var/lib/seafile/haiwen/ccnet/ccnet.sock for local clients [09/24/16 16:10:45] ../common/session.c(290): Update pubinfo file [09/24/16 16:10:46] ../common/session.c(398): Accepted a local client [09/24/16 16:10:46] ../common/session.c(398): Accepted a local client [09/24/16 16:10:46] ../common/session.c(398): Accepted a local client [09/24/16 16:10:46] ../common/session.c(398): Accepted a local client [09/24/16 16:10:46] ../common/peer.c(941): libevent got an error! what=33, errno=104 (Connection reset by peer) [09/24/16 16:10:46] ../common/peer.c(943): Local peer down [09/24/16 16:10:46] ../common/peer.c(943): Local peer down [09/24/16 16:10:56] ../common/session.c(398): Accepted a local client [09/24/16 16:10:56] ../common/session.c(398): Accepted a local client [09/24/16 16:10:56] ../common/peer.c(941): libevent got an error! what=33, errno=104 (Connection reset by peer) [09/24/16 16:10:56] ../common/peer.c(943): Local peer down [09/24/16 16:10:56] ../common/peer.c(943): Local peer down [09/24/16 16:11:02] ../common/session.c(398): Accepted a local client [09/24/16 16:11:06] ../common/session.c(398): Accepted a local client [09/24/16 16:11:06] ../common/session.c(398): Accepted a local client [09/24/16 16:11:06] ../common/peer.c(941): libevent got an error! what=33, errno=104 (Connection reset by peer) [09/24/16 16:11:06] ../common/peer.c(943): Local peer down [09/24/16 16:11:06] ../common/peer.c(943): Local peer down [09/24/16 16:11:15] ../common/session.c(398): Accepted a local client [09/24/16 16:11:16] ../common/session.c(398): Accepted a local client [09/24/16 16:11:16] ../common/session.c(398): Accepted a local client [09/24/16 16:11:16] ../common/peer.c(941): libevent got an error! what=33, errno=104 (Connection reset by peer) [09/24/16 16:11:16] ../common/peer.c(943): Local peer down [09/24/16 16:11:16] ../common/peer.c(943): Local peer down [09/24/16 16:11:26] ../common/session.c(398): Accepted a local client [09/24/16 16:11:26] ../common/session.c(398): Accepted a local client [09/24/16 16:11:26] ../common/peer.c(941): libevent got an error! what=33, errno=104 (Connection reset by peer) [09/24/16 16:11:26] ../common/peer.c(943): Local peer down [09/24/16 16:11:26] ../common/peer.c(943): Local peer down

6

Edit #2 fixed the privious error by running **./setup-seafile-mysql.sh
**. I was able to login, BUT all my seafile libs are broken, what should i do now?

7

SOLVED all, thank for you help, guys.