ð§ Linux ã€ã³ã¹ããŒã«
MariaDB
Windowsã«ã¯XAMPPãä»å±ããŠããŸãããããã§ã¯ã¹ã¿ã³ãã¢ãã³çã®SQLã§ããMariaDBã䜿çšããŸããããã¯ã·ã§ã«çµç±ã§ã€ã³ã¹ããŒã«ããŸãã
ããã±ãŒãžãã€ã³ã¹ããŒã«ããåã«æåã«è¡ãããšã¯ãã·ã¹ãã ãæŽæ°ããããšã§ããããã¯æ¬¡ã®ã³ãã³ãã§è¡ããŸãã
sudo apt-get updateå¿ ãsudoæš©éãæã€ãŠãŒã¶ãŒã䜿çšããŠãã ãããLinuxã§ã¯ãrootã¢ã«ãŠã³ãã¯ã·ã¹ãã äžã®ãã¹ãŠã®æ å ±ã«ã¢ã¯ã»ã¹ã§ããŸããäŸµå ¥ãªã©ã®ã€ã³ã·ãã³ããé²ããããç¹å®ã®ãŠãŒã¶ãŒã«sudoæš©éãäžãããªã¢ãŒãrootã¢ã¯ã»ã¹ãç¡å¹ã«ããããšããå§ãããŸããLinuxã®åæã»ãã¥ãªãã£å¯Ÿçã«ã€ããŠã¯ããã¡ããã芧ãã ããããã ã
ã·ã¹ãã ãæŽæ°ããããMariaDBãµãŒããŒãã€ã³ã¹ããŒã«ããŸãã以äžã®ã³ãã³ããå ¥åããŠãã ããã
sudo apt-get install mariadb-serverã¬ã€ãã«åŸã£ãŠã»ããã¢ãããé²ããŠãã ãããã¹ããŒã¹ããŒã§éžæãããªãã·ã§ã³ãããã€ããããŸããã€ã³ã¹ããŒã«ãå®äºãããã以äžã®ã³ãã³ãã§å®å šãªã€ã³ã¹ããŒã«ãå®è¡ããå¿ èŠããããŸãã
sudo mysql_secure_installationã¹ã¯ãªããã¯ãrootãŠãŒã¶ãŒã®ãã¹ã¯ãŒãèšå®ãå¿åãŠãŒã¶ãŒã®åé€ãããŒã«ã«ãã·ã³ãžã®rootãŠãŒã¶ãŒã¢ã¯ã»ã¹ã®å¶éããã¹ãããŒã¿ããŒã¹ã®åé€ãä¿ããŸããæåŸã«ãã¹ã¯ãªããã¯æš©éããŒãã«ããªããŒããããã¹ãŠã®å€æŽãå³åº§ã«åæ ãããããã«ããŸãã
ãã¹ãŠã®æé ã詳现ã«èª¬æãããŠããããã¹ãŠã®è³ªåã«ãYã(ã¯ã) ãšçããããšããå§ãããŸãã
äžèšã®ã»ãã¥ã¢ã€ã³ã¹ããŒã«ãå®äºãããã以äžã®ã³ãã³ãã§MySQLãµãŒãã¹ã«æ¥ç¶ã§ããŸããã»ãã¥ã¢ã€ã³ã¹ããŒã«æã«èšå®ãããã¹ã¯ãŒãã䜿çšããŠãããŒã«ã«ã®MySQL rootãŠãŒã¶ãŒãšããŠãã°ã€ã³ããŠãã ããã
mysql -u root -på®å šãªã€ã³ã¹ããŒã«ãè¡ã£ãããã«ãŒããŠãŒã¶ãŒã®ãã¹ã¯ãŒããå¿ããŠããŸã£ãå Žåãsudoæš©éãæã€ãŠãŒã¶ãŒã¯æ¬¡ã®ã³ãã³ããå®è¡ããŠmysqlãµãŒãã¹ãžã®ãã°ã€ã³ããã€ãã¹ã§ããŸãã
sudo mysql -u ã«ãŒã
管çè ãŠãŒã¶ãŒã®äœæ
äžèšã®æé ãå®äºãããšããµãŒããŒäžã§MariaDBãµãŒãã¹ãå®å šã«æ©èœããããã«ãªããŸããããã§ãšãããããŸãïŒæ¬¡ã«ãé©åãªèªèšŒæ å ±ãæã€ãŠãŒã¶ãŒãšãQBCoreã®èšå®ã«äœ¿çšããããŒã¿ããŒã¹ãèšå®ããå¿ èŠããããŸãã
ãŸããä»ã®ãŠãŒã¶ãŒãšããŒã¿ããŒã¹ã®äœæãåŠçã§ãã管çãŠãŒã¶ãŒãäœæããŸããããMariaDB ã§è¡ããããã¹ãŠã®æäœã«ã¢ã¯ã»ã¹ã§ããæšæºã® root ãŠãŒã¶ãŒã§ã¯ãªãããšã匷ããå§ãããŸãã
以äžã®ã³ãã³ãã§MySQLã€ã³ã¹ã¿ã³ã¹ãéããŸãã
mysql -u root -pã³ã³ãœãŒã«ã«å ¥ããšããããªæãã«ãªããŸã

