Error when try to build roundcube

[samuelmf]

Hi guys when i try to build roundcube i get this errors

If i check if the DB is created, seems that is not created

Must i set the admin and pass for the mysql account on any config file or what?
Thanks in advance

 

[Richard G]

I found this as solution in another thread with the same error, you might want to have a look at it. Some things to check.

Troubleshooting | Directadmin Docs

DirectAdmin Knowledge Base

docs.directadmin.com

 

[samuelmf]

Hi Richard, thanks for reply i'm stuck at step one of the link you gave me, when i execute the command for reset root password

If i check the file
/usr/local/directadmin/conf/mysql.conf

I see this, the user for mysql is admin instead root, if i use it to login on phpmyadmin, it works normally

If i try to build roundcube i get same error

It is like directadmin is not using the right credentials for mysql

I appreciate the time you take to respond and I ask you to please be patient, I'm new to directadmin, I'm fed up with cpanel!

Edit:
On my local CLI I entered to mysql using this commands
systemctl stop mysqld
systemctl set-environment MYSQLD_OPTS="--skip-grant-tables"
systemctl start mysqld

An this allowed me to see mysql database and then check the current usernames on it, and i see that there is a root user

Edit 2
Seems that the roundcube DB exist on mysql,

now i have another problem

--skip-grant-tables
This happens when i executed
systemctl stop mysqld
systemctl set-environment MYSQLD_OPTS="--skip-grant-tables"
systemctl start mysqld

I already do a FLUSH PRIVILEGES; as root and as admin
But seems that it not works

 

[Richard G]

I see this, the user for mysql is admin instead root,

That is odd and not default. The mysql user is always da_admin not just admin and has the same password as root nowadays.
This also causes roundcube to get the user da_roundcube.

So something is really wrong here, unfortunately I don't know how to fix this and how restore the da_admin user.
You might best send in a ticket and refer to this thread that the da_admin user is missing/gone.

 

[samuelmf]

@Richard G Thanks again my friend, i already opened a ticket as you told me, when i get the solution i post it here for other users on future cases.