ÃÎÁ§ÖïÏɵ¥»ú¼ÜÉè½Ì³Ì£ºVM¾µÏñGSQL¸ÄIP½øÓÎÏ·

À´Ô´£º ×÷Õߣº µã»÷£º
ÃÎÁ§ÖïÏɲ»ÊÇ´«Ææ2/GOMϵ£¬ÊÇÖïÏÉ422µ××ÓÌ×ÃÎÁ§¸ÄÃûµÄ Linux£¨CentOS ÃÔÄã¾µÏñ£©+ GSQL ´¿¶Ë£¬±ØÐë¿¿ VMware ÅÜÐéÄâ»ú£¬Windows Ö±½ÓË«»÷ûÓá£ÕûºÏ°üͨ³£º¬£ºVM ¾µÏñ£¨CentOS4.8 »ò Mc-slax£©¡¢GSQL Êý¾Ý¿â¡¢SecureCRT¡¢WinSCP¡¢422 ÖïÏɿͻ§¶Ë¡¢element ²¹¶¡¡£ÏÂÃæ°´ÄÜÅÜͨµÄ˳Ðò×ß¡£

Ò»¡¢VMware ÓëÐéÄâ»úÍøÂç

×° VMware Workstation£¨7.0/10/15 ¶¼ÐУ¬±ðÓÃ̫а汾¿ªÀÏ vmx ż¶û¼æÈÝÎÊÌ⣩¡£µ¼Èë°üÀïµÄ .vmx Îļþ£¬Ê״δò¿ªÑ¡“ÒÆ¶¯”²»ÊÇ“¸´ÖÆ”¡£
ÐéÄâÍøÂç±à¼­Æ÷Àï°Ñ VMnet8£¨NAT£©×ÓÍøÉè³É 192.168.200.0£¬ÑÚÂë 255.255.255.0£¬NAT Íø¹Ø 192.168.200.2¡£
Æô¶¯ÐéÄâ»ú¾µÏñ£¬µÈ CentOS ºÚ´°¿ÚÎȶ¨£¬Ä¬ÈÏ»úÄÚ IP ÊÇ 192.168.200.100£¬root ÃÜÂë 123456¡£

Windows ËÞÖ÷»ú VMnet8 Íø¿¨Éèͬ¶Î£º192.168.200.1£¬Íø¹Ø 192.168.200.2£¬ÄÜ ping 192.168.200.100 ͨÔÙÍùÏ¡£

¶þ¡¢GSQL ×°¿âÓëµ¼Êý¾Ý

Windows ²à´ò¿ª°üÄÚ“GSQL·þÎñÆ÷+GM¹¤¾ß”→ Æô¶¯ GSql.exe¡£
½¨Á½¸ö¿â£º
• master£º¿âÎļþÖ¸Ïò GSQL·þÎñÆ÷+GM¹¤¾ß\Data\master.mdf£¬ÈÕÖ¾ mastlog.ldf

- wm£º¿âÎļþ wm.mdf£¬ÈÕÖ¾ wm_log.ldf
ÖØÆô GSql.exe£¬×´Ì¬À¸ÏÔʾ started¡£

Óà WinSCP Á¬ 192.168.200.100£¨root/123456£©£¬°Ñ´¿¶ËÀï DB Îļþ¼ÐµÄ .sql ´«µ½ÐéÄâ»ú /home/DB/¡£
SecureCRT Á¬Í¬Ò» IP£¬½ø GSQL ÃüÁîÐУº

gsql -u root -p

ÃÜÂë 123456£¬Ö´ÐУº

create database mlzx;
use mlzx;
source /home/DB/mlzx.sql;

ÅÜÍê³ö Query OK ¼´Êý¾ÝÂ䵨¡£exit ÍË¡£

Èý¡¢¸Ä·þÎñ¶Ë IP£¨×î¹Ø¼ü£©

WinSCP ½ø /home/mlzx/config£¬ÓÒ¼ü±à¼­ servers.xml ºÍ config.xml£¬Ctrl+F ËÑÔ­ IP£¨°üÀïÒ»°ãÊÇ 66.66.66.66 »ò 127.0.0.1£©£¬È«Ìæ»»³É 192.168.200.100£¬´æÅÌ¡£
»Øµ½ /home/mlzx ¸øÈ¨ÏÞ£º

chmod -R 777 *

ÆôºËÐÄ£º

./start

ºÚ´°¹öÈÕÖ¾³ö server start success »ò¸÷Ïß gs2 ok ¼´ÆðÍê¡£./stop Í££¬./rest ÖØÆð£¬./top Ë¢ÅÅÐС£

