Hey @eimantas, Welcome to the Local Community Forums and I’m sorry you haven’t had a reply within a timeframe that you were expecting! We’re always looking for active community members to help with these kinds of requests, so maybe that’s something you’d like to help with!
Taking a look at your Local Log, I’m seeing an error like this:
{"thread":"main","class":"HostsFileService","error":{"killed":false,"code":126,"signal":null,"cmd":"cd \"/home/dev\"; export ELECTRON_RUN_AS_NODE=\"1\"; \"/usr/bin/pkexec\" --disable-internal-agent /bin/bash -c \"echo SUDOPROMPT; export ELECTRON_RUN_AS_NODE=\\\"1\\\";/opt/Local/local %%appPath%%/main/dns/workers/updateHostsFileWorker.js babor.local www.babor.local\""},"stdout":"","stderr":"Error executing command as another user: Request dismissed\n","exitCode":126,"level":"error","message":"Could not update hosts.","timestamp":"2021-08-03T09:09:03.158Z"}
That part of the error that looks like this: Error executing command as another user: Request dismissed means that for whatever reason, your computer’s user didn’t give Local the permission it needs to update the Hosts file. Given that Adminer is running on localhost, I don’t think that this would be a problem, but it hints at the fact that maybe a firewall or other security setting is in place and preventing the browser from accessing Adminer.
I’d recommend taking a closer look at any security settings for the computer and see if that port is being actively blocked.
Hi,
I have given now the correct permissions for ‘local’ to edit the hosts file. It does edit it now, however, I am still unable to use adminer or find database anyother way.
I am attaching local-lightning.log file. local-lightning.log (218.3 KB)
Any idea how can I fix this?
That’s great that the hosts file can be edited by Local now and thanks for that Local log!
When I reviewed the Local log, I’m not seeing anything specific related to why adminer wouldn’t be working.
When I took a closer look at that screenshot of the browser, it looks like it’s trying to access port 10000 on localhost.
That doesn’t seem right to me. Usually when you click the “Adminer” button, a new PHP process is spawned and is listening on a new port that’s oftentimes higher up.
Can you try a few other troubleshooting steps?
Create a new site
Click the “Adminer” button for that site
If you still get the connection refused error in the browser, open a terminal and run this command to see if any of those php processes actually exist:
lsof -i -P -n | grep php
Can you share what the output of that command is? If you do get some output from that command, you might also try accessing that port in a browser. Here’s a screenshot to help visualize the url to use:
