Several issues after installing DirectAdmin

[kikloo]

Hi,

While DA seems to be working fine, but there are somethings that I'm unable to rectify:

1. Mysql / Mariadb issue i.e I'm presuming its running in strict mode which is causing some issue with sql queries, as soon as I run following commands the issue goes away but after server reboot it comes back.

---
set session sql_mode='';
set global sql_mode='';
---

2. I've installed CloudLinux and when trying to access it in DA admin I get the following:

---
Restricted area
Your admin user doesn't appear to belong to clsudoer group. Please run the following script in order to resolve the issue:
$ /usr/share/l.v.e-manager/install-lvemanager-plugin.py -u
(Run it as the 'root' user on the server console over SSH)
---

I've tried running the command it seems to complete successfully but still the above error comes up.

3. Unable to connect to email account to send email using phpmailer class. Keeps on giving 'unable to connect" error no matter what port I try to connect i.e 465, 587, 25 etc.

4. When I try to run mysql command to get ">>" command prompt I get the following:

---
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
---

Any help to resolve above errors is appreciated.

Thank you.

Regards.

 

[Richard G]

As for 1.)
Can you check your /etc/my.cnf (or in other OS /etc/mysql/my.cnf) file and set there under [mysqld] this setting:
sql_mode=
just like this, don't put anything behind it, and then restart mysql and check again if strict mode is in effect.

2.) I don't know, don't use cloudlinux.

3.) If you can telnet to those ports, then service is running and I don't know, I don't do phpmailer.

4.)

Access denied for user 'root'@'localhost' (using password: NO)

It says "using password: NO". Seems to me yo either need to use the password or create a file called /root/.my.cnf containing the correct credentials like this for example:

[client]
user=da_admin
password=thedaadminpasshere
socket=/var/lib/mysql/mysql.sock

maybe you can leave out the last line.

Just to be sure for others to help you, specify your Distro and version, same for mysql or mariadb.