Roundcube installation problem

Discussion in 'Installation/Configuration' started by LinuxPete, Aug 12, 2019.

  1. LinuxPete

    LinuxPete Member HowtoForge Supporter

    I'm installing the perfect server Debian 10, w/apache, roundcube webmail, etc.
    When I got to the optional step #19 Installing roundcube, the echo command did not work
    echo "CREATE DATABASE roundcube;" | mysql --defaults-file=/etc/mysql/debian.cnf
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
    I checked the debian.cnf file, and the password for root looked good, I can use it from the command line (mysql -u root -p) with no problems, there were no errors in the roundcube directory
    so I wound up creating the database manually and connecting to it with use database roundcube;
    However when I tried the install, I got a similar error:
    .....
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES).
    unable to connect to mysql server.
    error encountered creating user:
    my etc/mysql/debian.cnf looks good but for some reason it won't see or use the root password.
    Zipline5 is not the real password.
    # Automatically generated for Debian scripts. DO NOT TOUCH!
    [client]
    host = localhost
    user = root
    password = Zipline5
    socket = /var/run/mysqld/mysqld.sock
    [mysql_upgrade]
    host = localhost
    user = root
    password = Zipline5
    socket = /var/run/mysqld/mysqld.sock
    basedir = /usr

    Any help would be appreciated.
    Thanks
    Ray
     
  2. Jesse Norell

    Jesse Norell Well-Known Member

    Seems like there was a "small" bug in a debian package so that /etc/mysql/debian.cnf didn't work, or similar. @Croydon had submitted a patch to address it. I've not followed the debian 10 tutorial yet, but check the comments for that, if the tutorial itself doesn't mention it, or failing that, search the forum here for the issue (in the past 3 weeks or so?).
     
  3. Jesse Norell

    Jesse Norell Well-Known Member

  4. LinuxPete

    LinuxPete Member HowtoForge Supporter

    Hey thanks Jesse for the link.
    I tried creating the patch and but still have the same error when I try to do an "echo" to create the database or for the "apt-get install..."
    I had to do a apt-get purge to get the dialog to come back and ask if I wanted to create a database. But it still failed as before.
    I also tried creating the DB from the mysql command line and then checking to see if it is there before I did an install. Nope. Got a failure when I tried the install.
    BTW. I did check the mysql file to make sure the patch was there.
     
  5. LinuxPete

    LinuxPete Member HowtoForge Supporter

    Question. Can I continue with the ISPCONFIG3 to be able to create the virtual hosts, and install webmail/squirrel manually?
     
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    Sure, ispconfig does not rely on squirrelmail.
     
  7. LinuxPete

    LinuxPete Member HowtoForge Supporter

    thanks, will finish install.
     

Share This Page