Author Topic: HELP:I think I am boned password change assistance sorely needed  (Read 275 times)

Offline guardian452

  • Newbie
  • *
  • Posts: 6
so hears the rub folks I am helping out at a local pc-shop the so called 'server guy' walked out and left the owner holding the bag now we need to reset a users password and honestly I have no frigging clue what I am doing or what the previous 'server guy' did

I have done some googling about setting up some sort of plugin but my php experience is basically null they are running zplanel and roundcube there is no linked domain in zpanel for roundcube nor any users to manage

so my question is where the guy fawks are the userland email login and passwords stored with roundcube and can I easily edit them
I gotta get this one user back in untill we can get a guy to comeout and migrate this unholy mess

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 4,956
    • http://SKaero.com/
Re: HELP:I think I am boned password change assistance sorely needed
« Reply #1 on: January 10, 2017, 01:22:42 PM »
Passwords are stored in Roundcube it needs to be changed on the mail server. As for where the mail is that depends on the setup your dealing with. If zpanel doesn't have any information in maybe check what server Roundcube is connecting to in the Roundcube config.

Offline guardian452

  • Newbie
  • *
  • Posts: 6
Re: HELP:I think I am boned password change assistance sorely needed
« Reply #2 on: January 10, 2017, 01:48:50 PM »
all I found was its running dovecot and something called ESMTP Postfix
I am assuming From my googling I need to change the userpassword via dovecot ...

I honestly have zero clue about any of this server-guy smash-quit and left us holding the bag

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 4,956
    • http://SKaero.com/
Re: HELP:I think I am boned password change assistance sorely needed
« Reply #3 on: January 10, 2017, 02:30:01 PM »
Your correct that you need to change the password in dovecot (and maybe postfix depending on configuration) if you post the dovecot configurations we can try to figure out how its authenticating users.

Offline guardian452

  • Newbie
  • *
  • Posts: 6
Re: HELP:I think I am boned password change assistance sorely needed
« Reply #4 on: January 10, 2017, 04:20:08 PM »
here is the config
http://pastebin.com/V1GPbbJT

 I tried  doveadm pw -s CRYPT -p mapleleaf -u info@outonalimbmaple.com

it retuned with a crypted message
« Last Edit: January 10, 2017, 04:31:15 PM by guardian452 »

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 4,956
    • http://SKaero.com/
Re: HELP:I think I am boned password change assistance sorely needed
« Reply #5 on: January 10, 2017, 05:01:51 PM »
It looks like the users are stored in a zpanel database. Look in the /etc/zpanel/configs/dovecot2/dovecot-mysql.conf file to figure out which database and table the users are stored in.

the "doveadm pw" command is just used to created a hashed password it doesn't actually change anything.

Offline guardian452

  • Newbie
  • *
  • Posts: 6
Re: HELP:I think I am boned password change assistance sorely needed
« Reply #6 on: January 10, 2017, 05:09:16 PM »
i already found that config the database is zpanel_postfix
so now I need to figure out how to locate it and manually edit it
I really appreciate the help this client has been breathing down his neck and I need to get this sorted ideally today

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 4,956
    • http://SKaero.com/
Re: HELP:I think I am boned password change assistance sorely needed
« Reply #7 on: January 10, 2017, 05:14:30 PM »
If you don't know SQL try installing phpmyadmin so you can see the database contents.

Offline guardian452

  • Newbie
  • *
  • Posts: 6
Re: HELP:I think I am boned password change assistance sorely needed
« Reply #8 on: January 10, 2017, 05:56:36 PM »
zpanel does not list the database I can

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 4,956
    • http://SKaero.com/
Re: HELP:I think I am boned password change assistance sorely needed
« Reply #9 on: January 10, 2017, 06:09:59 PM »
You can install phpmyadmin outside of zpanel. The configuration file should have a mysql username and password and if you login to phpmyadmin with that information you should see the correct database.

Offline guardian452

  • Newbie
  • *
  • Posts: 6
Re: HELP:I think I am boned password change assistance sorely needed
« Reply #10 on: January 10, 2017, 06:37:34 PM »
!solved I was able to get into the database via phpmy admin by manually entering the database name found in the configs

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 4,956
    • http://SKaero.com/
Re: HELP:I think I am boned password change assistance sorely needed
« Reply #11 on: January 10, 2017, 07:03:58 PM »
Good to hear you got it resolved.