From: Radovan D. <rad...@em...> - 2013-09-12 19:17:59
|
Hello Vasos, This is very fresh wifiadmin installation. I have never used wifiadmin before. I have hostapd wifi service on my server and I was looking for something nice – to get some statistics about connections etc ... I think your rrdtool solution is best here around and also all another features look very fantastic and I very appreciate your hard work. I have dropped all tables and run mysql.sql script once again. Here are tables and tables content in my wifiadmin DB: mysql> show tables; +---------------------+ | Tables_in_wifiadmin | +---------------------+ | global_options | | privileges | | user | | user_options | | user_tokens | +---------------------+ 5 rows in set (0.00 sec) mysql> select * from global_options; +------------+--------+ | option | value | +------------+--------+ | db_version | 010003 | +------------+--------+ 1 row in set (0.00 sec) mysql> select * from privileges; +----------+-------------+-----------------+-----------+-----------+-------- ----+------------+-----------------+----------------+ | username | view_status | view_status_ext | view_macs | ban_users | access_ ifs | edit_users | edit_privileges | manage_routers | +----------+-------------+-----------------+-----------+-----------+-------- ----+------------+-----------------+----------------+ | admin | true | true | true | true | true | true | true | true | | guest | true | false | false | false | false | false | false | false | +----------+-------------+-----------------+-----------+-----------+-------- ----+------------+-----------------+----------------+ 2 rows in set (0.00 sec) mysql> select * from user; +----------+----------------------------------+----------------+------------ --+--------------+-------------+-------------+--------+--------+---------+-- ---------+---------+-----------+--------------+-----------------+ | username | password | email | mac | ip | owns_subnet | services | phone1 | phone2 | antenna | nodedb_id | comment | firstname | lastname | password_ string | +----------+----------------------------------+----------------+------------ --+--------------+-------------+-------------+--------+--------+---------+-- ---------+---------+-----------+--------------+-----------------+ | admin | c178d9bb85c3e412dbc478d76320c2be | root@localhost | not specific | not specific | | 24h service | | | | | | | | wifiadmin | | guest | 084e0343a0486ff05530df6c705c8bb4 | no email | not specific | not specific | | | | | | | | Guest | Guestopoulos | guest | +----------+----------------------------------+----------------+------------ --+--------------+-------------+-------------+--------+--------+---------+-- ---------+---------+-----------+--------------+-----------------+ 2 rows in set (0.00 sec) mysql> select * from user_options; Empty set (0.00 sec) mysql> select * from user_tokens; +----------+---------+-------+ | username | status | token | +----------+---------+-------+ | admin | enabled | | | guest | enabled | | +----------+---------+-------+ 2 rows in set (0.00 sec) mysql> I am not sure if it is worth to mention here because it is not related to my trouble but maybe for your further reference – create table command seem to change some options during the time and TYPE=MyISAM needs to be replaced with ENGINE=MyISAM to get script working. Here is my mysql version: [root@manitou config]# rpm -qa | grep mysql php-mysql-5.4.17-2.fc17.x86_64(http://php-mysql-5.4.17-2.fc17.x86_64/) mysql-connector-odbc-5.1.10-1.fc17.x86_64 (http://mysql-connector-odbc-5.1.10-1.fc17.x86_64/) mysql-server-5.5.32-1.fc17.x86_64(http://mysql-server-5.5.32-1.fc17.x86_64/) mysql-libs-5.5.32-1.fc17.x86_64(http://mysql-libs-5.5.32-1.fc17.x86_64/) mysql-5.5.32-1.fc17.x86_64(http://mysql-5.5.32-1.fc17.x86_64/) libdbi-dbd-mysql-0.8.3-9.fc17.x86_64 (http://libdbi-dbd-mysql-0.8.3-9.fc17.x86_64/) [root@manitou config]# I tried all browsers – Firefox, Opera, Chrome and Epiphany here with deleted history (and cookies), but unfortunately I have still the same issue. I would like to ask you very kindly if you can suggest something here, please? Your help is really appreciated. Thanks. Regards. Rad. ---------- Původní zpráva ---------- Od: vasos g <ba...@gm...> Datum: 11. 9. 2013 Předmět: Re: routers.ini " On 11/09/13 10:55, Radovan Drahovsky wrote: "Hello Vasos Thank you very much for your kindly reply and support. I have tested and doublechecked everything but unfortunately apache user can read file without any problem. I would like to ask you very kindly if you can please suggest some another stuff which is worth to doublechesk, please? I really appreciate all your support. Please see attached report from my findings, please. Find out http user: [root@manitou ~]# ps -ef | grep http root 1873 1 0 Sep09 ? 00:00:05 /usr/sbin/httpd -k start apache 2027 1873 0 Sep09 ? 00:00:00 /usr/sbin/httpd -k start apache 2028 1873 0 Sep09 ? 00:00:00 /usr/sbin/httpd -k start apache 2029 1873 0 Sep09 ? 00:00:00 /usr/sbin/httpd -k start apache 2030 1873 0 Sep09 ? 00:00:00 /usr/sbin/httpd -k start apache 2031 1873 0 Sep09 ? 00:00:00 /usr/sbin/httpd -k start apache 2032 1873 0 Sep09 ? 00:00:00 /usr/sbin/httpd -k start apache 2034 1873 0 Sep09 ? 00:00:00 /usr/sbin/httpd -k start apache 2036 1873 0 Sep09 ? 00:00:00 /usr/sbin/httpd -k start root 8836 8652 0 19:37 pts/0 00:00:00 grep --color=auto http [root@manitou ~]# Verify routers.ini permissions: [root@manitou ~]# ls -l /var/www/html/wifiadmin/config/routers.ini -rw-r--r--. 1 root apache 86 Sep 8 19:15 /var/www/html/wifiadmin/config/ routers.ini [root@manitou ~]# ls -lZ /var/www/html/wifiadmin/config/routers.ini -rw-r--r--. root apache system_u:object_r:httpd_sys_content_t:s0 /var/www/ html/wifiadmin/config/routers.ini Verify if apache user can read routers.ini file: [root@manitou ~]# sudo -u apache cat /var/www/html/wifiadmin/config/routers. ini [manitou] access_mode = local description = system_flavor = linux url = username = Version of PHP: [root@manitou wifiadmin]# rpm -qa | grep php php-mysql-5.4.17-2.fc17.x86_64(http://php-mysql-5.4.17-2.fc17.x86_64/) php-common-5.4.17-2.fc17.x86_64(http://php-common-5.4.17-2.fc17.x86_64/) php-ldap-5.4.17-2.fc17.x86_64(http://php-ldap-5.4.17-2.fc17.x86_64/) rrdtool-php-1.4.7-5.fc17.x86_64(http://rrdtool-php-1.4.7-5.fc17.x86_64/) php-cli-5.4.17-2.fc17.x86_64(http://php-cli-5.4.17-2.fc17.x86_64/) php-pdo-5.4.17-2.fc17.x86_64(http://php-pdo-5.4.17-2.fc17.x86_64/) Thank you very much. Regards. Rad. ---------- Původní zpráva ---------- Od: vasos g <ba...@gm...>(mailto:ba...@gm...) Datum: 10. 9. 2013 Předmět: Re: routers.ini "On 10/09/13 11:21, Radovan Drahovsky wrote: > Dear WiFiAdmin Developers, > > Thank you very much for your very valuable and interesting work. I > really very apreciate your great work. > > I would like to ask you very kindly if you can help me with following > error, please? > (my hostapd is working fine - I just want to add your very nice and > very usefull GUI) > > Error from webserver on webbrowser: > ROUTER SELECTION Error: Please verify the contents of > config/routers.ini. Read the README for more information. Current > router name: > > routers.ini file: > /var/www/html/wifiadmin/config/routers.ini > [manitou] > access_mode = local > description = > system_flavor = linux > url = > username = > > > Thank you very much. > Regards. > Rad Hello please verify that this file (routers.ini) is readable as the webserver user. E.g. in a root shell try # sudo -u <webserver-user> cat <full/path/to/routers.ini>" " Can you try theese (one at a time): 1) Clear you browser cookies and retry 2) Verify that that the mysql database is populated correctly (e.g. reinstall) Did you upgrade from a previous wifiadmin version ? By the way this software has not been tested with php 5.4 so be prepared. V.g. " |