After update base url unable to login on admin pannel

[Quantum IT]

Hello,

After installing the latest patch everything went ok. after installing I checked on https://www.magereport.com/ for any security vulnerabilities. There was one "Admin panel found on /admin or /downloader." So i logged in on my adminpannel went to settings and changed the admin base URL from mysite.com/ to mysite.com/magadmin/, cleared the cache and... you guess,  unable to login on my adminpannel. I looked everywhere, database, files, nothing.

How can I restore the setting so I can login on my adminpannel again?

I use magento v.1.9.2.1

Regards, Ed

[Brent W Peterson]

You may have to login via FTP and clear the cache out of your cache folder 

If you have any additional cache like REDIS or MEMCACHE you may have to remove this

[Mukesh Tiwari · Accepted solution]

Hi @Quantum IT

Try to do as mentioned by Brent.

But to change admin url always follow following approach.

Edit your local.xml fil under app/etc/local.xml under magento root directory

<admin>
  <routers>
    <adminhtml>
      <args>
        <frontName><![CDATA[admin]]></frontName>
      </args>
    </adminhtml>
  </routers>
</admin>

Replace <![CDATA[admin]]> with custom name like <![CDATA[xyz]]>

Then clear Magento caches and try to login using new url.

[Quantum IT]

Hi Brent and muk_t,

I now received a blanc login screen with the question for username and password. Not the magento loginscreen. And still I get the 404 message after entering the right name and password.

This is the change I made :

<admin>
        <routers>
            <adminhtml>
                <args>
                    <frontName><![CDATA[magadmin]]></frontName>
                </args>
            </adminhtml>
        </routers>
    </admin>

I also tried   <![CDATA[magadmin/]]>

Question:

In the adminpannel i changed the base URL... Where is this information stored? Is it in a file? Is it in the database?

In the database I changed, with no success, in `core_config_data` the two fields:

web/unsecure/base_url :     http://mysite/magento/  to   http://mysite/magento/magadmin/

web/secure/base_url     :     http://mysite/magento/  to   http://mysite/magento/magadmin/

it s getting rather frustrating...

[Mukesh Tiwari · Accepted solution]

Hi @Quantum IT

Keep back up of core_config_data table then try to do as mentioned in the following url How to change magento admin URL (Resolution if you have done above mistake:)

Thanks

[Quantum IT · Accepted solution]

sorry guys, the solutions above where all part of the solution. The fact was... I was looking in the wrong database...

The final solution was the document  How to change magento admin URL 

After the SQL query's everything was working ok.

Thanks guys!