jira+tomcat+mysqlµÄ¼¯³É
ÒÔǰû½Ó´¥¹ýÕâ¸ö¶«¶«£¬Ç°ÌìÒ»¸öͬÊÂÈÃÎÒ°²×°ÏÂjira+confluence£¬µ«ÊÇconfluenceŪÁ˺ó¤Ê±¼äҲû¼¯³É³É¹¦£¡ÏÖÔÚ°ÑÉÏÊöÈýÕߵļ¯³É¹ý³Ì×ܽáÏ£¡
°²×°»·¾³£º
ϵͳ£ºxp sp2
jdk: 1.6
tomcat: 5.5 °²×°°æ (¿ÉÒÔÓýâѹ°æµÄ)
MySql: 5.0.x
ËùÐèÈí¼þ£º
jiar£º atlassian-jira-enterprise-3.9.3.zip £¨ÕâÊǸöWAR/ERAµÄ°²×°°ü,¾ÍÊÇÓû§¿ÉÒÔ¼¯³ÉËü×Ô¼ºµÄweb·þÎñÆ÷£©
µÚÈý·½jar°ü£º jira-jars-tomcat5.zip
mysql-jdbc-driver£ºÕâ¸öÈ¥ËüµÄ¹Ù·½ÍøվϰÉ
¼¯³ÉjiraÇ°µÄ×¼±¸¹¤×÷£º
1.°²×°mysql£¬½¨Á¢Ò»¸öÃûΪ£ºjiradbµÄÊý¾Ý¿â£¬
2.´´½¨Ò»¸öÓû§ÃûΪjirapub ÃÜÂëΪjiraµÄÓû§£¬¸³ÓèËü²Ù×÷jiradbÊý¾Ý¿âµÄȨÏÞ¼´¿É
ÅäÖãº
1.½âѹjira£¬ÆäÎļþĿ¼ÈçÏ£º
2.ÐÞ¸Äedit-webapp\WEB-INF\classes\Ŀ¼ÏµÄentityengine.xmlÎļþ£¬ÕÒµ½datasource½Ú£¬½«field-type-nameÊôÐԸijÉmysql£¬È»ºó½«schema-name="PUBLIC"ɾ³ý£¬±£´æ£¡
3.etc\ϵÄtomcat-5.5-jira.xmlÎļþ£¬ÕÒµ½Resource
½Ú£¬usernameºÍpassword·Ö±ðΪǰÃæ´´½¨µÄÓû§ÃûºÍÃÜÂë¡£ÐÞ¸ÄdriverClassName½ÚÊôÐÔΪcom.mysql.jdbc.Driver£¬ÐÞ¸ÄurlΪ"jdbc:mysql://your ip:port/jiradb?autoReconnect=true&useUnicode=true&characterEncoding=UTF8"±£´æ£¡
4.µã»÷build.batÎļþ£¬µÈ´ýÔËÐÐÍê³Éºó£¬»á¿´µ½Éú³ÉÁËеÄÎļþ£¬ÆäÎļþ½á¹¹´óÖÂÈçÏ£º
5.×öÍêÕâЩ£¬jiraµÄÅäÖûù±¾¾Í²î²»¶àÁË£¬ÏÖÔÚÎÒÃÇÀ´ÅäÖÃtomcat£¬ÈÃËûÖ§³ÖjiraµÄÔËÐÐ
6.ÆäʵÕâ²½ºÜ¼òµ¥£º¿½±´½âѹjira-jars-tomcat5.zip ϵÄjarÎļþºÍmysqlµÄjdbcÇý¶¯µ½Tomcat 5.5\common\libϾͿÉÒÔÁË
7.½«dist-tomcat\tomcat-5.5µÄjira.xml¿½±´µ½Tomcat 5.5\conf\Catalina\localhost¾Í¿ÉÒÔÁË¡£
×öÍêÕâЩºó£¬ÎÒÃǾͿÉÒÔÆô¶¯tomcatÁË£¬µ±È»ÒªÈ·±£ÄãµÄmysql·þÎñ¿ªÆôÁËŶ£¡Æô¶¯tomcatºó£¬ÎÒÃÇÔÚÔËÐÐÏÂÊäÈ룺http://locahost:8080/jiraºó¾Í¿ÉÒÔ¿ªÊ¼°²×°jiraÁË£¡
ÍƼöÒ»¸ö²Î¿¼ÍøÖ·£ºhttp://www.blogjava.net/yongbing/archive/2008/03/03/183519.html
Ïà¹ØÎĵµ£º
¡¡¡¡ÒÔMySQL-server-4.0.14-0.i386.rpmΪÀý£¬·ÅÔÚ/dataĿ¼ÏÂ
¡¡¡¡cd /data
¡¡¡¡rpm -ivh MySQL-server-4.0.14-0.i386.rpm
¡¡¡¡°²×°Íê³ÉºóÔÚ/usr/share/mysqlĿ¼ÖлáÓÐÒ»¸ömysqlµÄÆô¶¯½Å±¾mysql.server¼°Ê¾ÀýÅäÖÃÎļþµÈ(Èçmy-huge.cnf¡¢my-large.cnf¡¢my-medium.cnf)
¡¡¡¡¿½±´Ò»¸öʾÀýÅäÖÃÎ ......
1. ¹ØµôMysql·þÎñ
2.н¨Ò»¸öÎı¾Îļþ£¬ÄÚÈÝÈçÏ£º
UPDATE mysql.user SET Password=PASSWORD('NewPassword') WHERE User='root';
FLUSH PRIVILEGES;
×¢Ò⣺һ¶¨Òª·ÖÁ½ÐÐд£¬"NewPassword"ΪÄãµÄÐÂÃÜÂë
3. ±£´æÎļþ£¬²¢°ÑËü·ÅÔÚCÅ̸ùĿ¼Ï£¬ÎļþÃûΪ"mysql-init.txt"£ºC:\mysql-init.txt
4. ´ò¿ªcmd´°¿Ú£¬Êä ......
1.CREATE USER
CREATE USER user [IDENTIFIED BY [PASSWORD] 'password']
[, user [IDENTIFIED BY [PASSWORD] 'password']] ...
CREATE USERÓÃÓÚ´´½¨ÐµÄMySQLÕË»§¡£ÒªÊ¹ÓÃCREATE USER£¬Äú±ØÐëÓµÓÐmysqlÊý¾Ý¿âµÄÈ«¾ÖCREATE USERȨÏÞ£¬»òÓµÓÐINSERTȨÏÞ¡£¶ÔÓÚÿ¸öÕË»§£¬CREATE USER»áÔÚûÓÐȨÏÞµÄmysq ......
Blogϵͳ×÷Ϊ´ó¼Ò×î³£½Ó´¥µÄ»¥ÁªÍø¶«¶«£¬ÔÚÕ¾³¤ÈºÌåÖм¸ºõÈËÊÖÒ»²©£¬´ÓÖªÃûÃÅ»§µÄ²©¿ÍƵµÀ£¬µ½ÍøÂçÓªÏúר¼Ò²©¿Í£¬ÍøÃñ¶Ô²©¿ÍµÄ¹Ø×¢¶ÈÔÚ²»¶ÏÌá¸ß²¢É¡£Ä¿Ç°ÍøÉÏÃâ·ÑµÄblogϵͳ̫ÔÓ£¬ÔÚ´ËÕûÀíPHP°æµÄBlog½éÉÜÈçÏ£º
1¡¢wordpress:http://www.wordpress.org ¹¦ÄÜÒ²ºÜÈ«Ã棬Ӧ¸ÃÊÇÖ§³ÖblogµÄÊ×Ñ¡¡£ËüÓÐ×îÇ¿µÄÄ£°æ¹¦ÄÜ£¬ÒѾ ......
²Ù×÷Êý¾Ý¿â
µÇ¼µ½mysqlÖУ¬È»ºóÔÚmysqlµÄÌáʾ·ûÏÂÔËÐÐÏÂÁÐÃüÁÿ¸öÃüÁîÒԷֺŽáÊø¡£
1¡¢ ÏÔʾÊý¾Ý¿âÁÐ±í¡£
show databases;
ȱʡÓÐÁ½¸öÊý¾Ý¿â£ºmysqlºÍtest¡£ mysql¿â´æ·Å×ÅmysqlµÄϵͳºÍÓû§È¨ÏÞÐÅÏ¢£¬ÎÒÃǸÄÃÜÂëºÍÐÂÔöÓû§£¬Êµ¼ÊÉϾÍÊǶÔÕâ¸ö¿â½øÐвÙ×÷¡£
2¡¢ ÏÔʾ¿âÖе ......