Hello, I have created a website which manages a database, this one put itself automatically in " / opt / lampp / var / mysql ". But my final goal is to manage, through this website, a database FreeRadius (Add, Modify, Look for, delete data by the way of the address MAC) and radius uses databases and very specific tables that's why I have imported them and they are in " / var / lib / mysql ". 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. Thank you very much:) -- View this message in context: http://freeradius.1045715.n5.nabble.com/Radius-Database-tp4375341p4375341.ht... Sent from the FreeRadius - User mailing list archive at Nabble.com.
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.
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.ht... Sent from the FreeRadius - User mailing list archive at Nabble.com.
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.ht... Sent from the FreeRadius - User mailing list archive at Nabble.com.
Here you go http://tinyurl.com/6fg7wqk On 05/06/2011 02:49 PM, SC@ wrote:
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.ht... Sent from the FreeRadius - User mailing list archive at Nabble.com. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
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.ht... Sent from the FreeRadius - User mailing list archive at Nabble.com.
On Fri, May 6, 2011 at 8:07 PM, SC@ <sca1309@hotmail.com> 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
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.ht... Sent from the FreeRadius - User mailing list archive at Nabble.com.
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.za@lists.freeradius.org [mailto:freeradius-users-bounces+marius=mindspring.co.za@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.ht... Sent from the FreeRadius - User mailing list archive at Nabble.com. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
On Fri, May 6, 2011 at 8:40 PM, SC@ <sca1309@hotmail.com> 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
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 <list@fajar.net> wrote: From: Fajar A. Nugraha <list@fajar.net> Subject: Re: Radius Database To: "FreeRadius users mailing list" <freeradius-users@lists.freeradius.org> Date: Friday, May 6, 2011, 9:56 AM On Fri, May 6, 2011 at 8:40 PM, SC@ <sca1309@hotmail.com> 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
Thank you -- View this message in context: http://freeradius.1045715.n5.nabble.com/Radius-Database-tp4375341p4381272.ht... Sent from the FreeRadius - User mailing list archive at Nabble.com.
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?
SC@ <sca1309@hotmail.com> 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.
participants (8)
-
akinpelu emmanuel -
Alan DeKok -
Alexander Clouter -
Fajar A. Nugraha -
Marinko Tarlać -
Marius Pesé -
Phil Mayers -
SC@