管çè ãŠãŒã¶ãŒã¢ã«ãŠã³ãã®äœæã«é²ã¿ãŸãã以äžã®ã³ãã³ããçªå·é ã«å ¥åããŠãã ããããŠãŒã¶ãŒåããã¹ã¯ãŒãããã¹ãåãªã©ãããã€ãã®é ç®ãç·šéããã ãã§æžã¿ãŸãã
CREATE USER 'user1'@localhost IDENTIFIED BY 'password1';
(Check the user created by running this line) SELECT User FROM mysql.user;
GRANT ALL PRIVILEGES ON *.* TO 'user1'@localhost IDENTIFIED BY 'password1';
FLUSH PRIVILEGES;âuser1âãlocalhostãâpassword1â ã®å倿°ã¯ãã¹ãŠå€æŽãããã¯ãã§ããâuser1â ãš âpassword1â ãã£ãŒã«ãã®å€ã¯ããã°ã€ã³æã«äœ¿çšããå€ãªã®ã§ãä»»æã®å€ã«å€æŽã§ããŸãã localhost ã¯å°ãè€éã§ããLinux ã«ã¯ãã€ãã£ãã®ãã¹ã¯ãããç°å¢ããªãããããŠãŒã¶ãŒããªã¢ãŒãã§ããŒã¿ããŒã¹ã«ã¢ã¯ã»ã¹ããå¯èœæ§ãé«ããªããŸãããã®ããã«ã¯ãlocalhost ã®ä»£ããã« % (% ã¯ä»»æã®ãã¹ããæå³ããŸã) ãå ¥åããŸããâãŠãŒã¶ãŒ1â@â%â以äžã§ã¯ãæ¥ç¶æ¹æ³ãšéãããŒãã«ã€ããŠèª¬æããŸãã
ãªã¢ãŒãã¢ã¯ã»ã¹ã®èš±å¯ïŒDBïŒ
ããã©ã«ãèšå®ã§ã¯ãMariaDB ãš MySQL ã¯ã©ã¡ããããŒã«ã«ãããã¯ãŒã¯ããã®æ¥ç¶ã®ã¿ãèš±å¯ããŸããå€éšãœãããŠã§ã¢ïŒHeidiSQL ãªã©ïŒã PC ããããŒã¿ããŒã¹ã«æ¥ç¶ããã«ã¯ããããã®èšå®ã倿Žããå¿ èŠããããŸãã
ãããã®èšå®ãå«ããã¡ã€ã«ã¯ã/etc/mysql/mariadb.conf.d/50-server.cnf
ãã®ãã¡ã€ã«ã¯æ¬¡ã®ã³ãã³ãã§éããŸãsudo nano 50-server.cnfãã³ãã³ãã©ã€ã³ããã¹ããã¡ã€ã«ãšãã£ã¿ãŒãéããŸãã
以äžã®ã¹ã¯ãªãŒã³ã·ã§ããã¯ã倿Žãå¿ èŠãªè¡ã瀺ããŠããŸããããã©ã«ãèšå®ã§ã¯ããã€ã³ãã¢ãã¬ã¹ã¯127.0.0.1ã«èšå®ãããŠãããããŒã«ã«ãã¹ãããã®æ¥ç¶ã®ã¿ãèš±å¯ãããŸããããã0.0.0.0ã«å€æŽããããŒã¿ããŒã¹ãžã®ããããæ¥ç¶ãèš±å¯ããŸãã

