Hello, I have some problems. Can you help me?

[wstzbz]

---

[jmonclard]

Hi wstzbz, Did you edit the config.php file ? Seems you are either not using the right password or you haven't created a "user" for your mysql database for MopScreens to use. If you still have trouble using my php code I can send you a document on how to install it. Jerome

[jmonclard]

No more info from wstzbz since I have proposed to help. I'm considering this as solved.

[wstzbz]

Happy New Year! Thank you very much for your reply. I'm from China. Our club is using MEOS at present. I saw your mopscreens. I'm very interested. From the explanation, it's very helpful for our external exhibition. I tried to install and use it, but it didn't succeed. My network knowledge is not very rich. I hope you can help me use mopscreens,

------------------ 原始邮件 ------------------ 发件人: "Jérôme Monclard"<notifications@github.com>; 发送时间: 2019年12月31日(星期二) 上午6:04 收件人: "jmonclard/MopScreens"<MopScreens@noreply.github.com>; 抄送: "王松涛"<554211012@qq.com>;"Author"<author@noreply.github.com>; 主题: Re: [jmonclard/MopScreens] Hello, I have some problems. Can you help me? (#12)

No more info from wstzbz since I have proposed to help. I'm considering this as solved.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or unsubscribe.

[jmonclard]

I may help if you have some specific question. Your initial one was a bit too broad to be answered.

Unfortunately using mopscreens require some knowledge in computing as there is no setup program. Mainly you need to be able to install a web server on a computer and configure a mysql database. Just as an example (there are hundreds of ways to do something equivalent) you may perhaps have a look to the setup we are using here in France. You can download during 30 days a french version of a procedure (pdf file) to duplicate our setup here : http://dl.free.fr/oLTqhjWeV It may help you in some ways, event if you use very different hardware and operating system. Having a look at section 5.2.3 and 5.2.4 may be of particular interest. Unfortunately I haven't any time during the next weeks to translate this document in english, so try with google translate or some equivalent tools. Do not hesitate to ask specific questions if you are stuck. I reopen the issue for next exchanges, but if you prefer direct mail, just use my gitub name and add @ metraware.com Hope you will succeed in your installation, and happy new year !

[mkozma]

Hi. Martin from Bayside Kangaroos OC Australia also testing this software. Following the MopScreens-en.pdf instructions all the way until the screenconfig section before getting an error. I do not have the "screen" icon.

Any help to push me forward would be much appreciated.

[jmonclard]

Hi Martin, May you add some detail about your problem ? Any error message when you press the "pencil" button ? Have you had a look at Apache log file ? May be it will be easier to go on solving your issue by direct e-mail exchange. Here is my e-mail address : jmonclard (AT) metraware.com For the first e-mail you will get an automatic message back from our anti-spam for you to prove your are a human.

[mkozma]

Thanks. Let me check your suggestions first. Martin

[mkozma]

Here is the screenshot when clicking the pencil of the active Test Config.

[mkozma]

Looks like something is not defined. In the documentation it says that there is a constant for the number of screens but I could not find this constant. Maybe that's it.

[wstzbz]

Can you resend me in French?

[jmonclard]

The number of screen is defined in config.php : define("NB_SCREEN",23); But I'm pretty sure this is not the problem. Have defined the constants at the beginning of the config.php file ? You have to specify the username and password for the MySQL database access

[mkozma]

mySQL username and password defined in config.php

[jmonclard]

My fault ! Seems that last summer when I add some display options I forgot to upgrade the setup.php file. I will update the file and check for other tables then upload a new version on GitHub during the next days but in the meantime can you add some new columns manually in the resultscreen table using phpmyadmin ? [EDIT please see next messages for a better solution] Here is attached a dump of the expected structure for this table from our operational system. You need to add all the panel1displaynomprenom and similar fields resultscreen_structure.pdf Thank you for pointing me on this issue. Hope the aren't many like this one... Keep me in touch.

[jmonclard]

Changes pushed on GitHub.

[jmonclard]

Well, in fact I made a mysql_update_20190620.php file just for that purpose, and forget it ! So please execute mysql_update_20190620.php ONCE if you have the version of setup.php prior to 2020-03-14.

[wstzbz]

How should I modify this?

[jmonclard]

The message says that the function redirectSwitchUsers can't be found. This function is defined in functions.php on line 29. So, first check the file functions.php exists and contains the redirectSwitchUsers() function. Then check for the path. I see that your screenconfig file is in the cfco subfolder. This is what we are actually using here, but be sure that all your files paths are consistent. In fact this function isn't really mandatory, it's just to ensure that nobody can connect to MopScreens using WiFi (here the WiFi router has an IP address of 192.168.0.20, and this is precisely the value that is defined in this function). So, you may very well just remove all redirectSwitchUsers() calls in all php files, but the security will be slightly lower. Generally not a big issue on an orienteering arena, thanks to the prevailing good spirit of competitors and spectators.

[mkozma]

Not sure how to tell which version of the setup.php file I have but running the mysql_update_20190620.php file produces an error on the ConnectToDB() function.

[mkozma]

I ended up manually running each of the mySQL statements against my database but it didn't seem to make any difference to the screenconfig page.

[jmonclard]

Hi Martin, sorry for the delay, I was out for the day. Probably the last one I could go out here due to CoVid ! I'm very surprised by the undefined function ConnectToDB(). This function is part of functions.php on line 18. It means that for an unexpected reason, the file functions.php has not been found. Could you check that all paths and directories are in accordance ? May you also have a look to the apache log file just in case it could give you a hint ? You said that the error for the screenconfig page is still there. That's really strange if you added these fields to the table. I will also try an installation on a fresh new PC from the code on this GitHub to see what happen. But life is a bit perturbed these days, so I can't guarantee I will find time to do it on Monday. I will also translate ASAP the part of the french documentation of the full system installation dealing with Mopscreen installation and database configuration. Things in MySQL have changed since I started writing this code, and now, for security reasons, you must create and add a user and grant some privileges to get access to the database. You can't no more use the root user. This is not in the original documentation.

[mkozma]

Thanks for your all your efforts. I got out yesterday as well - and also could be the last for a while. I'll check everything you have said.

I'll try and do a completely fresh environment (new database, new pull request from GitHub) and load that up on the Apache web server and see if I still run into issues.

Happy to test the English version of the documentation to make sure it works.

You're providing a terrific add on for meOS - so thank you!

[mkozma]

I have the latest version but I seem to have a lot of syntax errors in the setup.php file.

[jmonclard]

I have translated the system installation documentation and pushed it on GitHub along with the french version. Perhaps it may be of some help to you. There is surely many typos and wrong translation in it so feel free to fix them as the .tex file is also here. I will regenerate the pdf if you do the changes in the .tex file. Please note that I did the translation without having the system running in front of me, moreover not in an english version of Linux, and consequently not with the exact english text of menus and windows. You could have to interpret a bit the captions !

I will try a fresh install of MopSreens ASAP to see what could be wrong, but don't expect my feedback too soon as I will be really busy for next two weeks. Sorry for the delay.