znerox / wifimap Goto Github PK

Hello, I am running the site from a Docker container as the guide recommended, I did already create the database, but when I am getting errors when I am trying to upload a network or a location file (I made the export from the Android app).

Network file upload error:
https://pastebin.com/WcP0wDse

Location file upload error:
https://pastebin.com/6XRzzsfS

Do you have any recommendation?

Thank you

If a network contains the symbol "", the network is stored without "". For example a network called "My\Network" would be stored "MyNetwork". Clients probing a network with the same symbol is affected by the same bug. One solution to this could be setting SQL mode to "NO_BACKSLASH_ESCAPES". It would probably be safest to only set it to that mode on this database, if possible.

Hello Sir. I'm a UI/UX and Graphics Designer. I'm happy to see an open source project, So, I want provide a logo for you. Would you mind if I propose a new logo design for your project as my Open Source Contribution?

Thanks before.

I successfully installed your latest containerized code using the page instructions. I'm running it as a VMWare VM on 64-bit Kali Linux 2020.1. The containers are running without errors and I can access the web GUI for all components (Map, Tools, phpmyadmin, etc). When attempting to import the Wigle network.csv and location.csv I run into the errors below.

Warning: mysqli::__construct(): (HY000/1049): Unknown database 'wifimap' in /var/www/html/tools/php/network_import.php on line 33
Warning: mysqli_set_charset(): Couldn't fetch mysqli in /var/www/html/tools/php/network_import.php on line 36
Warning: mysqli::query(): Couldn't fetch mysqli in /var/www/html/tools/php/network_import.php on line 110
Fatal error: Uncaught Error: Call to a member function fetch_assoc() on bool in /var/www/html/tools/php/network_import.php:111 Stack trace: #0 {main} thrown in /var/www/html/tools/php/network_import.php on line 111

Warning: mysqli::__construct(): (HY000/1049): Unknown database 'wifimap' in /var/www/html/tools/php/location_import.php on line 33
Warning: mysqli_set_charset(): Couldn't fetch mysqli in /var/www/html/tools/php/location_import.php on line 36
Warning: mysqli::query(): Couldn't fetch mysqli in /var/www/html/tools/php/location_import.php on line 56
Fatal error: Uncaught Error: Call to a member function fetch_assoc() on bool in /var/www/html/tools/php/location_import.php:57 Stack trace: #0 {main} thrown in /var/www/html/tools/php/location_import.php on line 57

Hi,

I've got javascript console errors when trying to load map, map loads but without any point data, the database is already filled, api key is set correctly. Error looks like:

Uncaught TypeError: xml is null
    loadMap https://wifi.lan/js/index.js:124
    onreadystatechange https://wifi.lan/js/index.js:201
    downloadUrl https://wifi.lan/js/index.js:198
    loadMap https://wifi.lan/js/index.js:122
    loadSettings https://wifi.lan/js/settings.js:98
    loadMapThemes https://wifi.lan/js/mapthemes.js:614
    setVariables https://wifi.lan/js/index.js:23
    onload https://wifi.lan/:1

Update: already fixed it, there was no global settings for mysql database/password etc, i've made that it reads them from environment variables, now working \o/

Fixed the code using Null coalescing operators if environment variables are not available then use your default values, i can make pull request if you want and merge the changes.

Hi, i'm unable to find Dockerfile for the project, just wanted to build docker image for ARM aarch64. Thanks.

How do you fix This uploading error?

Sorry, there was an error uploading your file.
Warning: mysqli::__construct(): (HY000/1049): Unknown database 'wifimap' in /var/www/html/tools/php/network_import.php on line 33

Warning: mysqli_set_charset(): Couldn't fetch mysqli in /var/www/html/tools/php/network_import.php on line 36

Warning: fopen(uploads/com1.csv): failed to open stream: No such file or directory in /var/www/html/tools/php/network_import.php on line 38

ihave created database but still cant upload networks.csv and location.csv? I get this error:
"Sorry, there was an error uploading your file.
Warning: fopen(uploads/location.csv): Failed to open stream: No such file or directory in /var/www/html/tools/php/location_import.php on line 38"

If a network with SSID containing the symbol "," is imported, the import script will think the comma means the start of a new field, and the network will not be imported correctly. Currently the "Update fields in network table" script is set to delete these networks. One solution could be to use regular expressions to separate the different fields on a line (in network.csv), instead of simply splitting on each ",".