Re: [Dbpedia-discussion] Problem with the MySQL installation script

2013-04-16 Thread Julien Plu
Done ! Hope it's fine for you :-) Best. Julien. 2013/4/16 Jona Christopher Sahnwaldt > On 16 April 2013 20:55, Julien Plu > wrote: > > That depends where you install mysql, with the packages from ubuntu > > repositories it's located in /etc/mysql. > > > > I think the "grant all ." line i

Re: [Dbpedia-discussion] Problem with the MySQL installation script

2013-04-16 Thread Jona Christopher Sahnwaldt
On 16 April 2013 20:55, Julien Plu wrote: > That depends where you install mysql, with the packages from ubuntu > repositories it's located in /etc/mysql. > > I think the "grant all ." line is useless, the best thing (and most > easy) is to ask to users to use root user. Here how I see things

Re: [Dbpedia-discussion] Problem with the MySQL installation script

2013-04-16 Thread Julien Plu
That depends where you install mysql, with the packages from ubuntu repositories it's located in /etc/mysql. I think the "grant all ." line is useless, the best thing (and most easy) is to ask to users to use root user. Here how I see things : step 1 : install mysql step 2 : open my.cnf file

Re: [Dbpedia-discussion] Problem with the MySQL installation script

2013-04-16 Thread Andrea Di Menna
Actually MySQL should be looking for configuration files in different locations http://dev.mysql.com/tech-resources/articles/mysql_intro.html#SECTION000150 Cheers Andrea Il giorno 16/apr/2013 20:24, "Julien Plu" < julien@redaction-developpez.com> ha scritto: > Yes I think it's the best

Re: [Dbpedia-discussion] Problem with the MySQL installation script

2013-04-16 Thread Jona Christopher Sahnwaldt
On 16 April 2013 20:21, Julien Plu 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-ch

Re: [Dbpedia-discussion] Problem with the MySQL installation script

2013-04-16 Thread Julien Plu
Yes I think it's the best idea, and I think too that mysql is configured only by the "/etc/mysql/my.cnf" file. Best. Julien. 2013/4/16 Jona Christopher Sahnwaldt > On 16 April 2013 19:56, Julien Plu > wrote: > > As you wish, it's just a standard configuration with 3-4 modifications > > nothi

Re: [Dbpedia-discussion] Problem with the MySQL installation script

2013-04-16 Thread Jona Christopher Sahnwaldt
On 16 April 2013 19:56, Julien Plu 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 '

Re: [Dbpedia-discussion] Problem with the MySQL installation script

2013-04-16 Thread Julien Plu
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 ? 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 D

Re: [Dbpedia-discussion] Problem with the MySQL installation script

2013-04-16 Thread Jona Christopher Sahnwaldt
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

Re: [Dbpedia-discussion] Problem with the MySQL installation script

2013-04-16 Thread Julien Plu
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 > Hi Julien, > > You are

Re: [Dbpedia-discussion] Problem with the MySQL installation script

2013-04-16 Thread Dimitris Kontokostas
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-developp

Re: [Dbpedia-discussion] Problem with the MySQL installation script

2013-04-16 Thread Julien Plu
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

Re: [Dbpedia-discussion] Problem with the MySQL installation script

2013-04-16 Thread Jona Christopher Sahnwaldt
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/wi

Re: [Dbpedia-discussion] Problem with the MySQL installation script

2013-04-16 Thread Jona Christopher Sahnwaldt
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 ok we need to download the MySQL archive be

Re: [Dbpedia-discussion] Problem with the MySQL installation script

2013-04-16 Thread Julien Plu
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 > Hi Julien, > > reading the mysql.sh script you should first set the env variable > MYSQL_HOME to you M

Re: [Dbpedia-discussion] Problem with the MySQL installation script

2013-04-16 Thread Andrea Di Menna
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/m

[Dbpedia-discussion] Problem with the MySQL installation script

2013-04-16 Thread Julien Plu
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