HELP:I think I am boned password change assistance sorely needed

[guardian452]

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

[SKaero]

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.

[guardian452]

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

[SKaero]

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.

[guardian452]

here is the config
http://pastebin.com/V1GPbbJT

I tried  doveadm pw -s CRYPT -p mapleleaf -u [email protected]

it retuned with a crypted message

[SKaero]

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.

[guardian452]

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

[SKaero]

If you don't know SQL try installing phpmyadmin so you can see the database contents.

[guardian452]

zpanel does not list the database I can

[SKaero]

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.

[guardian452]

!solved I was able to get into the database via phpmy admin by manually entering the database name found in the configs

[SKaero]

Good to hear you got it resolved.