Author Topic: MYSQL password for Zentyal 2.0  (Read 29571 times)

jsalamero

  • Zentyal Staff
  • Zen Hero
  • *****
  • Posts: 1419
  • Karma: +45/-1
    • View Profile
Re: MYSQL password for Zentyal 2.0
« Reply #15 on: October 17, 2010, 12:23:22 pm »
Purge mysql, zarafa and ebox-zarafa. Delete the /var/lib/ebox/conf/ebox-zarafa.passwd file and start again, you probably messed up something there... :)

thorsten

  • Guest
Re: MYSQL password for Zentyal 2.0
« Reply #16 on: November 03, 2010, 11:27:54 pm »
Hi,

Ok, purged those three packages via
Code: [Select]
sudo apt-get remove --purge mysql*
sudo apt-get remove --purge ebox-zarafa
sudo apt-get remove --purge zarafa
sudo apt-get autoclean
sudo apt-get autoremove

Manually deleted the password file and backups
Reinstalled Zarafa an E-Mail from Web-Front-End - Zarafa does still not work:
Changes are not stored within Zarafa, Zarafa servers seems not to be running, however, webaccess can be reached - login was not possibel, can not connect to server.

So I removed everything again. When browsing throught the directories I found some directores containing several files, e.g. .conf or similar:

/etc/mysql
/var/lib/mysql
/var/lib/zarafa
/var/lib/zarafa-webaccess
/var/lib/fetchmail
/etc/zarafa

Can I manually delete that stuff ?
I would like to purge everything before I do the next trail.
Are there any other files I might have missed in order to completely remove those packages?

Thank you
Thorsten


but: there are still files left


hadrich

  • Zen Apprentice
  • *
  • Posts: 18
  • Karma: +0/-0
    • View Profile
Re: MYSQL password for Zentyal 2.0
« Reply #17 on: November 05, 2010, 05:18:26 pm »
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

I try that password to connect to mysql but not working :
Code: [Select]
$ mysql -uroot -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

hadrich

  • Zen Apprentice
  • *
  • Posts: 18
  • Karma: +0/-0
    • View Profile
Re: MYSQL password for Zentyal 2.0
« Reply #18 on: November 08, 2010, 09:40:34 am »
Any idea please, i can't install avantfax depend of MYSQL.

hadrich

  • Zen Apprentice
  • *
  • Posts: 18
  • Karma: +0/-0
    • View Profile
Re: MYSQL password for Zentyal 2.0
« Reply #19 on: November 08, 2010, 02:49:19 pm »
My problem was resolved :
user = 'root'   ==> password = '' (empty)
user = 'zarafa'  ==> password = '</var/lib/ebox/conf/ebox-zarafa.passwd>'

Narcis Garcia

  • Zen Apprentice
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
Re: MYSQL password for Zentyal 2.0
« Reply #20 on: August 20, 2012, 12:26:40 pm »
My workaround before reinstall/reconfigure:

Code: [Select]
cat /etc/zentyal/logs.conf | grep -ie "_db"
echo $(sudo cat /var/lib/*/conf/*-mysql.passwd)
mysql -u root -p
CREATE DATABASE dbname;
GRANT ALL ON dbname.* TO dbuser@localhost IDENTIFIED BY "dbpasswd";
FLUSH PRIVILEGES;
QUIT;

immortal

  • Zen Apprentice
  • *
  • Posts: 20
  • Karma: +1/-0
    • View Profile
Re: MYSQL password for Zentyal 2.0
« Reply #21 on: November 22, 2012, 10:07:20 pm »
My problem was resolved :
user = 'root'   ==> password = '' (empty)
user = 'zarafa'  ==> password = '</var/lib/ebox/conf/ebox-zarafa.passwd>'

in what place do it? write more
« Last Edit: November 22, 2012, 10:10:47 pm by immortal »

dior

  • Zen Apprentice
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
Re: MYSQL password for Zentyal 2.0
« Reply #22 on: December 16, 2013, 11:54:12 pm »
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.

text editors add a line break after the password, therefore, better to use the echo command:

sudo echo -n '123456' > /var/lib/ebox/conf/ebox-zarafa.passwd

for details http://integrator.adior.ru/index.php/sql-mysql/259-kak-uznat-parol-polzovatelya-zentyal-bazy-dannykh-mysql