Sponsor:

Server and Web Integrator
Link:
Kloxo-MR logo
6.5.0 or 7.0.0
Click for "How to install"
Donation/Sponsorship:
Kloxo-MR is open-source.
Donate and or Sponsorship always welcome.
Click to:
Click Here
Please login or register. 2024-07-15, 23:33:07

Author Topic: Slave change password  (Read 5828 times)

0 Members and 1 Guest are viewing this topic.

Offline fossxplorer

  • Master
  • **
  • Posts: 640
  • Karma: +1/-0
    • View Profile
Slave change password
« on: 2016-07-17, 00:25:16 »
Just added slave, but i can't change password. See img.
Any other ways?

Tried on the slave:
[root@c6 ~]# sh /script/change-root-password
chpasswd: line 1: user '' does not exist
chpasswd: error detected, changes ignored
[root@c6 ~]#
Kloxo-MR!

Offline fossxplorer

  • Master
  • **
  • Posts: 640
  • Karma: +1/-0
    • View Profile
Re: Slave change password
« Reply #1 on: 2016-07-17, 01:14:19 »
root@c6 ~]# sh /script/resetpassword master 'newpass'
Error message: only_admin_can_modify_general nname
Kloxo-MR!

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Slave change password
« Reply #2 on: 2016-07-17, 05:17:47 »
Still trouble for slave server. No solution at this moment.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline fossxplorer

  • Master
  • **
  • Posts: 640
  • Karma: +1/-0
    • View Profile
Re: Slave change password
« Reply #3 on: 2016-07-17, 11:14:38 »
Hmm too bad, this is a very needed functionality to have some load distribution among servers.
Will the DNS part of slave work or is nothing working at the moment?

We really  really need to have multiple Kloxo-MR servers.
Kloxo-MR!

Offline fossxplorer

  • Master
  • **
  • Posts: 640
  • Karma: +1/-0
    • View Profile
Re: Slave change password
« Reply #4 on: 2016-07-17, 11:53:54 »
Most of the slave seem to be working from master, when i played around.
But afterwards i had to remove the slave from "Servers" using Force delete due to error about remote authetication error and now i'm unable add the server back. Not sure what changes i've made that causes this, but i reset mysql password for slave from the master.

Now i see
ERROR 1045 (28000): Access denied for user 'kloxo'@'localhost' (using password: YES)
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

How can i try to fix it?
I alread ran mysql-kloxo reset password, it outputs the newpassword, but on a new line i see 1045. Is that an error return code?
Kloxo-MR!

Offline fossxplorer

  • Master
  • **
  • Posts: 640
  • Karma: +1/-0
    • View Profile
Re: Slave change password
« Reply #5 on: 2016-07-17, 12:12:19 »
Ok, i was able to fix it and get back to where i was:
[root@c6 ~]# sh /script/reset-mysql-root-password
[root@c6 ~]# sh /script/fix-program-mysql
[root@c6 ~]# sh /script/cleanup


Now i'm back to where i started :)

Question is, what is the mysql root password now? :)
Kloxo-MR!

Offline fossxplorer

  • Master
  • **
  • Posts: 640
  • Karma: +1/-0
    • View Profile
Re: Slave change password
« Reply #6 on: 2016-07-17, 12:49:41 »
And now i ran  sh /script/reset-mysql-root-password  mypassword
It seems to be working and i start to like it.

@Mustafa, do you think we can get the slave functionality to work 100% soon?
It will make Kloxo-MR rock and make it ready to be used by serious web hosters.

If you need money/time, what about starting a kickstarter/indiegogo to fund it? Can at least give it a try.

 
Kloxo-MR!

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Slave change password
« Reply #7 on: 2016-07-17, 12:50:47 »
Information about mysql root password in /usr/local/lxlabs/kloxo/etc/slavedb/dbadmin (by 'sh /script/reset-mysql-root-password') and mysql kloxo password in /usr/local/lxlabs/kloxo/etc/conf/kloxo.pass (by 'sh /script/fix-program-mysql').
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline fossxplorer

  • Master
  • **
  • Posts: 640
  • Karma: +1/-0
    • View Profile
Re: Slave change password
« Reply #8 on: 2016-07-17, 13:56:04 »
Thanks.
Now i'm trying to create a database for a client that i've created at the slave, look at the image.

I was logging at the slave and i see:
160717 14:13:09     105 Connect   root@localhost as anonymous on
        105 Connect   Access denied for user 'root'@'localhost' (using password: NO)
        106 Connect   root@localhost as anonymous on
        106 Connect   Access denied for user 'root'@'localhost' (using password: NO)

Master is connecting to slave without a mysql root password? Where are these details stored on the master?





Information about mysql root password in /usr/local/lxlabs/kloxo/etc/slavedb/dbadmin (by 'sh /script/reset-mysql-root-password') and mysql kloxo password in /usr/local/lxlabs/kloxo/etc/conf/kloxo.pass (by 'sh /script/fix-program-mysql').
Kloxo-MR!

Offline fossxplorer

  • Master
  • **
  • Posts: 640
  • Karma: +1/-0
    • View Profile
Re: Slave change password
« Reply #9 on: 2016-07-17, 15:16:19 »
So i was able to fix that too, by reseting the slave's mysql root password through master, and then running sh /scripts/fix-program-mysql newpassword on the slave.
So now i can create new DB for clients assigned to the slave.  GREAAT :)

But i tried to "move" an existing client of the master and got an error. See pic.
Do you think we can fix this?

 
Kloxo-MR!

 


Top 4 Global Search Engines:    Google    Bing    Baidu    Yahoo

Page created in 0.026 seconds with 18 queries.

web stats analysis