There appears to be a problem with the saved database information

RogierMaas

RogierMaas

Verified User
Joined
Feb 15, 2014
Messages
44
Good morning all,

For some time now, my admin-user has had three websites running. Since a month or so, those websites are not showing up in the vhost configuration files anymore and when loggin into DA, under the Installatron > All Applications > Wordpress [affected site], I see "Note: There appears to be a problem with the saved database information. Use the above "Advanced" tab to enter correct information.".
I've logged into MySQL using da_admin, checked all databases and they're still there. Under the Advanced tab, all values appear to be ok, including user, pass and prefix.

Any hints to solve this?

Kind Regards,
 
I had an issue with softaculous because 127.0.0.1 was blacklisted by DA. You might check that.
 
That’s what I thought, but all other websites (30+) do work. Also, the three sites aren’t being included in the virtualhosts config files. When I go to the website, it simply says: “is functioning normally” (without the “Apache” in front).
 
floyd said:
I had an issue with softaculous because 127.0.0.1 was blacklisted by DA.
Click to expand...
Wonder how that can happen. However I always tick the option in DA to never blacklist 127.0.0.1 to prevent odd issues.

What happens if you try this?
Code: 
cd /usr/local/directadmin/custombuild
./build update
./build rewrite_confs
are they rebuild into the virtual host?

It's a bit odd they disappeared from there suddenly. If this command does not work, you can try adding them to the vhost files like others. Then do the rebuild command again and see if they dissapear again.
 
# ./build update
directadmin stable v1.659 7dbdf75fe91637e8c0e568f339e18129bf8885e7 is already latest

# ./build rewrite_confs
Checking to ensure /etc/httpd/conf/ssl.crt/server.ca is set.
2024/03/18 15:30:11 info executing task task=action=rewrite&value=ips
Using 1.2.3.4 for your server IP
PHP has been secured.
Restarting php-fpm74.
Restarting php-fpm56.
2024/03/18 15:30:18 info executing task task=action=rewrite&value=httpd
Restarting apache.
2024/03/18 15:30:29 info executing task task=action=directadmin&value=reload

No changes. The other sites still function and the three sites on the user side of user Admin aren't being included in the vhosts...
 
RogierMaas said:
and the three sites on the user side of user Admin aren't being included in the vhosts...
Click to expand...
Question is how they could dissapear. What if you add them manually, by example of how the others are done, do they start working again?
And if yes, if you do that ./build rewrite_confs command again afterwards, do they keep in or dissapear again.

Also to be sure, check the /etc/virtual/domains file and /etc/virtual/domainowners file for presence of the domains.
 
Richard G said:
Question is how they could dissapear. What if you add them manually, by example of how the others are done, do they start working again?
And if yes, if you do that ./build rewrite_confs command again afterwards, do they keep in or dissapear again.

Also to be sure, check the /etc/virtual/domains file and /etc/virtual/domainowners file for presence of the domains.
Click to expand...
I have no idea how they disappeared. It's only for user admin. Admin is also the only user that can login (users can login but after login, they're presented with a page that times out).
The domain of admin is our primary domain, the three sites are all under this domain and are more or less accessible using domainname.tld/hostname (since they reside in public_html) but of course the paths are incorrect (WP sites, so they rely on correct path- and host names).
I'm not sure what you mean by 'manually adding them'. You mean in a httpd.conf file?
./build rewrite_conf completes, but the websites aren't added to the httpd config files...
 
RogierMaas said:
You mean in a httpd.conf file?
Click to expand...
You mean the httpd.conf in the /usr/local/directadmin/data/users/username/ directory? Is that empty then?
You said the domains were not included in the vhost. Which vhost did you mean then?

I thought it was only the virtualhost file, so you could add them in the /etc/httpd/conf/extra/directadmin-vhost.conf file.
But if the users httpd.conf file is empty or non existing in that directory, there are really more issues going on.

You could try and copy them over from other users and then change the content, but I don't know if that is going to help.

But it seems there are more odd things happening if users also get a white timeout page if they want to login.
Also normally the rewrite_conf command does rebuild all users httpd.conf files.

I don't know of any oterh rebuilding command. Maybe rebuild all but I don't think that this also rebuilds all configs.

If you're not on a legacy license you might want to consider sending in a ticket because some other odd things are going on.
 
Richard G said:
You mean the httpd.conf in the /usr/local/directadmin/data/users/username/ directory? Is that empty then?
Click to expand...
[…]
Richard G said:
But if the users httpd.conf file is empty or non existing in that directory, there are really more issues going on.
Click to expand...
Yes, normally if you add a website, it gets added there using one of the templates. Not for user admin: there are no sites. At least not in the httpd.conf files. Installatron has them listed and everything seems to check out, but rewrite_conf deletes them from the config files and the error message remains.
Richard G said:
You could try and copy them over from other users and then change the content, but I don't know if that is going to help.

