Re: Radius Database
Thank you -- View this message in context: http://freeradius.1045715.n5.nabble.com/Radius-Database-tp4375341p4381272.html Sent from the FreeRadius - User mailing list archive at Nabble.com. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Radius Database
Hi Fajar, If I understand your problem, you created a database of your own on phpmyadmin which you would like Freeradius to use? First, FR has sql module and it has the schemas defined in modules/sql For you to make interaction betweeen your web apps and FR database backend, you may have to use the schema and expand same. Also you may need to expand the sql.conf file. Regards Emmanuel --- On Fri, 5/6/11, Fajar A. Nugraha wrote: From: Fajar A. Nugraha Subject: Re: Radius Database To: "FreeRadius users mailing list" Date: Friday, May 6, 2011, 9:56 AM On Fri, May 6, 2011 at 8:40 PM, SC@ wrote: I think you didn't understand my problem... I think you didn't understand the hints everyone is trying to give you. The answers are all there, but only if you have enough basic knowledge to understand them. I have no problem with one software particularly... I have installed freeradius, i have imported its database, i have written in, i have connected my computer to a switch to test and all is right. In an other hand, I have created a website to manage a database, i have create a database with phpmyadmin to test and all is right... but i don't know how to connect both... the database of freeradius is in a file, the database of phpmy admin is in an other... when i modify my website's code to manage my radius database it is not find because it is not at the right place... that's why I want freeradius to create its database at another place... but i don't think it is a problem of knowledge with that softwares, it is way to change but where and how ? Let me repeat my answer "From your questions, you don't even know about connecting to MySQL server via TCP-IP" The solution to that, was given by Alan "This is a question for MySQL, and has nothing to do with FreeRADIUS" Have you asked there? Here's another hint: - you can have many mysql servers on the same computer, on any directroy you choose, accessible by tcp/ip, as long as they use different ip address/port combination. The usual setup is to bind to all IP address, and use different port (documentation example: http://dev.mysql.com/doc/refman/5.1/en/multiple-unix-servers.html) - an application can connect to different database servers by connecting to different ip address/port combinations (documentation example: http://www.php.net/manual/en/mysqli.connect.php) Let me repeat another part of my answer: "(4) If you still have no idea what I'm talking about, then perhaps it's better to enlist professional, paid support for implementation." -- Fajar -Inline Attachment Follows- - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Radius Database
SC@ wrote: > > I know this website but I didn't find... maybe it is in but where ? i > think i have asked kindly... > > This is a forum, when someone have difficulties we help him... > The people who occupy a forum though are generally not paid to help out and do so with their free time. Saying "I have a problem tell me what to do" without showing *any* effort at all at your end or how far your attempts have got you so far is not the way to encourage people to help you out. Maybe if you actually did the following we would be more eager: 1. clearly stated what you want to do 2. say "I have been reading x, y and z..." 3. show us the debug and configuration you are using 4. explain what you think is wrong and why you are unable to fix it So, you can ask as politely as you want but it's not going to actually get you anywhere. You have to see it from our point of view, so far it seems to us, the problem is not important enough to you to detail here its specifics or for you to actually read the documentation, so obviously is not important enough for us all to burn our *free* and *volunteered* time on? Cheers -- Alexander Clouter .sigmonster says: You will be misunderstood by everyone. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Radius Database
On Fri, May 6, 2011 at 8:40 PM, SC@ wrote: > > I think you didn't understand my problem... > I think you didn't understand the hints everyone is trying to give you. The answers are all there, but only if you have enough basic knowledge to understand them. > I have no problem with one software particularly... I have installed > freeradius, i have imported its database, i have written in, i have > connected my computer to a switch to test and all is right. > In an other hand, I have created a website to manage a database, i have > create a database with phpmyadmin to test and all is right... but i don't > know how to connect both... the database of freeradius is in a file, the > database of phpmy admin is in an other... when i modify my website's code > to > manage my radius database it is not find because it is not at the right > place... that's why I want freeradius to create its database at another > place... but i don't think it is a problem of knowledge with that > softwares, > it is way to change but where and how ? Let me repeat my answer "From your questions, you don't even know about connecting to MySQL server via TCP-IP" The solution to that, was given by Alan "This is a question for MySQL, and has nothing to do with FreeRADIUS" Have you asked there? Here's another hint: - you can have many mysql servers on the same computer, on any directroy you choose, accessible by tcp/ip, as long as they use different ip address/port combination. The usual setup is to bind to all IP address, and use different port (documentation example: http://dev.mysql.com/doc/refman/5.1/en/multiple-unix-servers.html) - an application can connect to different database servers by connecting to different ip address/port combinations (documentation example: http://www.php.net/manual/en/mysqli.connect.php) Let me repeat another part of my answer: "(4) If you still have no idea what I'm talking about, then perhaps it's better to enlist professional, paid support for implementation." -- Fajar - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: Radius Database
Try the file sql.conf in your radius root directory for setting which database to use. As for manipulating individual queries try sql/mysql/dialup.conf Kind regards Marius Pesé Mindspring Computing -Original Message- From: freeradius-users-bounces+marius=mindspring.co...@lists.freeradius.org [mailto:freeradius-users-bounces+marius=mindspring.co...@lists.freeradius.org] On Behalf Of SC@ Sent: Friday, May 06, 2011 3:40 PM To: freeradius-users@lists.freeradius.org Subject: Re: Radius Database I think you didn't understand my problem... I have no problem with one software particularly... I have installed freeradius, i have imported its database, i have written in, i have connected my computer to a switch to test and all is right. In an other hand, I have created a website to manage a database, i have create a database with phpmyadmin to test and all is right... but i don't know how to connect both... the database of freeradius is in a file, the database of phpmy admin is in an other... when i modify my website's code to manage my radius database it is not find because it is not at the right place... that's why I want freeradius to create its database at another place... but i don't think it is a problem of knowledge with that softwares, it is way to change but where and how ? I know this website (http://wiki.freeradius.org/SQL_HOWTO) because i have installed freeradius with that, but when they talk about mysql it is to import the database of freeradius (schema.sql) !!! so... someone can help me ? -- View this message in context: http://freeradius.1045715.n5.nabble.com/Radius-Database-tp4375341p4375938.html Sent from the FreeRadius - User mailing list archive at Nabble.com. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Radius Database
I think you didn't understand my problem... I have no problem with one software particularly... I have installed freeradius, i have imported its database, i have written in, i have connected my computer to a switch to test and all is right. In an other hand, I have created a website to manage a database, i have create a database with phpmyadmin to test and all is right... but i don't know how to connect both... the database of freeradius is in a file, the database of phpmy admin is in an other... when i modify my website's code to manage my radius database it is not find because it is not at the right place... that's why I want freeradius to create its database at another place... but i don't think it is a problem of knowledge with that softwares, it is way to change but where and how ? I know this website (http://wiki.freeradius.org/SQL_HOWTO) because i have installed freeradius with that, but when they talk about mysql it is to import the database of freeradius (schema.sql) !!! so... someone can help me ? -- View this message in context: http://freeradius.1045715.n5.nabble.com/Radius-Database-tp4375341p4375938.html Sent from the FreeRadius - User mailing list archive at Nabble.com. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Radius Database
On 06/05/11 14:07, SC@ wrote: I know this website but I didn't find... maybe it is in but where ? i think i have asked kindly... This is a forum, when someone have difficulties we help him... This the the *wrong* forum. You're asking for advice on writing a web interface to a MySQL database. This is *not* a FreeRADIUS question. Even if it was the right forum, your question is so vague as to be meaningless. What language are you writing your web interface in? What framework are you using? What have you tried? Why didn't it work? What error messages did you get? - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Radius Database
On Fri, May 6, 2011 at 8:07 PM, SC@ wrote: > > I know this website but I didn't find... maybe it is in but where ? i think > i have asked kindly... > This is a forum, when someone have difficulties we help him... > > You need to know some basic knowledge first before asking. For example: (1) Which software are you having problem with? Ask in the relevant forum. (2) Do you have some basic knowldege about software in (1)? From your questions, you don't even know about connecting to MySQL server via TCP-IP. Learn about that first, or ask in MySQL forum/list for best documentation about it. (3) Have you read the relevant documentation? Which part of the documentation are you having problems with? If you've read it but absolutely have no idea what it's all about, then maybe you should refer back to (1) and (2) (4) If you still have no idea what I'm talking about, then perhaps it's better to enlist professional, paid support for implementation. -- Fajar - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Radius Database
I know this website but I didn't find... maybe it is in but where ? i think i have asked kindly... This is a forum, when someone have difficulties we help him... -- View this message in context: http://freeradius.1045715.n5.nabble.com/Radius-Database-tp4375341p4375837.html Sent from the FreeRadius - User mailing list archive at Nabble.com. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Radius Database
ok ! And can I have a real help please ? or a link... if i had already find i would not be here... thank you. -- View this message in context: http://freeradius.1045715.n5.nabble.com/Radius-Database-tp4375341p4375799.html Sent from the FreeRadius - User mailing list archive at Nabble.com. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Radius Database
SC@ wrote: > But one of the possibilities is to modify a configuration file of freeradius > to tell it to write in another database, or to put its database in another > file. No ? Yes. This is documented. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Radius Database
But one of the possibilities is to modify a configuration file of freeradius to tell it to write in another database, or to put its database in another file. No ? Thank you -- View this message in context: http://freeradius.1045715.n5.nabble.com/Radius-Database-tp4375341p4375577.html Sent from the FreeRadius - User mailing list archive at Nabble.com. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Radius Database
SC@ wrote: > I can modify those tables by way of " mysql -uroot -p " in my terminal but > if I modify the code of my website to put the name of these database radius > it does not work. I think that it comes from the way which is different. > I would like to know what I have to write in the code of my pages (or maybe > in a configuration file of mysql or xampp or raddb) so that my website > manages my radius database. This is a question for MySQL, and has nothing to do with FreeRADIUS. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Radius database connectivity
Yeh, that's what I meant Sent from my iPhone On 21/06/2009, at 6:06 PM, "Alan DeKok" wrote: > Robert White wrote: >> I have a question about db connectivity with Radius. >> >> I currently have OpenRadius connecting to a mssql database using >> unixODBC/TDS. > > Well... that's not FreeRADIUS. They are two completely different > pieces of software. > >> If the database ever goes down for some reason and then comes back >> up, I have to restart Radius in order to re-establish db >> connectivity. >> >> Is this an openradius problem or is it a unixODBC issue? >> >> Does anyone know how I would be able to get connectivity to >> reestablish automatically? > > Install FreeRADIUS. It will automatically reconnect to a DB. > > Alan DeKok. > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Radius database connectivity
Robert White wrote: > I have a question about db connectivity with Radius. > > I currently have OpenRadius connecting to a mssql database using unixODBC/TDS. Well... that's not FreeRADIUS. They are two completely different pieces of software. > If the database ever goes down for some reason and then comes back up, I have > to restart Radius in order to re-establish db connectivity. > > Is this an openradius problem or is it a unixODBC issue? > > Does anyone know how I would be able to get connectivity to reestablish > automatically? Install FreeRADIUS. It will automatically reconnect to a DB. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html