| View previous topic :: View next topic |
| Author |
Message |
tabanus
l33t
Joined: 11 Jun 2004
Posts: 631
Location: UK
|
 Posted: Mon Jan 22, 2018 11:39 pm Post subject: Nextcloud internal server error [MySQL issue] [Solved] |
 |
|
I had Nextcloud working perfectly with lighttpd and mysql, but after a re-boot it's started to refuse connections.
The web interface says "Internal Server Error".
In the /var/log/lighttpd/error.log I'm getting lots of errors that look like this:
| Code: | 2018-01-22 22:45:40: (mod_fastcgi.c.2543) FastCGI-stderr: PHP message: {"reqId":"uzUA4itXhxCCbIjFIK4a","level":3,"time":"2018-01-22T22:45:40+00:00","remoteAddr":"x.x.x.x",
"user":"--","app":"PHP","method":"GET","url":"\/nextcloud\/status.php","message":"touch(): Utime failed: Permission denied at \/var\/www\/localhost\/htdocs\/nextcloud\/lib\/private\/Config.php#239","userAgent":"Mozilla\/5.0 (Linux) mirall\/2.3.3 (Nextcloud)","version":""}
2018-01-22 22:45:40: (mod_fastcgi.c.2543) FastCGI-stderr: PHP message: {"reqId":"uzUA4itXhxCCbIjFIK4a","level":3,"time":"2018-01-22T22:45:40+00:00","remoteAddr":"x.x.x.x",
"user":"--","app":"PHP","method":"GET","url":"\/nextcloud\/status.php","message":"fopen(\/var\/www\/localhost\/htdocs\/nextcloud\/config\/config.php): failed to open stream: Permission denied at \/var\/www\/localhost\/htdocs\/nextcloud\/lib\/private\/Config.php#240","userAgent":"Mozilla\/5.0 (Linux) mirall\/2.3.3 (Nextcloud)","version":""}
2018-01-22 22:45:40: (mod_fastcgi.c.2543) FastCGI-stderr: PHP message: {"reqId":"uzUA4itXhxCCbIjFIK4a","level":3,"time":"2018-01-22T22:45:40+00:00","remoteAddr":"x.x.x.x",
"user":"--","app":"PHP","method":"GET","url":"\/nextcloud\/status.php","message":"chmod(): Operation not permitted at \/var\/www\/localhost\/htdocs\/nextcloud\/lib\/private\/Config.php#243","userAgent":"Mozilla\/5.0 (Linux) mirall\/2.3.3 (Nextcloud)","version":""}
2018-01-22 22:45:40: (mod_fastcgi.c.2543) FastCGI-stderr: PHP message: {"reqId":"uzUA4itXhxCCbIjFIK4a","level":4,"time":"2018-01-22T22:45:40+00:00","remoteAddr":"x.x.x.x",
"user":"--","app":"remote","method":"GET","url":"\/nextcloud\/status.php","message":"Can't write into config directory!","userAgent":"Mozilla\/5.0 (Linux) mirall\/2.3.3 (Nextcloud)","version":""}
2018-01-22 22:45:40: (mod_fastcgi.c.2543) FastCGI-stderr: PHP message: {"reqId":"uzUA4itXhxCCbIjFIK4a","level":3,"time":"2018-01-22T22:45:40+00:00","remoteAddr":"x.x.x.x",
"user":"--","app":"PHP","method":"GET","url":"\/nextcloud\/status.php","message":"fopen(\/var\/www\/localhost\/htdocs\/nextcloud\/data\/nextcloud.log): failed to open stream: Permission denied at \/var\/www\/localhost\/htdocs\/nextcloud\/lib\/private\/Log\/File.php#132","userAgent":"Mozilla\/5.0 (Linux) mirall\/2.3.3 (Nextcloud)","version":""}
|
(I've replaced the ip address with x.x.x.x . This address is the IP of a client trying to connect in).
Maybe a permissions thing, or have I screwed up the connection to mysql somehow?
[Moderator edit: broke long whitespace-free lines in code tags to fix thread layout. -Hu]
Last edited by tabanus on Wed Jan 24, 2018 12:05 pm; edited 2 times in total |
|
| Back to top |
|
 |
toofied
n00b
Joined: 26 Oct 2016
Posts: 27
|
|
| Back to top |
|
|
tabanus
l33t
Joined: 11 Jun 2004
Posts: 631
Location: UK
|
| Posted: Tue Jan 23, 2018 10:53 am Post subject: |
|
|
This is a new installation. Was fine until I re-booted.
_________________
Things you might say if you never took Physics: "I'm overweight even though I don't overeat." - Neil deGrasse Tyson |
|
| Back to top |
|
|
tabanus
l33t
Joined: 11 Jun 2004
Posts: 631
Location: UK
|
| Posted: Tue Jan 23, 2018 5:46 pm Post subject: |
|
|
I've isolated the problem to my mysql setup.
Found this in the Nextcloud log:
| Code: | | An exception occurred while executing 'DELETE FROM `oc_authtoken` WHERE `token` = ?' with params ["db1250623b74e1394098e5c8e1add8d2b2d1d27f0158ea9d75e3068dd6e1c76849723a49b337efa040abc4e4d37262088f82e3c38fe678f061b39c2d982a49ee"]: SQLSTATE[HY000]: General error: 1665 Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED. |
I sorted this by logging into mysql and setting the binary log format to ROW, and everything works again.
I know I did this when I set up in the first place, so the question now is: how do I make this persist after a reboot?
The mysql website says
| Quote: | | You can select the binary logging format explicitly by starting the MySQL server with --binlog-format=type. |
I can't see anything in the mysql config files to set this though. |
|
| Back to top |
|
|
tabanus
l33t
Joined: 11 Jun 2004
Posts: 631
Location: UK
|
| Posted: Wed Jan 24, 2018 12:04 pm Post subject: |
|
|
Finally sorted. For anyone else hitting this problem, solved by adding this line to the [mysqld] section of /etc/mysql/my.cnf
| Code: | | binlog-format = ROW |
Thanks for your help everyone. 
_________________
Things you might say if you never took Physics: "I'm overweight even though I don't overeat." - Neil deGrasse Tyson |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
Networking & Security
