Do have problems with nginx configuration

openalf · Jun 16th 2016

I can't remember the password for mysql anymore; I noted it down the day a did the seafile install but put the note away. So how to get it get back again?

baldman · Jun 16th 2016

mmm not sure on that one, Maybe remove and re-install the MySQL plugin... IF you aren't using MySQL databases on other applications. You will probably need to remove the data from the MySQL-Data folder too.

tinh_x7 · Jun 16th 2016

Try this:

Log in as root and stop the mysql daemon. Now lets start up the mysql daemon and skip the grant tables which store the passwords.
sudo /etc/init.d/mysql stop
mysqld_safe --skip-grant-tables
You should see mysqld start up successfully. If not, well you have bigger issues. Now you should be able to connect to mysql without a password.
mysql --user=root mysql

Code

update user set Password=PASSWORD('new-password') where user='root';
flush privileges;
exit

Then restart it normally. You should be good to go.

Zoki · Jun 16th 2016

Quote from openalf

I can't remember the password for mysql anymore; I noted it down the day a did the seafile install but put the note away. So how to get it get back again?

http://dev.mysql.com/doc/refma…ting-permissions.html</a>

to stop mysql use

Code

/etc/init.d/mysql stop

to start mysql use

Code

/etc/init.d/mysql start

Zoki · Jun 16th 2016

Quote from openalf

Well I did uninstall seafile; but before I start the new installation I like to understand if I should create a new folder or should I place it under /root/seafile? I also belive that I don't need to make a new configuration for mysql? What else should I think about before doing the installation. Don't get me wrong I'm not lazy but I feel that I should discuss those steps before I go ahead again.

I do not know how you did the first install of seafile. If you created a seafile user and re going to follow the new guide, you should delete the old seafile user first :

Code

userdel seafile

@baldman
And please not: there is a step missing in the new tutorial in part 4 between step 6 and 7:

6b restart seafile to make it recognize the new settings

Code

/etc/init.d/seafile-server stop
/etc/init.d/seafile-server start

baldman · Jun 16th 2016

@Zoki I'll have another look at that in the guide. When I tested it it worked so didn't think it needed restarting.

baldman · Jun 17th 2016

@Zoki, Restarting either Seafile the way you said above or restarting Nginx did not work for me in a fresh new VM. The only thing that worked was to reboot the server. I original had a step there saying to reboot but someone asked me to remove that step saying I was not necessary. For now I will have to put it back in or people will complain about bad gateways. I'll do some more testing later, we might need to restart it another way.

openalf · Jun 17th 2016

Sorry, but what should happen here?

Code

Stopping MySQL database server: mysqld.
root@NAS:~# mysqld_safe --skip-grant-tables
160617 16:55:20 mysqld_safe Logging to syslog.
160617 16:55:20 mysqld_safe Starting mysqld daemon with databases from /media/4fcfda30-31ac-49ad-8d8c-d84723cbe1af/MYSQL-DATA/

baldman · Jun 17th 2016

Did you remove the data from that folder before you reinstalled mysql?... did you reinstall a fresh mysql?

openalf · Jun 17th 2016

I deleted the 3 dbase is that good enough?

openalf · Jun 17th 2016

Where do I set the new password?

Code

update user set Password=Password('new-password') where user='root';

I'm not sure but do I need to rename =Password or do I change the one inside ( )?

ryecoaaron · Jun 17th 2016

Change the:
new-password
to your new password:
really_good_password!

openalf · Jun 17th 2016

Now I get a syntax error

ryecoaaron · Jun 17th 2016

Can you cut&paste the error and command you executed minus the new password?

openalf · Jun 17th 2016

Code

root@NAS:~# update user set Password=Password('new-password') where user='root'
-bash: Syntaxfehler beim unerwarteten Wort `('
root@NAS:~#

ryecoaaron · Jun 17th 2016

You need to login to mysql to execute that command. Starting mysql in safe mode allows you to do that with no password. As root,
execute: mysql then enter the update user sql command. Don't forgot the semi-colon at the end.

openalf · Jun 17th 2016

Not sure what I do wrong...

root@NAS:~# sudo /etc/init.d/mysql stop
Stopping MySQL database server: mysqld.
root@NAS:~# mysqld_safe --skip-grant-tables
160617 19:34:48 mysqld_safe Logging to syslog.
160617 19:34:48 mysqld_safe Starting mysqld daemon with databases from /media/4fcfda30-31ac-49ad-8d8c-d84723cbe1af/MYSQL-DATA/

How do I see that mysql starts automatically
Should I see

root@nas again or?

baldman · Jun 17th 2016

I think that line is two separate lines.

enter this: UPDATE mysql.user SET Password = PASSWORD('NEW.PASSWORD.HERE')
Then this: WHERE User = 'root';

openalf · Jun 17th 2016

Something looks wrong to me:

Code

Stopping MySQL database server: mysqld.
root@NAS:~# mysqld_safe --skip-grant-tables
160617 20:05:24 mysqld_safe Logging to syslog.
160617 20:05:24 mysqld_safe Starting mysqld daemon with databases from /media/4fcfda30-31ac-49ad-8d8c-d84723cbe1af/MYSQL-DATA/
mysql --user=root mysql
update user set Password=PASSWORD('xxxxx9999') where user='root';
flush privileges;


sudo /etc/init.d/mysql start

openalf · Jun 17th 2016

I also see that I do have a seafile db file, do I need to delete that one?

Code

root@NAS:~# ls -l
insgesamt 62824
-rw-r--r-- 1 root root 26368468 jul  2  2015 CrashPlan_4.3.0_Linux.tgz
-rw-r--r-- 1 root root 37926486 sep 30  2015 CrashPlan_4.4.1_Linux.tgz
drwxr-xr-x 3 root root     4096 sep 30  2015 crashplan-install
drwxr-xr-x 3 1001 plex     4096 aug 22  2015 CrashPlan-install
-rw-r--r-- 1 root root    10758 maj 25 22:05 --database=seafile-db
drwxr-xr-x 2 root root     4096 jan 24  2015 mnt
drwxr-xr-x 2 root root     4096 jan 24  2015 mynas
drwxr-xr-x 2 root root     4096 maj 16 11:54 openvpnfiles
root@NAS:~#

Display More

Participate now!