Do you see the job being created and processed when you provision an account? (Tools/Job Queue)<div><br></div><div>Does the job complete successfully?</div><div><div><br></div><div><br></div><div><br></div><div>We're doing pretty much exactly the same thing with PPPoE and Mikrotik. I ended up writing a set of perl/shell scripts called by shellcommands to handle suspension, provisioning etc.. This way, I could add fancy stuff like auto-kick suspended users after changing their group (ssh into mikrotik, find their session and kill it). </div>
<div><br></div><div>In theory, that can be replicated with sqlradius and shellcommands exports, but I've not bothered since the setup works fine as is.</div><div><br></div><div><br></div><div>Vlad</div><div><br></div>
<div><br><br><div class="gmail_quote">On Fri, Nov 9, 2012 at 8:03 AM, Tim Roberts <span dir="ltr"><<a href="mailto:trr.usa@gmail.com" target="_blank">trr.usa@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Newbie...I am fumbling my way through getting a Freeside server to export RADIUS info to our existing MYSQL/FreeRadius servers that are in production with another billing software. <div><br></div><div>I am using the VMWare Freeside downloaded 10/31/2012. I have not upgraded anything on it so its pretty much as is from the website. Our existing MYSQL servers are 5.077 on CentOS 6.</div>
<div><br></div><div>I partially used this guide to fumble through:</div><div><a href="http://www.420.am/cgi-bin/wiki.pl?action=browse&diff=2&id=How_To_Install_Freeradius_W/Mysql_On_The_Signup_Server_Using_Debian_For_The_Linux_Challenged" target="_blank">http://www.420.am/cgi-bin/wiki.pl?action=browse&diff=2&id=How_To_Install_Freeradius_W/Mysql_On_The_Signup_Server_Using_Debian_For_The_Linux_Challenged</a></div>
<div><br></div><div>Since we already have FreeRadius running and an existing MYSQL database, I ignored those items.</div><div><br></div><div>When I started my way to provision a service that has an export tied to it, I was receiving helpful error messages only a novice who has no clue would see. Those were related to my DB connect string, wrong password to the database, wrong database name, etc...Now I receive no errors when I provision so it seems it thinks its connecting out to my DB but nothing shows up in my usergroup table in my remote MYSQL server.</div>
<div><br></div><div>Ill try to describe what I have setup. Sorry for improper terms. I came from a RODOPI world and this is similar but also like learning another language to me.</div><div><br></div><div>I created a service definition - type = svc_acct</div>
<div>I left everything the defaults except domain where I selected default and selected my domain name (which I dont care whether it shows up or not in the DB, will adapt if need be)</div><div>I later came back after reading the above how to for the challenged like me and changed UID, GID to default as suggested.</div>
<div>I created an export - <span style="font-size:medium;font-family:'Times New Roman'">sqlradius-real-time export to sql-backed RADIUS</span></div><div><span><font face="Times New Roman" size="3">I finally got my datasource, username, pass, group table right so it stopped barfing on provisioning.</font></span></div>
<div><span><font face="Times New Roman" size="3">I tied this export to the svc_acct definition</font></span></div><div><span><font face="Times New Roman" size="3">I made a sample package and tied this definition to it as a primary</font></span></div>
<div><span><font face="Times New Roman" size="3">I order the service with a sample customer and then when I provision, all seems well now. Prior I was getting this after provisioning::</font></span></div>
<div><span style="font-family:Arial,Verdana,Helvetica,sans-serif;font-size:medium;background-color:rgb(248,248,248)">failed: Access denied for user 'slave_user'@'10.72.72.20' (using password: YES) at /usr/local/share/perl/5.10.1/FS/part_export/<a href="http://sqlradius.pm" target="_blank">sqlradius.pm</a> line 534.</span></div>
<div><font face="Times New Roman" size="3">I have several usernames in my radius database and I thought the slave_user had all permissions to it so I used that account. After seeing that error, I changed to the "radius" username that our current billing server and freeradius servers use. I dont see the error anymore but there still isnt anything showing up in the usergroups table when I export.</font></div>
<div><font face="Times New Roman" size="3"><br></font></div><div><font face="Times New Roman" size="3">My questions:</font></div><div><font face="Times New Roman" size="3"><br></font></div><div><font face="Times New Roman" size="3">1.) anyone willing to toss me a bone and give me some hints where to start looking from here?</font></div>
<div><font face="Times New Roman" size="3">2.) is the export realtime or does it queue up in a job somewhere I can look at? </font></div><div><br></div><div>We dont use dialup. we use Canopy modems set in pppoe which use Microtik PPPOE servers which use FreeRADIUS/MYSQL to authenticate. All users get a valid username and password, but users that are suspended get a a group called "Hold" in the database. The Microtiks give users in the group "hold" a different IP block that our gateways hijack port 80 and forward them to a "pay yer bill" website. I know I will have to address this next (or possibly now which is why I mention it). For now, I thought I would at least take a stab at getting Freeside to dump a username and password in the database and go from there.</div>
<div><br></div><div>Thanks in advance,<span><font color="#888888"><br>-- <br>Tim Roberts<br><a href="mailto:trr.usa@gmail.com" target="_blank">trr.usa@gmail.com</a><br>
</font></span></div>
<br>_______________________________________________<br>
freeside-users mailing list<br>
<a href="mailto:freeside-users@freeside.biz" target="_blank">freeside-users@freeside.biz</a><br>
<a href="http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users" target="_blank">http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users</a><br>
<br></blockquote></div><br></div>
</div>