nanoã§ã®ç·šéã¯éåžžã«ç°¡åã§ãããŠã¹ã䜿ããã«ã¡ã¢åž³ã䜿ãã®ãšåãã§ããç¢å°ããŒã䜿ã£ãŠã³ãŒãå ãç§»åããéåžžã®ç°å¢ãšåãããã«ãã¡ã€ã«ãç·šéããŸãã
ãã€ã³ã ã¢ãã¬ã¹ã 0.0.0.0 ã«ç·šéããåŸãCTRL+X ã䜿çšããŠãã¡ã€ã«ãçµäºãã倿Žãä¿åãããã©ããã確èªããã¡ãã»ãŒãžã衚瀺ãããã Y ãæŒãããã¡ã€ã«ã®ä¿ååã確èªããã¡ãã»ãŒãžã衚瀺ãããã Enter ããŒãæŒããŸã (éãããšããšåããã¡ã€ã«åã«ãªããŸã)ã
.d3fea41b.png&w=1080&q=75)
.2d314249.png&w=1920&q=75)
ãã®åŸã以äžã®ã³ãã³ãã䜿çšããŠãã¡ã€ã«ã®å€æŽã確èªããããã«mariadbãµãŒãã¹ãåèµ·åããŸãã
sudo systemctl restart mariadb以äžã®ã³ãã³ãã䜿çšããŠãµãŒãã¹ã®ç¶æ ã確èªã§ããŸãã
sudo systemctl status mariadb
ä»ã®ãã¹ãŠã®ãã¹ãããã®ãªã¢ãŒãã¢ã¯ã»ã¹ãèš±å¯ããŸãããããã§æ¥ç¶ã§ããŸãããïŒãŸã ã§ããããšäžã€ã ãããã¹ãããšããããŸãã
ããŒããéã
ããŒããçè§£ããã®ã¯ãç¹ã«åå¿è ã«ãšã£ãŠã¯å€§å€ãªããšã§ãã詳ããèŠãŠãããŸãããã
ããŒãã¯ããã®èåŸã«ç¹å®ã®ãã®ãååšãããã¢ã®ãããªãã®ã§ãããã¢ãééããã«ã¯ãéµãéããå¿ èŠããããŸãããã¢ãéããŠããªããã°ããã©ãã£ãã¯ã¯åœç€Ÿã®ãµãŒãã¹ãééã§ããŸããã
MySQL ãµãŒãã¹ã®ããã©ã«ãããŒã㯠3306 ã§ããèšå®ã§å€æŽã§ããŸãããå¿ ããã倿Žããå¿ èŠã¯ãããŸããããããã®ããŒããéãã«ã¯ãiptables ãšãããã¡ã€ã¢ãŠã©ãŒã«ãœãããŠã§ã¢ã䜿çšããŸããiptables ã¯éåžžãLinux ã®ç¹å®ã®ãã£ã¹ããªãã¥ãŒã·ã§ã³ã«æšæºã§ã€ã³ã¹ããŒã«ãããŠããŸããiptables ãã€ã³ã¹ããŒã«ãããŠãããã©ããã¯ã以äžã®ã³ãã³ãã§ç¢ºèªã§ããŸãã
sudo iptables --version以äžã®ã¹ã¯ãªãŒã³ã·ã§ããã®ãããªå¿çãåŸãããã°ãiptables ãã€ã³ã¹ããŒã«ããã䜿çšã§ããç¶æ ã«ãªã£ãŠããŸãã
![]()
iptables ãã€ã³ã¹ããŒã«ãããŠããããšã確èªããããæ¬¡ã®ã³ãã³ããå®è¡ããŠãMySQL æ¥ç¶çšã® 3306 ããŒããéããŸãã
sudo iptables -A INPUT -p tcp --dport 3306 -j ACCEPTãã®ãŠã§ããµã€ãã䜿çšããŠããŒããéããŠããŠèŠãããšãã§ãããã©ããã確èªã§ããŸããã ã
å®è¡äžã®ã¢ãŒãã£ãã¡ã¯ã
ã¢ãŒãã£ãã¡ã¯ãã®äœ¿çšã¯ããµãŒããŒã®é è³ãšãèšãããããæãéèŠãªéšåã§ããLinuxã·ã¹ãã ã«æšæºè£ åãããŠããããŒã«ã§ããwgetã䜿çšããŠãCfxã®WebããŒãžããã¢ãŒã«ã€ããçŽæ¥ããŠã³ããŒãããŸãããã Linuxã®ãã¹ãŠã®ã¢ãŒãã£ãã¡ã¯ãã®ãªã¹ãã§ãããææ°ã®ãã®ãå ¥æããã®ãæåã§ããå ¥æããã¢ãŒãã£ãã¡ã¯ãã®ããŒãžã§ã³ã決ãŸã£ãããå³ã¯ãªãã¯ããŠããªã³ã¯ãã³ããŒããéžæããŠãã ãããããã«ãããwgetã³ãã³ãã§äœ¿çšããã¢ãŒãã£ãã¡ã¯ããžã®çŽæ¥ãªã³ã¯ãã³ããŒãããŸãã
ãã¡ã€ã«ãããŠã³ããŒããããã©ã«ãã«ç§»åããŸããïŒç§ã¯éåžžãArtifactsãšFilesãåºå¥ããããã«å¥ã ã®ãã©ã«ããäœæããŸããïŒä»¥äžã®ã³ãã³ãã䜿çšããŸãïŒãªã³ã¯ã¯Artifactsã®Webãµã€ãããååŸãããã®ã«çœ®ãæããŠãã ããïŒã
wget https://runtime.fivem.net/artifacts/fivem/build_proot_linux/master/5742-ded89bc6acf29a720a7686a1de70d28b62c75af8/fx.tar.xz
ãããå®äºãããšãçŸåšãããã£ã¬ã¯ããªã«ãã¡ã€ã«ãäœæãããŸãããã®åŸã以äžã®tarã³ãã³ãã§ã¢ãŒã«ã€ããè§£åããŸãã
tar -xf fx.tar.xzã³ã³ãœãŒã«ã¯å°ãã®éãã³ã°ããŸãããå®äºããããdirã³ãã³ããå®è¡ãããšãã£ã¬ã¯ããªå ã®ãã¡ã€ã«ã衚瀺ãããŸãã

