Changeset 523
- Timestamp:
- 03/31/05 21:05:33 (8 years ago)
- Location:
- trunk/wifidog-auth
- Files:
-
- 13 modified
-
ChangeLog (modified) (1 diff)
-
INSTALL (modified) (1 diff)
-
sql/dump_initial_data_postgres.sh (modified) (2 diffs)
-
sql/sync_sql_for_cvs.sh (modified) (1 diff)
-
sql/wifidog-postgres-initial-data.sql (modified) (3 diffs)
-
sql/wifidog-postgres-schema.sql (modified) (15 diffs)
-
wifidog/classes/Authenticator.php (modified) (2 diffs)
-
wifidog/classes/AuthenticatorRadius.php (modified) (1 diff)
-
wifidog/classes/User.php (modified) (2 diffs)
-
wifidog/config.php (modified) (3 diffs)
-
wifidog/include/schema_validate.php (modified) (2 diffs)
-
wifidog/templates/login.html (modified) (2 diffs)
-
wifidog/templates/login_virtual.html (modified) (2 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/wifidog-auth/ChangeLog
r522 r523 1 2005-03-31 Benoit Gr�goire <bock@step.polymtl.ca> 2 * Remove spaces after php blocks in various files. 3 * Temporarely fix single authentication source not present bug in login smarty template. All other places where we select the network will be fixed tommorow. 4 * Fix initial schema errors. 5 1 6 2005-03-31 Benoit Gr�goire <bock@step.polymtl.ca> 2 7 * More RADIUS install documentation. -
trunk/wifidog-auth/INSTALL
r522 r523 64 64 automatically: 65 65 66 pear install Auth67 66 pear install radius ( PECL module compilation) 68 67 pear install Auth_RADIUS -
trunk/wifidog-auth/sql/dump_initial_data_postgres.sh
r514 r523 4 4 5 5 echo "--- The default admin user, delete or change password as soon as possible. The password is admin " 6 echo "INSERT INTO users (user_id, username, pass, email, account_status ) VALUES ('admin_original_user_delete_me', 'admin', 'ISMvKXpXpadDiUoOSoAfww==', 'test_user_please@delete.me', 1, 'df16cc4b1d0975e267f3425eaac31950');";6 echo "INSERT INTO users (user_id, username, pass, email, account_status, validation_token) VALUES ('admin_original_user_delete_me', 'admin', 'ISMvKXpXpadDiUoOSoAfww==', 'test_user_please@delete.me', 1, 'df16cc4b1d0975e267f3425eaac31950');"; 7 7 8 8 echo "INSERT INTO administrators (user_id) VALUES ('admin_original_user_delete_me');" … … 10 10 pg_dump -a -D --username=wifidog -t token_status 11 11 12 pg_dump -a -D --username=wifidog -t venue_types 13 pg_dump -a -D --username=wifidog -t node_deployment_status 12 14 echo "INSERT INTO nodes (node_id, name, rss_url) VALUES ('default', 'Unknown node', NULL);" 13 15 14 pg_dump -a -D --username=wifidog -t node_deployment_status15 pg_dump -a -D --username=wifidog -t venue_types16 16 pg_dump -a -D --username=wifidog -t schema_info 17 17 -
trunk/wifidog-auth/sql/sync_sql_for_cvs.sh
r223 r523 1 1 #!/bin/sh 2 echo "Note: This script must be run as the wifidog local user"2 echo "Note: When prompted for a password, enter the wifidog database user's password" 3 3 sh dump_initial_data_postgres.sh > wifidog-postgres-initial-data.sql 4 4 chmod a+r wifidog-postgres-initial-data.sql -
trunk/wifidog-auth/sql/wifidog-postgres-initial-data.sql
r514 r523 2 2 BEGIN; 3 3 --- The default admin user, delete or change password as soon as possible. The password is admin 4 INSERT INTO users (user_id, username, pass, email, account_status ) VALUES ('admin_original_user_delete_me', 'admin', 'ISMvKXpXpadDiUoOSoAfww==', 'test_user_please@delete.me', 1, 'df16cc4b1d0975e267f3425eaac31950');4 INSERT INTO users (user_id, username, pass, email, account_status, validation_token) VALUES ('admin_original_user_delete_me', 'admin', 'ISMvKXpXpadDiUoOSoAfww==', 'test_user_please@delete.me', 1, 'df16cc4b1d0975e267f3425eaac31950'); 5 5 INSERT INTO administrators (user_id) VALUES ('admin_original_user_delete_me'); 6 6 -- … … 23 23 INSERT INTO token_status (token_status) VALUES ('INUSE'); 24 24 INSERT INTO token_status (token_status) VALUES ('USED'); 25 26 27 INSERT INTO nodes (node_id, name, rss_url) VALUES ('default', 'Unknown node', NULL);28 --29 -- PostgreSQL database dump30 --31 32 SET client_encoding = 'LATIN1';33 SET check_function_bodies = false;34 35 SET SESSION AUTHORIZATION 'wifidog';36 37 SET search_path = public, pg_catalog;38 39 --40 -- Data for TOC entry 2 (OID 115973)41 -- Name: node_deployment_status; Type: TABLE DATA; Schema: public; Owner: wifidog42 --43 44 INSERT INTO node_deployment_status (node_deployment_status) VALUES ('DEPLOYED');45 INSERT INTO node_deployment_status (node_deployment_status) VALUES ('IN_PLANNING');46 INSERT INTO node_deployment_status (node_deployment_status) VALUES ('IN_TESTING');47 INSERT INTO node_deployment_status (node_deployment_status) VALUES ('NON_WIFIDOG_NODE');48 INSERT INTO node_deployment_status (node_deployment_status) VALUES ('PERMANENTLY_CLOSED');49 INSERT INTO node_deployment_status (node_deployment_status) VALUES ('TEMPORARILY_CLOSED');50 25 51 26 … … 114 89 115 90 -- 91 -- Data for TOC entry 2 (OID 115973) 92 -- Name: node_deployment_status; Type: TABLE DATA; Schema: public; Owner: wifidog 93 -- 94 95 INSERT INTO node_deployment_status (node_deployment_status) VALUES ('DEPLOYED'); 96 INSERT INTO node_deployment_status (node_deployment_status) VALUES ('IN_PLANNING'); 97 INSERT INTO node_deployment_status (node_deployment_status) VALUES ('IN_TESTING'); 98 INSERT INTO node_deployment_status (node_deployment_status) VALUES ('NON_WIFIDOG_NODE'); 99 INSERT INTO node_deployment_status (node_deployment_status) VALUES ('PERMANENTLY_CLOSED'); 100 INSERT INTO node_deployment_status (node_deployment_status) VALUES ('TEMPORARILY_CLOSED'); 101 102 103 INSERT INTO nodes (node_id, name, rss_url) VALUES ('default', 'Unknown node', NULL); 104 -- 105 -- PostgreSQL database dump 106 -- 107 108 SET client_encoding = 'LATIN1'; 109 SET check_function_bodies = false; 110 111 SET SESSION AUTHORIZATION 'wifidog'; 112 113 SET search_path = public, pg_catalog; 114 115 -- 116 116 -- Data for TOC entry 2 (OID 115985) 117 117 -- Name: schema_info; Type: TABLE DATA; Schema: public; Owner: wifidog 118 118 -- 119 119 120 INSERT INTO schema_info (tag, value) VALUES ('schema_version', ' 2');120 INSERT INTO schema_info (tag, value) VALUES ('schema_version', '3'); 121 121 122 122 -
trunk/wifidog-auth/sql/wifidog-postgres-schema.sql
r514 r523 102 102 username text, 103 103 account_origin text, 104 CONSTRAINT check_email_not_empty CHECK (((email)::text <> ''::text)),105 104 CONSTRAINT check_user_not_empty CHECK (((user_id)::text <> ''::text)) 106 105 ); … … 177 176 178 177 -- 179 -- TOC entry 2 2(OID 133192)178 -- TOC entry 21 (OID 133192) 180 179 -- Name: idx_unique_username_and_account_origin; Type: INDEX; Schema: public; Owner: wifidog 181 180 -- 182 181 183 182 CREATE UNIQUE INDEX idx_unique_username_and_account_origin ON users USING btree (username, account_origin); 184 185 186 --187 -- TOC entry 21 (OID 140367)188 -- Name: idx_unique_email_and_account_origin; Type: INDEX; Schema: public; Owner: wifidog189 --190 191 CREATE UNIQUE INDEX idx_unique_email_and_account_origin ON users USING btree (email, account_origin);192 183 193 184 … … 229 220 230 221 -- 231 -- TOC entry 2 3(OID 133114)222 -- TOC entry 22 (OID 133114) 232 223 -- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog 233 224 -- … … 238 229 239 230 -- 240 -- TOC entry 2 4(OID 133116)231 -- TOC entry 23 (OID 133116) 241 232 -- Name: node_owners_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog 242 233 -- … … 247 238 248 239 -- 249 -- TOC entry 2 5(OID 133118)240 -- TOC entry 24 (OID 133118) 250 241 -- Name: node_deployment_status_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog 251 242 -- … … 256 247 257 248 -- 258 -- TOC entry 2 6(OID 133120)249 -- TOC entry 25 (OID 133120) 259 250 -- Name: venue_types_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog 260 251 -- … … 265 256 266 257 -- 267 -- TOC entry 2 7(OID 133122)258 -- TOC entry 26 (OID 133122) 268 259 -- Name: schema_info_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog 269 260 -- … … 274 265 275 266 -- 276 -- TOC entry 2 9(OID 133124)267 -- TOC entry 28 (OID 133124) 277 268 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 278 269 -- … … 283 274 284 275 -- 285 -- TOC entry 2 8(OID 133128)276 -- TOC entry 27 (OID 133128) 286 277 -- Name: administrators_ibfk_1; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 287 278 -- … … 292 283 293 284 -- 294 -- TOC entry 30(OID 133132)285 -- TOC entry 29 (OID 133132) 295 286 -- Name: fk_users; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 296 287 -- … … 301 292 302 293 -- 303 -- TOC entry 3 1(OID 133136)294 -- TOC entry 30 (OID 133136) 304 295 -- Name: fk_nodes; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 305 296 -- … … 310 301 311 302 -- 312 -- TOC entry 3 4(OID 133140)303 -- TOC entry 33 (OID 133140) 313 304 -- Name: fk_users; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 314 305 -- … … 319 310 320 311 -- 321 -- TOC entry 3 5(OID 133144)312 -- TOC entry 34 (OID 133144) 322 313 -- Name: fk_nodes; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 323 314 -- … … 328 319 329 320 -- 330 -- TOC entry 3 2(OID 133148)321 -- TOC entry 31 (OID 133148) 331 322 -- Name: fk_node_deployment_status; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 332 323 -- … … 337 328 338 329 -- 339 -- TOC entry 3 3(OID 133152)330 -- TOC entry 32 (OID 133152) 340 331 -- Name: fk_venue_types; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 341 332 -- -
trunk/wifidog-auth/wifidog/classes/Authenticator.php
r517 r523 1 1 <?php 2 3 4 2 /********************************************************************\ 5 3 * This program is free software; you can redistribute it and/or * … … 89 87 } // End class 90 88 ?> 91 92 -
trunk/wifidog-auth/wifidog/classes/AuthenticatorRadius.php
r517 r523 1 1 <?php 2 3 4 2 /********************************************************************\ 5 3 * This program is free software; you can redistribute it and/or * -
trunk/wifidog-auth/wifidog/classes/User.php
r521 r523 1 1 <?php 2 3 4 2 /********************************************************************\ 5 3 * This program is free software; you can redistribute it and/or * … … 454 452 } // End class 455 453 ?> 456 457 458 459 -
trunk/wifidog-auth/wifidog/config.php
r522 r523 7 7 * 8 8 * $Log$ 9 * Revision 1.27 2005/04/01 02:05:32 benoitg 10 * 2005-03-31 Benoit Gr�goire <bock@step.polymtl.ca> 11 * * Remove spaces after php blocks in various files. 12 * * Temporarely fix single authentication source not present bug in login smarty template. All other places where we select the network will be fixed tommorow. 13 * * Fix initial schema errors. 14 * 9 15 * Revision 1.26 2005/03/31 18:35:23 benoitg 10 16 * 2005-03-31 Benoit Gr�goire <bock@step.polymtl.ca> … … 188 194 // RADIUS authenticators ( see AuthenticatorRadius constuctor doc for details ) 189 195 190 require_once BASEPATH.'classes/AuthenticatorRadius.php';196 /*require_once BASEPATH.'classes/AuthenticatorRadius.php'; 191 197 192 198 define('IDRC_ACCOUNT_ORIGIN', 'IDRC_RADIUS_USER'); … … 194 200 'name'=>"IDRC RADIUS Server test", 195 201 'authenticator'=>new AuthenticatorRadius(IDRC_ACCOUNT_ORIGIN, "192.168.0.11", 1812, 1813, "secret_key", "CHAP_MD5")); 196 202 */ 197 203 /*These are the file names of the different templates that can be put in the CONTENT_PATH/(node_id)/ folders */ 198 204 define('STYLESHEET_NAME', 'stylesheet.css'); -
trunk/wifidog-auth/wifidog/include/schema_validate.php
r522 r523 1 1 <?php 2 3 2 /********************************************************************\ 4 3 * This program is free software; you can redistribute it and/or * … … 109 108 } 110 109 ?> 111 -
trunk/wifidog-auth/wifidog/templates/login.html
r517 r523 11 11 <input type="hidden" name="gw_id" value="{$gw_id}"> 12 12 <table> 13 {if count($auth_sources) > 1} 13 14 14 <tr> 15 15 <td>{"Network"|_}:</td> … … 26 26 </td> 27 27 </tr> 28 {/if} 28 29 29 <tr> 30 30 <td>{"Username (or email)"|_}:</td> -
trunk/wifidog-auth/wifidog/templates/login_virtual.html
r517 r523 9 9 <form name="login_form" method="post"> 10 10 <table> 11 {if count($auth_sources) > 1} 11 12 12 <tr> 13 13 <td>{"Network"|_}:</td> … … 24 24 </td> 25 25 </tr> 26 {/if} 26 27 27 <tr> 28 28 <td>{"Username (or email)"|_}:</td>
