On 16 April 2013 20:21, Julien Plu <julien....@redaction-developpez.com> wrote: > Yes I think it's the best idea, and I think too that mysql is configured > only by the "/etc/mysql/my.cnf" file.
Oh, I see. But there is a special section for client config paramers, so I guess the parameters from ./bin/mysql --no-defaults --default-character-set=utf8 --socket="$MYDIR/mysql.sock" -u root -e "GRANT ALL ON *.* TO ''@'localhost'" mysql should go to the client section, I'm not sure. > > Best. > > Julien. > > > 2013/4/16 Jona Christopher Sahnwaldt <j...@sahnwaldt.de> >> >> On 16 April 2013 19:56, Julien Plu <julien....@redaction-developpez.com> >> wrote: >> > As you wish, it's just a standard configuration with 3-4 modifications >> > nothing more. >> > But at least I can precise in the guide the parameters that >> > they must change ? >> >> Just copy the parameters used in mysql.sh to the config file, without >> the leading '--'. Thus: >> >> mysql.sh: >> >> ./bin/mysqld_safe --no-defaults --character-set-server=utf8 >> --socket="$MYDIR/mysql.sock" --bind-address=localhost >> --datadir="$MYDIR/data" --max_allowed_packet=1G --key_buffer_size=1G >> --query_cache_size=1G >>"$MYDIR/mysql.log" 2>&1 & >> >> config file: >> >> socket="$MYDIR/mysql.sock" >> bind-address=localhost >> character-set-server=utf8 >> datadir="$MYDIR/data" >> max_allowed_packet=1G >> key_buffer_size=1G >> query_cache_size=1G >> >> Maybe that works, I don't know. Maybe you have to replace '-' by '_'. >> Or maybe the names are actually different. >> >> Also, I don't remember what no-defaults does and if should be in a config >> file. >> >> I think MySQL uses different config files for client and server, so >> you may have to edit them both. >> >> JC >> >> > >> > And I think you right for (at least) your LocalSettings.php because it >> > doesn't work with me :-( And I have to test the solution from Dimitris. >> > >> > Best. >> > >> > julien. >> > >> > >> > 2013/4/16 Jona Christopher Sahnwaldt <j...@sahnwaldt.de> >> >> >> >> The problem with having a whole configuration file in the repo is that >> >> the file probably contains many other settings besides the ones we >> >> need, and it changes with each MySQL version. When we use command line >> >> parameters, we don't have to change any MySQL config files, we just >> >> add the three or four settings that we need, and they don't change >> >> between MySQL versions. >> >> >> >> Maybe there is a way to tell MySQL, "here's an addtional config file >> >> whose settings should override the ones in the main config file". Then >> >> we could check in a minimal config file with just our settings. But >> >> taking a large config file from a MySQL installation, changing a few >> >> lines and then putting the modified version into the repo leads to >> >> more problems than it solves. >> >> >> >> We have the same problem with MediaWiki: we once took >> >> LocalSettings.php and ApiParse.php from a MediaWiki installation, >> >> modified a few lines and put the whole files into our repo. But in >> >> newer versions, the files look quite different, and the versions from >> >> our repo just don't work. Users have to edit the files and add the >> >> stuff needed for the abstract extractor. >> >> >> >> Cheers, >> >> JC >> >> >> >> On 16 April 2013 15:39, Julien Plu >> >> <julien....@redaction-developpez.com> >> >> wrote: >> >> > Ok thank you :-) >> >> > >> >> > I finish all the extraction process, and after I will modify the >> >> > guide >> >> > to >> >> > include what I think is missing. For the conf file I will make a pull >> >> > request with mine if everything is ok during all the process. >> >> > >> >> > Best. >> >> > >> >> > Julien. >> >> > >> >> > >> >> > 2013/4/16 Dimitris Kontokostas <jimk...@gmail.com> >> >> >> >> >> >> Hi Julien, >> >> >> >> >> >> You are free to improve any page on our wiki :) >> >> >> >> >> >> Regarding the MySQL script, if you think a conf file is easy to >> >> >> create >> >> >> and >> >> >> use, you can make a pull request and we 'll make the necessary >> >> >> tests. >> >> >> >> >> >> Best, >> >> >> Dimitris >> >> >> >> >> >> >> >> >> On Tue, Apr 16, 2013 at 1:14 PM, Julien Plu >> >> >> <julien....@redaction-developpez.com> wrote: >> >> >>> >> >> >>> Ok so if I have your approval I will modify the step-by-step guide. >> >> >>> >> >> >>> And maybe instead of using a script we can put a copy of a mysql >> >> >>> configuration file that users must have, no ? Less work (you don't >> >> >>> have a >> >> >>> script to maintain) and more easy for users. What do you think ? >> >> >>> Unless >> >> >>> there is a minimal or maximal version of mysql to use ? >> >> >>> >> >> >>> Best. >> >> >>> >> >> >>> Julien. >> >> >>> >> >> >>> >> >> >>> 2013/4/16 Jona Christopher Sahnwaldt <j...@sahnwaldt.de> >> >> >>>> >> >> >>>> PS: It would be cool if you could add a few lines to >> >> >>>> >> >> >>>> >> >> >>>> >> >> >>>> https://github.com/dbpedia/extraction-framework/wiki/Dbpedia-Abstract-Extraction-step-by-step-guide >> >> >>>> or even improve the script itself with better error and usage >> >> >>>> messages >> >> >>>> and send a pull request. >> >> >>>> https://github.com/dbpedia/extraction-framework/wiki/Contributing >> >> >>>> Thanks! >> >> >>>> >> >> >>>> On Apr 16, 2013 12:02 PM, "Jona Christopher Sahnwaldt" >> >> >>>> <j...@sahnwaldt.de> >> >> >>>> wrote: >> >> >>>>> >> >> >>>>> I quickly put that script together when I ran the abstract >> >> >>>>> extraction >> >> >>>>> last year, and I never expected it to have so many users. :-) >> >> >>>>> >> >> >>>>> I'm sorry that it's so badly documented and not really finished. >> >> >>>>> I'll >> >> >>>>> improve it in May. Don't have time now. :-( >> >> >>>>> >> >> >>>>> JC >> >> >>>>> >> >> >>>>> aaaa ok we need to download the MySQL archive before I thought >> >> >>>>> the >> >> >>>>> script did it for us. Maybe add this precision in the >> >> >>>>> documentation >> >> >>>>> ? >> >> >>>>> >> >> >>>>> Thanks :-) >> >> >>>>> >> >> >>>>> Best. >> >> >>>>> >> >> >>>>> Julien. >> >> >>>>> >> >> >>>>> >> >> >>>>> 2013/4/16 Andrea Di Menna <ninn...@gmail.com> >> >> >>>>>> >> >> >>>>>> Hi Julien, >> >> >>>>>> >> >> >>>>>> reading the mysql.sh script you should first set the env >> >> >>>>>> variable >> >> >>>>>> MYSQL_HOME to you MySQL installation folder. >> >> >>>>>> The script is first accessing that folder and then launching >> >> >>>>>> some >> >> >>>>>> MySQL scripts/commands, link mysql_install_db [1] >> >> >>>>>> >> >> >>>>>> Cheers >> >> >>>>>> Andrea >> >> >>>>>> >> >> >>>>>> [1] http://dev.mysql.com/doc/refman/5.0/en/mysql-install-db.html >> >> >>>>>> >> >> >>>>>> >> >> >>>>>> 2013/4/16 Julien Plu <julien....@redaction-developpez.com> >> >> >>>>>>> >> >> >>>>>>> Hi, >> >> >>>>>>> >> >> >>>>>>> The extraction tool has finished to compile and to download the >> >> >>>>>>> dumps >> >> >>>>>>> so now I install MySQL with the "dump/src/main/bash/mysql.sh" >> >> >>>>>>> script, and >> >> >>>>>>> when I run this script with the "sudo ./src/main/bash/mysql.sh >> >> >>>>>>> install >> >> >>>>>>> /etc/mysql/" command I fall on this error : >> >> >>>>>>> >> >> >>>>>>> ./src/main/bash/mysql.sh: ligne 51: ./scripts/mysql_install_db: >> >> >>>>>>> No >> >> >>>>>>> such file or directory >> >> >>>>>>> >> >> >>>>>>> And indeed this script doesn't exist in the repo. I have to >> >> >>>>>>> download >> >> >>>>>>> it somewhere ? >> >> >>>>>>> >> >> >>>>>>> Best. >> >> >>>>>>> >> >> >>>>>>> Julien. >> >> >>>>>>> >> >> >>>>>>> >> >> >>>>>>> >> >> >>>>>>> >> >> >>>>>>> ------------------------------------------------------------------------------ >> >> >>>>>>> Precog is a next-generation analytics platform capable of >> >> >>>>>>> advanced >> >> >>>>>>> analytics on semi-structured data. The platform includes APIs >> >> >>>>>>> for >> >> >>>>>>> building >> >> >>>>>>> apps and a phenomenal toolset for data science. Developers can >> >> >>>>>>> use >> >> >>>>>>> our toolset for easy data analysis & visualization. Get a free >> >> >>>>>>> account! >> >> >>>>>>> http://www2.precog.com/precogplatform/slashdotnewsletter >> >> >>>>>>> _______________________________________________ >> >> >>>>>>> Dbpedia-discussion mailing list >> >> >>>>>>> Dbpedia-discussion@lists.sourceforge.net >> >> >>>>>>> https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion >> >> >>>>>>> >> >> >>>>>> >> >> >>>>> >> >> >>>>> >> >> >>>>> >> >> >>>>> >> >> >>>>> >> >> >>>>> ------------------------------------------------------------------------------ >> >> >>>>> Precog is a next-generation analytics platform capable of >> >> >>>>> advanced >> >> >>>>> analytics on semi-structured data. The platform includes APIs for >> >> >>>>> building >> >> >>>>> apps and a phenomenal toolset for data science. Developers can >> >> >>>>> use >> >> >>>>> our toolset for easy data analysis & visualization. Get a free >> >> >>>>> account! >> >> >>>>> http://www2.precog.com/precogplatform/slashdotnewsletter >> >> >>>>> _______________________________________________ >> >> >>>>> Dbpedia-discussion mailing list >> >> >>>>> Dbpedia-discussion@lists.sourceforge.net >> >> >>>>> https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion >> >> >>>>> >> >> >>> >> >> >>> >> >> >>> >> >> >>> >> >> >>> >> >> >>> ------------------------------------------------------------------------------ >> >> >>> Precog is a next-generation analytics platform capable of advanced >> >> >>> analytics on semi-structured data. The platform includes APIs for >> >> >>> building >> >> >>> apps and a phenomenal toolset for data science. Developers can use >> >> >>> our toolset for easy data analysis & visualization. Get a free >> >> >>> account! >> >> >>> http://www2.precog.com/precogplatform/slashdotnewsletter >> >> >>> _______________________________________________ >> >> >>> Dbpedia-discussion mailing list >> >> >>> Dbpedia-discussion@lists.sourceforge.net >> >> >>> https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion >> >> >>> >> >> >> >> >> >> >> >> >> >> >> >> -- >> >> >> Kontokostas Dimitris >> >> > >> >> > >> > >> > > > ------------------------------------------------------------------------------ Precog is a next-generation analytics platform capable of advanced analytics on semi-structured data. The platform includes APIs for building apps and a phenomenal toolset for data science. Developers can use our toolset for easy data analysis & visualization. Get a free account! http://www2.precog.com/precogplatform/slashdotnewsletter _______________________________________________ Dbpedia-discussion mailing list Dbpedia-discussion@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion