MYSQL password for Zentyal 2.0

[nordge1]

It looks like mysql comes pre-installed on 2.0. When I try and install phpmyadmin, it asks me for the administrative password. I entered my Zentyal password thinking they might be synced but no luck. Is there a default password that Zentyal is using when it installs?
Help
Thanks

[J. A. Calvo]

mysql is only installed as a dependency of the zarafa module, the password is stored in the following file:

/var/lib/ebox/conf/ebox-zarafa.passwd

[nordge1]

Thanks for the quick response.
Can I change it? Maybe by updating the file you mentioned and mysql?

[J. A. Calvo]

Yes, I think there is no problem if you change it in both places.

[nordge1]

Solved:

1.Change the default password in the config file for Zentyal

Code: [Select]

sudo nano /var/lib/ebox/conf/ebox-zarafa.passwd2. Copy and paste the password to a text file for root login later. Comment out the password in the file and list your new password for mysql. Then press ctrl 'x' then 'y'
3. Stop the MySQL Server.

Code: [Select]

sudo /etc/init.d/mysql stop4. Start the mysqld configuration

Code: [Select]

sudo mysqld --skip-grant-tables &5. Login to MySQL as root. EDIT: Use original password in "ebox-zarafa.passwd", the one you commented out in step 2

Code: [Select]

mysql -u root mysql6. Replace YOURNEWPASSWORD with your new password!

Code: [Select]

UPDATE user SET Password=PASSWORD('YOURNEWPASSWORD') WHERE User='root'; FLUSH PRIVILEGES; exit;
You can then install phpmyadmin and gain access for root

[thorsten]

Hi

1.Change the default password in the config file for Zentyal

Code: [Select]

sudo nano /var/lib/ebox/conf/ebox-zarafa.passwd2. Copy and paste the password to a text file for root login later. Comment out the password in the file and list your new password for mysql. Then press ctrl 'x' then 'y'

I am sorry, I am real newbie ... can you point out these two steps:

1) I made the password ("some cryptic text") to #"some cryptic text"
and added "test" in a new line

2) 

Code: [Select]

sudo cp /var/lib/ebox/conf/ebox-zarafa.passwd /var/lib/ebox/conf/ebox-zarafa.passwd.bak
was that OK?

It seems that it does not work: I can not access Zarafa and I am locked out from MySQL at all... a dpkg reconfigure and / or uninstall / install of the respective zentyal modules (zarafa, mail) does not help...

Any ideas, thanks
Thorsten

[nordge1]

Those both seem fine.
Did you do the rest of the steps to change the password in MySQL (steps 3-6) ? Did you receive any errors during those steps?

[nordge1]

Did you use the original password when you logged into mysql to change the password? See edit above

[nordge1]

J. A. Calvo
I am having real trouble getting Zafara working on this edit. Is there somewhere I need to change the password for Zafara to access mysql? It's a very odd problem because I can't even get the web interface for Zafara to come up on my virtual host.

If I go to "http://DomainName" I get roundcube interface and if I go to "http://DomainName/webaccess" I get "Not Found".

Any ideas what's up?
Thanks

[cougarmaster]

J.A. Calvo,
      Shouldn't Zentyal change from mysql to postgresql or opensource versions? Since oracle will take it away anytime they want and we as users will be stuck inbetween. Oracle is really going to stamp out all opensource in their hands.

Tks in Advance
Eric

[J. A. Calvo]

J.A. Calvo,
      Shouldn't Zentyal change from mysql to postgresql or opensource versions? Since oracle will take it away anytime they want and we as users will be stuck inbetween. Oracle is really going to stamp out all opensource in their hands.

Zentyal uses PostgreSQL  since the beginning. It's Zarafa what depends on MySQL...

[thorsten]

Hi

Those both seem fine.
Did you do the rest of the steps to change the password in MySQL (steps 3-6) ? Did you receive any errors during those steps?

yes, of course

Did you use the original password when you logged into mysql to change the password? See edit above

OK - first error

J. A. Calvo
I am having real trouble getting Zafara working on this edit. Is there somewhere I need to change the password for Zafara to access mysql? It's a very odd problem because I can't even get the web interface for Zafara to come up on my virtual host.

If I go to "http://DomainName" I get roundcube interface and if I go to "http://DomainName/webaccess" I get "Not Found".

Any ideas what's up?
Thanks

Thats my problem at the moment, too - Zarafa does not move anymore. No uninstall / reinstall / reconfigure works for me so far (sorry, did not document all my trails ...)

I hope you can help, I would like to run MYSQL and Zarafa again....

THX
Thorsten

[FutureTechSys]

I had fun with /webaccess as well

Couple of pointers:

-You need port 80 and 25 open and forwarded to the INTERNAL ip of your zentyal server
-You need to configure the firewall properly to allow access to the /webaccess
-With webmail, its user@email.com to login, with Zarafa, its just the part before the "@" sign
-Run all the system and component updates

Hope something in here helps.

[nordge1]

I have found that my install, reinstall are ineffective as well. I actually reverted to the old password and changed it in Mysql as well. No joy!!!
I have found that my Zafara server never actually starts now from the log at "/var/log/zarafa/server.log".

"Mon Oct 11 12:26:16 2010: Unable to connect to database: Access denied for user 'zarafa'@'localhost' (using password: YES)"

Looks like maybe a user/password issue with Mysql. This is little outside of my expertise. Anyone know what's going on here?

[FutureTechSys]

I don't know how to do it, but someone here might.  The uninstall/reinstall seems to just be the GUI plugin portion.  You'll probably have to google for ubuntu rather than Zentyal, and maybe search for "ubuntu reinstall mysql" and manually recreate the thing.

I could be talking out of my rearend, but that's what I would try.  I love MySQL when it works, but I really hate messing with it.