To install DBI and DBD:mysql from source, run the following:
tar xvzf DBI-1.608.tar.gz
tar xvzf DBD-mysql-3.0002.tar.gz
You can also install it using the cpan mirrors as follows,
perl -MCPAN -e 'install Bundle::DBD::mysql'
Directadmin came with php ad CLI options. So the php scripts run as apache user. You can use suphp , which help the php run as local user. Dircetadmin support suphp without much issues. Please use the following steps to enable suphp in directadmin.
./build set php5_cgi yes
./build set php5_cli no
./build all d
Now you installed suphp in the server
You may need to rewrite the webapps php scripts to reset the ownerships if you get internal server errors with them, eg:
Please make sure to change all 777 folders to 755 permission and change all 777 php scripts to 644 permission , otherwise you will get 500 internal server error in your wesbites.
When connecting to the MySQL screens in DirectAdmin, if this error appears, that would indicated that the “da_admin” user has not been setup correctly. Also you are reset the mysql root password too. To resolve this do the following.
mysqld_safe --skip-grant-tables &
That should start up mysql without the need for a root password. Once in, type
update user set Password=PASSWORD('newpass') where user='root';
GRANT ALL PRIVILEGES ON *.* TO 'da_admin'@'localhost' IDENTIFIED BY 'newpass' WITH GRANT OPTION;
Now we need to make sure it’s setup correctly for DA to use. Edit /usr/local/directadmin/conf/mysql.conf and set
Now edit the file /root/.my.cnf and add the following lines