| Matteo Scandolo | 48d3d2d | 2017-08-08 13:05:27 -0700 | [diff] [blame^] | 1 | |
| 2 | # Copyright 2017-present Open Networking Foundation |
| 3 | # |
| 4 | # Licensed under the Apache License, Version 2.0 (the "License"); |
| 5 | # you may not use this file except in compliance with the License. |
| 6 | # You may obtain a copy of the License at |
| 7 | # |
| 8 | # http://www.apache.org/licenses/LICENSE-2.0 |
| 9 | # |
| 10 | # Unless required by applicable law or agreed to in writing, software |
| 11 | # distributed under the License is distributed on an "AS IS" BASIS, |
| 12 | # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. |
| 13 | # See the License for the specific language governing permissions and |
| 14 | # limitations under the License. |
| 15 | |
| 16 | |
| Chetan Gaonker | 7f4bf74 | 2016-05-04 15:56:08 -0700 | [diff] [blame] | 17 | # -*- text -*- |
| 18 | ## |
| 19 | ## admin.sql -- MySQL commands for creating the RADIUS user. |
| 20 | ## |
| 21 | ## WARNING: You should change 'localhost' and 'radpass' |
| 22 | ## to something else. Also update raddb/sql.conf |
| 23 | ## with the new RADIUS password. |
| 24 | ## |
| 25 | ## $Id: 5c91384c0991ea9614b7c798a1ab4c89ca227115 $ |
| 26 | |
| 27 | # |
| 28 | # Create default administrator for RADIUS |
| 29 | # |
| 30 | CREATE USER 'radius'@'localhost'; |
| 31 | SET PASSWORD FOR 'radius'@'localhost' = PASSWORD('radpass'); |
| 32 | |
| 33 | # The server can read any table in SQL |
| 34 | GRANT ALL ON radius.* TO 'radius'@'localhost' identified by 'radpass'; |
| 35 | GRANT ALL ON radius.* TO 'radius'@'radsrvr' identified by 'radpass'; |
| 36 | |
| 37 | # The server can write to the accounting and post-auth logging table. |
| 38 | # |
| 39 | # i.e. |
| 40 | #GRANT ALL on radius.radacct TO 'radius'@'localhost' identified by 'radpass'; |
| 41 | #GRANT ALL on radius.radacct TO 'radius'@'radsrvr' identified by 'radpass'; |