åŸã¯ãå®éã®ã¢ãŒãã£ãã¡ã¯ããå®è¡ããã ãã§ããWindowsã§ã¯.exeãã¡ã€ã«ãš.batãã¡ã€ã«ã䜿çšããŸãããLinuxã§ã¯.shãã¡ã€ã«ãšåŒã°ãããã¡ã€ã«ã䜿çšããŠCfxã¢ãŒãã£ãã¡ã¯ããå®è¡ããŸããå ã»ã©èª¬æããç»é¢ã衚瀺ãããŠããããšã確èªããrun.shãã¡ã€ã«ã®ãããã£ã¬ã¯ããªã§ä»¥äžã®ã³ãã³ããå®è¡ããŠFiveMãµãŒããŒãèµ·åããŠãã ããã
./run.shæ®ãã®ã»ããã¢ããã¯æ¯èŒçç°¡åã§ããtxAdmin ãã»ããã¢ããããŠããã®ã§ãWindows ã®ã€ã³ã¹ããŒã«ãšå šãåãã§ããWindows ã»ã¯ã·ã§ã³ã®ãã¥ãŒããªã¢ã«ãç¶ããŠãã ããããã ããã¢ãŒãã£ãã¡ã¯ãã«é¢ããéšåã¯é£ã°ãã.exe ã®å®è¡åŸã«ç¶ããŠãã ããããã ã