More script questions

[Support]

Let's try to solve the geocoding problem first. I've zeroed out some coordinates on our demo page so go here, login and see if you can run the geocoder there.
http://demo.escaperadius.com/literadius/admin.php

[flip]

No, it's neither working. I tried it in Safari and Opera on an Apple computer. Maybe this is the issue. I waited now more than 60 seconds but the 4 locations remain unencoded.

[Support]

Not sure, what is going on with yoru browsers. I'm sorry you are experiencing these problems but under the circumstances there might not be much we can do to fix it. At your request I'll be happy to refund your purchase.

[flip]

I tried it now also in other browsers: Internet Explorer 5.2 for Mac, Chrome, Opera, Firefox and Safari. In all I see only the loading wheel and nothing more happens. I mean that's quite strange. Maybe it's Apple-related or any extensions such as Active-X are required which doesn't work on Apple. I don't know and I really would like to use the script because it's the only one I found which matches mostly with my requirements.

What should happen after the loading wheel appeared and how long should take the geocoding process?

[Support]

You should see a counter next to the wheel than tallies the number of locations geocoded. Usually at a rate of 1 per second. The browser isn't getting the location data from the server so something javascript related is preventing communicating with LiteRadius. If you would like to wait a bit we can take a closer look at the situation but it might take us a few days to figure it out. When I find out something I can let you know and you can make a decision at that point.

[flip]

I can wait a few days and I suggest to fix the issue before other clients run into the same problem. I don't see any counter. Let me know when you have a solution to test again.

[Support]

Please refer to this post for an update patch to resolve the geocoder issue.

http://literadius.escaperadius.com/index.php/topic,22.0.html

[flip]

Yes, now it is working on my server. Your demo setup probably needs to be updated because there it's not working:
http://demo.escaperadius.com/literadius/admin.php

What's about the bug with passwords? When I change it, I can't login. I tried it several times.

[Support]

Please follow these steps and report any situations where you are not able to proceed further.

1 - Log into the LiteRadius admin control panel and go to the menu item "Resources->Application Settings".
2 - In the LiteRadius Table Manager, Drop and then Create the lr_v32_users table. This will reset the login information.
3 - Go to the menu item "LiteRadius->Log Out" to log out of the the admin control panel.
4 - Log in with the default username: "admin" and password: "search" to verify the defaults have taken effect.
5 - Go to the menu item "Resources->Account Settings".
6 - Scroll to the Change Email Address and enter your email and then click the "Reset email" button.
7 - Log out of the admin control panel (menu item "LiteRadius->Log Out" ).
8 - On the Log in screen click the "Forgot password" link, then enter the email address you input in step 6, then click the "Reset Now" button.
9 - Once you receive your lost password request click on the link in the body of the email to complete the change password process. (or cut and past the ulr into the address bar of your browser). You should be directed to a screen that verifies your password has been reset.
10. Go to the LiteRadius log in screen and enter the default username: "admin" and the new password that was sent in the New password request email.
11. Once logged in go to the menu item "Resources->Account Settings" and go to "Change Password" and enter a new password, then click the "Reset Password" button.
12. Go to the menu item "LiteRadius->Log Out" to log out of the the admin control panel.
13. Log in with the default username: "admin" and the new password you just set.
14. Once logged in go to the menu item "Resources->Account Settings" and go to "Change Username" and enter a new username.
15. Go to the menu item "LiteRadius->Log Out" to log out of the the admin control panel.
15. Log in with the new username and the new password.

[flip]

I went through the steps but couldn't proceed after step 10 because the password is incorrect. It's the same error as before. I'm 100% sure that step 13 wouldn't work as well but I haven't tested it right now but before.

[Support]

On Safari we were not able to reproduce the password problem you are reporting.

When you were asked to login in Step 10, were you able to do so with the default password: "search"? What operating system is hosting LiteRadius?
Are you able to change your username the log out and log in with the new username and default password?

[flip]

I had the same problem also in FireFox. I am not able to login with password "search" after I changed it. I installed the script on a shared host running on Linux Apache server. Yes, I can change the user name and then login. It's just password-related. Probably the hash value calculation doesn't work 100% properly.

[flip]

I also checked the system requirements on your website and you only mentioned PHP and MySQL - both which my server supports.

[Support]

You are correct, PHP and MySQL are the only system requirements but it is not possible to predict how those resources are managed. From your responses it appears the database table may be changing the encrypted password when it is stored so I would rule out any browser dependence.

Please check and see (in phpMyAdmin) what the Collation value is for the password field (table lr_v32_users).

To check if the encrypted password is being stored correctly, go to the LiteRadius admin control panel and change the password to "testuser". It's encrypted value in the lr_v32_users table should be:

$1$sF.eDEau$klMehV06sJdpRewYe338A.

. Is this the value stored in the lr_v32_users table after the change is made?

You have also claimed that updating password field manually in lr_v32_users table does not preserve the password. To verify use a utility like phpMyAdmin update the password field with

$1$sF.eDEau$klMehV06sJdpRewYe338A. (password: "testuser")

. Update the field then review the password. Is it the same or has it been altered? You should be able to update the password field with 

$1$sF.eDEau$klMehV06sJdpRewYe338A.

then login with the "testuser" as password.

[flip]

1.) When I update the password to "testuser" in the admin backend, another value is saved in the database: $2a$05$YXdgnDix0HYNfyos/cH9WuF80qf

2.) When I save your value ($1$sF.eDEau$klMehV06sJdpRewYe338A.), then I can use "testuser" as password to login.

3.) I didn't say that I can't update the password value in the database. I only meant that I can't use an unencoded, plain password in the field and I don't know how the password is encoded.