But it seems there are more odd things happening if users also get a white timeout page if they want to login.
Click to expand...
Yes, somehow this seems connected. I don’t know how or why though..
Richard G said:
I don't know of any oterh rebuilding command. Maybe rebuild all but I don't think that this also rebuilds all configs.
Click to expand...
What if there’s something wrong and rebuild all bricks my server..?
Richard G said:
If you're not on a legacy license you might want to consider sending in a ticket because some other odd things are going on.
Click to expand...
I am on a legacy license.. Have been for years. This happened out of the blue while I was moving. Now that I have a decent workplace again I thought I’d address the issues.
So DA removed the sites from de DNS as well. It’s like they don’t exist as far as DA is concerned.
I think I’ll try restoring a backup for one of the sites and see what happens.

But strange things are going on indeed. Why can’t users see the dashboard after login? Admin seems unaffected. When logging in ad admin, I can then login as any user, although I’ve noticed there are no widgets installed. I also can’t add widgets. Something is wrong. ?
 
RogierMaas said:
What if there’s something wrong and rebuild all bricks my server..?
Click to expand...
A rebuild all just rebuilds all things without deleting them, so Exim. Apache and so on.
However, it's ofcourse up to you if you want to try this or not.

RogierMaas said:
This happened out of the blue while I was moving.
Click to expand...
Oh you didn't say that before. If you still have the backups, I would suggest to delete the domain from DA and then import them again.
Or restore the whole admin backup is again is also an option. Be aware that your admin admin gets overwritten (at least it always did) and the old admin passwords are to be used again.

Just out of curiousity, did you wait changing and restoring things and using DA until after you get the message notification that all background installations were finished?
Because if not, that would explain everything. It looks like a rebuild all would be best thing here, but again, it's your decision and I presume you still have all backups.
 
Yes, I was moving and was working off of a laptop. Now that I have my desktop, I can SSH into the server and have multiple displays to work with.
TBH, I think there might be something off in another area. I can login only as admin; users can fill out their login credentials but their (Evo) page isn't loading and eventually times out. I will try to do a build all but I doubt that will fix anything. I can't find anything wrong in the logfiles..
 
As Richard said did you check the /etc/virtual/domains file and /etc/virtual/domainowners file?
 
floyd said:
As Richard said did you check the /etc/virtual/domains file and /etc/virtual/domainowners file?
Click to expand...
Yes; every domain is there along with every user. Our primary domain is listed last and has admin as owner.
I think I'll try to just rebuild all to see what happens. Right now, not even admin can login to DA. I've restarted Apache (acting as proxy to localhost:2222) and directadmin yet no results. I have also opened port 2222 to my IP but logging in using port 2222 gives me the same results. So I've ruled out Apache I think.
 
SOLVED: I have experimented with the three sites, two of which aren't important. I checked all files, config files, databases, SSL certificates: everything seemed ok. Then I thought: the three sites ran under site1.mydomain.tld, site2.mydomain.tld and site3.mydomain.tld but weren't present in the zonefile for that domain for some reason, so I manually added them to no avail.
I then tried recreating those subdomains using DA. I can sometimes login, so when I could, I switched to User Mode and created subdomains. And that was it: DirectAdmin/Installatron had no knowledge of the 'subdomains'. Once I created the subdomains, all the problematic sites came back to life almost immediately. I had to delete my manually added CNAME-entries because it returned a conflict, but this was it regarding the non-functioning websites for user admin.

The next problem is users not being able to login using their panel.theirdomain.tld. I've made a separate thread for that but nobody seems to know the solution. I'll post some logfiles there as well: DA is being proxied through Apache but the referrer seems to be off:

/var/log/directadmin/error.log:
2024:03:20-13:44:48: Referer host does not match panel.mydomain.tld != panel.mydomain.tld:2222
2024:03:20-13:44:49: Referer host does not match panel.mydomain.tld != installatron.com
2024:03:20-13:44:49: Referer check failed for 12.34.56.78

The second I get: mydomain.tld is not installatron.com...

Apache config:

<VirtualHost |IP|:|PORT_443| |MULTI_IP|>
ServerName panel.|DOMAIN|
ServerAdmin |ADMIN|

SSLEngine on
SSLCertificateFile |CERT|
SSLCertificateKeyFile |KEY|
|CAROOT|

#ProxyRequests off
SSLProxyEngine on
ProxyPass / https://|DOMAIN|:2222/
ProxyPassReverse / https://|DOMAIN|:2222/
ProxyPreserveHost On

CustomLog /var/log/httpd/domains/|DOMAIN|.bytes bytes
CustomLog /var/log/httpd/domains/|DOMAIN|.log combined
ErrorLog /var/log/httpd/domains/|DOMAIN|.error.log
 
RogierMaas said:
I had to delete my manually added CNAME-entries because it returned a conflict, but this was it regarding the non-functioning websites for user admin.
Click to expand...
Yep it's best to keep CNAME usage to a minimum imho. But glad to see at last you found the issue.

For the login to panel.mydomain.tld you might best up your topic by replying in there, that keeps things a bit more neat.
And also better to find for others encountering a similar problem.
 
Richard G said:
Yep it's best to keep CNAME usage to a minimum imho. But glad to see at last you found the issue.

For the login to panel.mydomain.tld you might best up your topic by replying in there, that keeps things a bit more neat.
And also better to find for others encountering a similar problem.
Click to expand...
Yup, did that. I hope I can find a solution for that pesky problem. Thanks for your help!
 
You must log in or register to reply here.
Back
Top