| | 1 | = Mysql installation with macports (macOS 10.6.3), Json libs in HVP pilot = |
| | 2 | == Mysql installation problem in MacOS using macports (10.6.3) == |
| | 3 | * Mysql socket problem @ macports installation problem solved : |
| | 4 | * ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/local/var/run/mysql5/mysqld.sock' (2) |
| | 5 | * solved by ".set the mysqld_safe socket path in a new MySQL configuration file. Create /opt/local/etc/mysql5/my.cnf, add the following to it, save, the try again.'''['''mysqld_safe''']''' socket = /tmp/mysql.sock |
| | 6 | |
| | 7 | NOTE: If you've installed !MacPort's PHP 5 you will probably need to tell PHP where the MySQL socket is. Edit your php.ini file located at /opt/local/etc/php.ini. |
| | 8 | |
| | 9 | mysql.default_socket = /tmp/mysql.sock" DONE |
| | 10 | |
| | 11 | '''related links'''[[BR]] |
| | 12 | |
| | 13 | * http://2tbsp.com/content/install_and_configure_mysql_5_macports |
| | 14 | * It is weird though , although the mysql.sock supposed to be in /tmp (http://dev.mysql.com/doc/refman/5.0/en/mac-os-x-installation.html) , it is not there , but works.: |
| | 15 | * http://forums.mysql.com/read.php?35,64808,228369#msg-228369! |
| | 16 | * http://forums.mysql.com/read.php?35,64808,254785#msg-254785 |
| | 17 | * Now pma problem , although mysql is running : Phpmyadmin problem : !#2002 Cannot log in to the MySQL server |
| | 18 | * same problem @ [http://127.0.0.1/~despoina/pma/index.php?token=28d405578c9d7ceb32d6e727fa085047 http://127.0.0.1/~despoina/pma/index.php] |
| | 19 | * http://forums.mysql.com/read.php?35,64808,75300#msg-75300 |
| | 20 | * Setup Missing : http://www.phpmyadmin.net/documentation/Documentation.html#setup_script This worked for phpmyadmin problem! |
| | 21 | * DONE , pma working. |
| | 22 | * ...and last but not least ..[http://www.comentum.com/mysql-administration.html http://www.comentum.com/mysql-administration.html] |
| | 23 | * Mysql tables location : /opt/local/var/db/mysql5/ |
| | 24 | * Table database_test.gene (mark's database dump) successfully imported in hvp_pilot.gene table |
| | 25 | * DONE |
| | 26 | * Lucene : |
| | 27 | * path problems ... * |
| | 28 | * TODO |
| | 29 | * D2RQ : path problem : TODO |
| | 30 | |
| | 31 | == Install graphviz using Macports == |
| | 32 | * GraphViz: :macports despoina$ sudo port install graphviz : /opt/local/var/macports/software/graphviz/2.26.3_1+macosx |
| | 33 | * http://code.google.com/p/macvim/ , http://macvim.org/ DONE |
| | 34 | |
| | 35 | === JSON libs in HVP pilot === |
| | 36 | * TODO : include json libs in hvp_pilot |
| | 37 | * retrieve from ontocat (pilot : http://localhost:8080/ontocat/version0.3/test.html) |
| | 38 | * http://www.json.org/JSONRequest.html |
| | 39 | * [http://www.hunlock.com/blogs/Mastering_JSON_(_JavaScript_Object_Notation_) http://www.hunlock.com/blogs/Mastering_JSON_(_JavaScript_Object_Notation_)] |
| | 40 | * http://www.restlet.org/ |
| | 41 | * Molgenis distro rdf test : |
| | 42 | * Added a function for Http connection . Test if working. Error: |
| | 43 | * This seems familiar : SEVERE: Error configuring application listener of class MolgenisCompatibleD2RWebappInitListener |
| | 44 | |
| | 45 | === How to retrieve json data === |
| | 46 | Use json native available in several javascript libs |
