SSL & MySQL access problems after reinstall

S

schabotte

Verified User
Joined
Apr 19, 2007
Messages
22
Hi,

I had a catastrophic crash on my server and am reinstalling. It went from Centos 5 to Centos 6 with the following installed:

Apache 2.4.12
DirectAdmin 1.47.0
Exim 4.80.1 Running
MySQL 5.5.31
Named 9.8.2rc1
sshd
dovecot 2.2.15
pure-ftpd 1.0.36
Php 5.5.22

So I have a few problems I haven't been able to solve after restoring some slightly out of date backups.

1) When I did the restore it worked fine restoring the files... But there was a restore parameter that I wasn't sure of so I didn't select it for restore. I don't know if it relates to any of the issues. It reads:

DNS
DNS Zones: Includes all A records and MX records

Should I select that and do a restore of that aspect?

2) I can only log into mysql via phpmyadmin or any of my scripts as da_admin. I have other databases created with users set up and I can log in as these users when I am in SSH so mysql recognizes them - just not from web access.

3) I'm having trouble with SSL. I set it up so there is a logical link between public_html and private_html but if I access any page is SSL (say https://www.thehistoricalarchive.com), it times out.

4) When I did my restore, it did not restore my SSL certificate. I'm wondering if that would relate to item 1 above? I do still have my email with my SSL certificate and can install that but I don't have the CSR that was used to get that cert. Can I just generate a CSR and use it or will it cause the cert to break? If so, I can certainly buy a new one.

But I want to get the ability to reach https: resolved first so I can make sure that works before worrying too much about the certs.

Any advice on these issues is appreciated.

Thanks,
Steven
 
If you haven't already you could install and configure CustomBuild 2.0 to manage your services, rebuilding (./build all d) or a config rewrite (./build rewrite_confs) will probably solve most of your issues.
Also, did you backup and restore using the "Admin Backup/Transfer" option in DA? Certificates and keys for domains should be backed up if you use it. You will need the certificate and matching private key for a working SSL connection, a CSR is only required when you are signing/ordering a new certificate.
 
I did the user level backup but I have the email with the SSL keys from the company that generated them.

I'll give the custombuild bit a try. Not sure it it will help as this was a brand new install on a clean server of the latest DA, etc. but it can't hurt to try.
 
Tried rebuilding everything and doing a config rewrite. Still failing on https access with a timeout - like it is not able to even reach the server when doing https.

I made a change to the options file setting redirect_host_https from no to yes and did another config rewrite and still no effect.

lrwxrwxrwx 1 thehisto thehisto 13 Mar 3 22:32 private_html -> ./public_html

is the link mapping I have set up. I'll be happy to post the contents of any config files for you to look at. Just let me know what to post.

Any other thoughts on what I should check?
 
Just a quick update that I did fix the https problem.

I ended up modifying the httpd.conf file for the domain and changed the private_html references to public_html references - thus bypassing the link method. It seems to have solved that issue.
 
You must log in or register to reply here.
Back
Top