“Cannot connect to the database” errors

Here are a few initial things (common mistakes) to take a look at: – Make sure that after you created your database and database user that you didn’t forget to ADD the database user to the database (at the bottom of the “Databases” section in Control Panel > MySQL Manager

How to Restore a Database on SQL Server Using .mdf, .ldf and .ndf Files

To restore a database on SQL Server using .mdf, .ldf, or .ndf files, rather than performing a restore, you will actually need to attach the database. There are two ways to do this.   Using Enterprise Manager To attach a database using Enterprise Manager, follow these instructions: Expand the registered

Shrink MsSql DB Logs

1. Open query analyser. Do not open Enterprise Manager. 2. Let the database be selected as “Master” 3. Fire the command BACKUP LOG “DATABASE_NAME” WITH TRUNCATE_ONLY BACKUP LOG “db0098” WITH TRUNCATE_ONLY This should show you a success message 4. Now change the database seclected in query analyser to “DATABASE_NAME” where

Create a backup file of a SQL Server database

Open Enterprise Manager and expand the registered SQL Server Expand Databases Right-click on the database that you want to backup, select All Tasks -> Backup Database If you would like to make a complete backup (recommended), make sure \”Database-complete\” is selected Click the Add… button In the File Name field,

Install Direct Admin on Linux systems

Step 1) Do you meet the system requirements? – Clean OS install: Redhat 7.2, 7.3, 8.0, 9.0, Fedora (any version), CentOS (any version). PS :- The setup file for Redhat also works for Fedora and CentOS (any version). – At least one external IP address (NAT/LAN-based systems will NOT work).

Install SSL for Direct Admin

Setup SSL Certificates for Direct Admin: This step is only required if you wish to use DirectAdmin through SSL. You will also have to change set SSL=1 in the directadmin.conf file. ( /home/directadmin/directadmin.conf ) # openssl req -new -x509 -keyout /usr/local/directadmin/conf/cakey.pem.tmp -out /usr/local/directadmin/conf/cacert.pem # openssl rsa -in /usr/local/directadmin/conf/cakey.pem.tmp -out /usr/local/directadmin/conf/cakey.pem

Make diskuage, bandwidth and webalizer stats update more frequently

Cron is the tool used to control the update frequency of the stats. You can easily change the frequency by modifying the cron job. Cron file for RedHat: /etc/cron.d/directadmin_cron Cron file for FreeBSD: /etc/crontab Edit the cron file and locate the line that looks like the following: 10 0 *

Forward a website to another url

There are several ways to accomplish this task, but the simplest to understand is to use php. To do this, you need to create the page that will do the forwarding. This can be any page, as long as it ends in “.php”. If you are trying to redirect a

Downgrade from apache 2 back to apache 1.3

If you need to go back to apache 1.3 after installing apache 2, you’ll need to do the following: 1) Restore the old httpd.conf file: cp -f /etc/httpd/conf/httpd.conf.1.3.backup /etc/httpd/conf/httpd.conf 2) Get DirectAdmin to use the old httpd.conf files for the users. Edit the /usr/local/directadmin/conf/directadmin.conf file and change apache_ver=2.0 to apache_ver=1.3.