ËÄ¡¢¿Í»§¶ËÓëµÇ¼ָÏò

ËÞÖ÷»ú×° 422 ÖïÏÉÔ­°æ¿Í»§¶Ë£¨´¿¾»£¬±ðÓÃ΢¶Ë°æ£©¡£°Ñ´¿¶ËÀï element ²¹¶¡Îļþ¼ÐÕûÌ帲¸Ç½ø¿Í»§¶Ë¸ùĿ¼ element Ï£¬¸²¸Çǰ±¸·ÝÔ­ element¡£
¸Ä¿Í»§¶ËÁ¬½ÓÎļþ element\userdata\server\serverlist.txt£¨ANSI ±àÂ룩£º

ÃÎÁ§ÖïÏÉ 29000:192.168.200.100:502

¸ñʽÊÇ ·þÎñÆ÷Ãû ¶Ë¿Ú:IP:Ïß·£¬29000 Êǿͻ§¶ËÁ¬·þÎñ¶ËµÄ¶Ë¿Ú£¬502 ÊÇÏߺţ¬°´Äã¶ËÀï servers.xml дµÄÀ´£¬²»¶Ô¾Í½ø²»È¥¡£

Ë«»÷ element\elementclient.exe ½øÓÎÏ·£¬Ñ¡“ÃÎÁ§ÖïÏÉ”·þ£¬×¢²áÕ˺Å×ß GSQL µÄ GM ¹¤¾ß£¨°üÄÚ GM¹¤¾ß.exe → ²âÊÔÁ¬½Ó → Õ˺ŹÜÀí → н¨£©£¬½¨Íê½øÓÎÏ·¡£

Îå¡¢µ¥»ú×Ô²âÅÅ´í

• ¿Í»§¶Ëµã¿ªÊ¼Ã»·´Ó¦£ºelementclient.exe Òª¼æÈÝģʽÅÜ£¬WIN7 ÒÔÉÏÉè¼æÈÝ WIN7 ¹ÜÀíÔ±Æô¶¯¡£

• ¿¨ 0% Á¬½Ó£ºËÞÖ÷»ú ping ²»Í¨ 192.168.200.100 → VMnet8 Íø¶Î´í£»Í¨µ«Á¬²»ÉÏ → ÐéÄâ»úÀï ./start Ã»ÕæÆðÀ´£¬¿´ SecureCRT ÈÕÖ¾ÓÐûÓÐ bind port failed¡£

- ÄܽøÑ¡½Çµ«½¨½Çɫʧ°Ü£ºGSQL Àï mlzx ¿âûµ¼È«£¬ÖØ source Ò»´Î sql¡£
• ½øÍ¼ºÚÆÁ/ȱģÐÍ£ºelement ²¹¶¡Ã»¸²¸Ç¶Ô²ã£¬·þÎñ¶Ë config Àï ResourcePath Ö¸ÏòµÄ element Ŀ¼ҪºÍ¿Í»§¶ËÒ»Ö¡£

- Ïë±¾»ú´¿ 127 Íæ£º°ÑÐéÄâ»ú IP ¸Ä³É 127.0.0.1 ²»ÐУ¨Linux »Ø»·²»ÄܸøÍⲿ¿Í»§¶ËÓã©£¬±ØÐë×ß VMnet8 µÄ 192.168.200.x ÕâÒ»¶Î£¬ËÞÖ÷»ú¿Í»§¶ËÌî 192.168.200.100¡£

Áù¡¢×ª¾ÖÓòÍø£¨Í¬Íø¶ÎÆäËûÈ˽ø£©

°Ñ VMnet8 µÄ NAT ¸Ä³ÉÇŽӣ¨Bridge£©£¬ÐéÄâ»ú IP Éè³ÉºÍËÞÖ÷»úÍ¬Íø¶ÎÈç 192.168.1.100£¬servers.xml/config.xml ͬ²½¸Ä 192.168.1.100£¬¿Í»§¶Ë serverlist.txt Ò²¸Äͬ IP£¬ÆäËûÈËװͬ¿î¿Í»§¶Ë+element ²¹¶¡ÌîÕâ¸ö IP ¾ÍÄܽø¡£ÇŽÓģʽÏÂÐéÄâ»úÖ±½Ó³Ô·ÓÉÆ÷ DHCP£¬²»ÓÃÔÙÈÆ VMnet8¡£

´¿¶ËËùÓпÚÁîĬÈÏ£ºLinux root/123456£¬GSQL sa/123456£¬¿âÃû wm »ò mlzx£¬¸ÄÃÜÔÚÕýʽ³¤¿ªÇ°ÔÙ×ö¡£