login hotspot in php

RouterOS Scripting
1

Somebody can help me with this problem

I’ve my login in php and it works fine, my problem is that I pretend to check over first the username and password in my database if it exist then the users can login at mikrotik

I pretend to save the login from my users, but I need to integrate this with the login.php but I don’t know where to put it…

somebody can help me

2

I am planning to make a page in php that act like a simple user manager, where i can view,edit delete hot spot user status. i wonder why you are making a single page with 2 source of database(one from mysql and from rb).? have you tried retrieving all you hotspot users using php?

3

If you want authentication exclusively with your DB, consider using a RADIUS server instead. Ideally something like FreeRADIUS, since it uses MySQL, as does PHP.

You may need to alter your PHP app slightly to meet the DB format of FreeRADIUS, but once you do that, it should be a slam dunk from there - you can let your users authenticate through MikroTik’s login page normally, but set MikroTik to connect to FreeRADIUS, which would in turn influence your DB, which PHP can then tap into.

4

[quote=“boen_robot”]If you want authentication exclusively with your DB, consider using a RADIUS server instead. Ideally something like FreeRADIUS, since it uses MySQL, as does PHP.


Now when I try to acces with user and password in the log from rb I can see this error “user@hotmail.com (ip)login failed password is not chap encrypted”


somebody can help me

5

'cause I did my system in php in order to add, delete, modify my hostpot’s users all of these work with php and my database, and know I pretend to do my hospot login page in php, it works but I need to integrate with some actions from php on order to work with my database too

6

Are you sure you’re submitting the right form? The code above is so messy I can’t tell.

Your form is the one that needs to do the CHAP encryption, and pass the result to RouterOS afterwards. One of your forms seems to do it, yet another one doesn’t, but triggers it - a mess I tell you.

7



Im interested on FreeRadius Server but I cant find any step by step guide on how to test it in windows x86 OS. can you give some links where i can follow? thanks!

8

I tried to send my form to the same page I mean just like this

<form name="login" action="login.php" method="post" >
			<input type="hidden" name="dst" value="<?php echo $linkorig; ?>" />
			<input type="hidden" name="popup" value="true" />
						
			<table width="100" style="background-color: #ffffff">
				<tr><td align="right">login</td>
				<td><input style="width: 80px" name="username" type="text" value="<?php echo $username; ?>"/></td>
				</tr>
				<tr><td align="right">password</td>
				<td><input style="width: 80px" name="password" type="password"/></td>
				</tr>
				<tr><td> </td>
				<td><input type="submit" value="OK" /></td>
				</tr>
			</table>
		</form>

but like this I didn’t have any result, instead whit this


<form name="login" action="<?php echo $linkloginonly; ?>" method="post" onSubmit="return doLogin()" >
			<input type="hidden" name="dst" value="<?php echo $linkorig; ?>" />
			<input type="hidden" name="popup" value="true" />
						
			<table width="100" style="background-color: #ffffff">
				<tr><td align="right">login</td>
				<td><input style="width: 80px" name="username" type="text" value="<?php echo $username; ?>"/></td>
				</tr>
				<tr><td align="right">password</td>
				<td><input style="width: 80px" name="password" type="password"/></td>
				</tr>
				<tr><td> </td>
				<td><input type="submit" value="OK" /></td>
				</tr>
			</table>
		</form>

in the mk’s log I can see the mistake that I told you before


I don’t know wich es the correct way to send the variables to rb I just try :frowning:

9

But see. That’s what I meant by “a mess”.

See your doLogin() function:

            <script language="JavaScript">
           <!--
             function doLogin() {
                      document.sendin.username.value = document.login.username.value;
                        document.sendin.password.value = hexMD5("<?php echo $chapid; ?>" + document.login.password.value + "<?php echo $chapchallenge; ?>");
                      document.sendin.submit();
                        return false;
           }
           //-->
           </script>

It’s not even working with your “login” form, but it’s instead working with your “sendin” form. Where are you getting the $chapid and $chapchallenge from?

Clean it up before you try to debug it. Ideally, start over with a minimal PHP page (i.e. forget about the appearance, frameworks, and any other distractions).

10

thanks… for nothing… I did it without your help :laughing: