MuADMINS
Çözümler
Yaygın MU Online sunucu, client ve web sitesi sorunları için kısa düzeltmeler; her biri kaynağı ve tarihiyle. “Onaylanmış”, soruyu soran kişinin düzeltmenin işe yaradığını söylediği anlamına gelir.
98 çözüm “couldn't connect to sql server” için · Temizle
After switching PHP from 5.6 to 7.x in cPanel my WebEngine lost the connection to the MuOnline database.
1. Each PHP version in cPanel has its own extension list. 2. Check the new version is supported by your WebEngine release. 3. In cPanel PHP selector, enable the same connection extension...
✓ Konu sahibi tarafından onaylandıTuServerMU · 2021-07-31Remote tools or the web cannot reach a SQL Express or named instance on port 1433. How do I make SQL listen on a fixed port?
1. Named instances use dynamic ports by default; only the default instance uses 1433. 2. SQL Server Configuration Manager > SQL Server Network Configuration > Protocols for your instance...
MuMaker for Season 6 (TMT, TRN edit): what each module does and how it connects (local, remote IP or no-ip DNS)
1. It supports Season 1 to Season 6, including Rage Fighter and the first master quest classes. 2. AccountMaker edits accounts and characters (stats, quest, class, PK) and supports MD5; I...
IGCN License Manager: what the GameServer license errors mean (Cannot connect to Auth Server, Time Check Failed, IP Address or HWID not found, Activation Time is over)
1. Cannot connect to Auth Server (first connect) or Failed to connect to any of auth servers (reconnect): check that the subscription is active, that the IPs in the license data on the Li...
MFS Database Tool: the backup gives the same error as other backup managers, even with (local), Windows authentication or 127.0.0.1
1. Connect to your SQL Server as usual (the tool supports SQL Server 2000 and 2008 style connections). 2. Do not pick the database with the drop down button: type the database name (for e...
✓ Konu sahibi tarafından onaylandıRaGEZONE · 2014-02-11IzsMuEditor 2.1.2 (EX803): the editor does not connect to the database
1. By default IzsMuEditor connects through an ODBC DSN. 2. If it does not connect, open Data\IzsConfig.ini, set Use_ODBC to 0 and fill in your SQL connection data (server, user, password)...
The website always shows 2 players online even when the server is off
Stale rows in MEMB_STAT still say the accounts are connected. 1. Open Query Analyzer / SSMS on the MuOnline database. 2. Run UPDATE MEMB_STAT SET ConnectStat='0' WHERE ConnectStat>0. 3. R...
✓ Konu sahibi tarafından onaylandıDarksTeam · 2009-03-03How to get the list of e-mail addresses of all registered accounts from the MU database
1. Open SQL Server Management Studio and connect to the server that holds your MU database. 2. Run: USE MuOnline; SELECT mail_addr FROM MEMB_INFO; 3. The result is the e-mail of every acc...
✓ Konu sahibi tarafından onaylandıTUServerMU · 2021-03-17MuCore install on a web host: after the serial number step, step_1 of the installer shows nothing (Season 6 repack)
1. Open the MuCore configuration file that holds the database settings. 2. Find $core['connection_type'] = "MSSQL";. 3. Change the value to lower case: $core['connection_type'] = "mssql";...
✓ Konu sahibi tarafından onaylandıRaGEZONE · 2018-03-23MuEmu Season 8 Episode 3 asks for a Me_MuOnline database; where do I get it?
1. There is no separate Me_MuOnline download: for these files it is the same database as MuOnline. 2. Point the Me_MuOnline connection (ODBC data source or config entry) to your MuOnline...
✓ Konu sahibi tarafından onaylandıRaGEZONE · 2017-03-09WebEngine cannot connect to an older SQL Server (2008, 2012, 2014, 2016). What settings help?
1. Linux with pdo_dblib: install FreeTDS (apt install freetds-bin) and add a named block in /etc/freetds/freetds.conf with host, port 1433, encryption off and tds version 7.1. 2. Test it...
After moving the MU server and WebEngine to a new Windows Server machine (VirtualBox), the site connects to the database but the crons stop updating rankings.
1. Go to the includes/cache folder of the site and delete the cached data files. 2. If needed, run the cron once by hand with the link shown in AdminCP > Cron Manager. 3. The rankings ref...
✓ Konu sahibi tarafından onaylandıTuServerMU · 2021-03-25What is in the X-Team MuOnline database (password column, VIP, coins, resets, gens, master level)?
X-Team uses one database, MuOnline, with the MuEmu procedure set. - Accounts: MEMB_INFO.memb__pwd varchar(10) (plain; no MD5 function in the scripts), sno__numb char(18), AccountLevel / A...
Not verifiedMuADMINS tarafından yazıldıWhich databases do IGCN files need (MuOnline, Me_MuOnline, Events, Ranking, BattleCore) and in which order do the update scripts run?
IGCN files use up to five databases: - MuOnline: accounts (MEMB_INFO, MEMB_STAT), characters, guilds, warehouse, cash shop (T_InGameShop_Point), VIP (T_VIPList). - Me_MuOnline: optional s...
Not verifiedMuADMINS tarafından yazıldıCash Editor gives an error when editing credits, although the SQL user and password are set
The cash table and column names in the editor config were wrong. 1. Open the editor config file (XTRMu in the thread). 2. [SQLConnection]: SQLHost = (local), SQLUser = your SQL user, SQLP...
✓ Konu sahibi tarafından onaylandıTUServerMU · 2020-07-10Which website CMS expects which MU database columns (WebEngine table maps, DmN)
WebEngine 1.2.7 picks a table map by server files (includes/config): - igcn.tables.php / custom.tables.php: resets = Character.RESETS, grand resets = Character.GrandResets, VIP = T_VIPLis...
Not verifiedMuADMINS tarafından yazıldıMuCore website Exchange System always shows 0 Online Hours although the character was online for hours (DarkMaster 97d server)
The MuCore module reads the column OnlineMinutes, which did not exist in the database. 1. Take the online-time SQL script from the thread (it adds a column to MEMB_STAT and changes the st...
✓ Konu sahibi tarafından onaylandıDarksTeam · 2019-07-25DarksTeam 97d+99i moved to a VPS (Windows Server 2012 R2, SQL 2008 R2): RankingServer shows an error although the config did not change
The VPS firewall was blocking the RankingServer connections. 1. In Windows Firewall (and the VPS provider firewall, if any) allow the RankingServer program, or open the port it uses, for...
✓ Konu sahibi tarafından onaylandıTUServerMU · 2020-07-08Anyone can log in with a random account name and password, and the login creates that account in SQL
1. This is not a database bug: the server has automatic account registration switched on, so an unknown login is created on the spot. 2. Open the JoinServer config (in some files the opti...
✓ Konu sahibi tarafından onaylandıRaGEZONE · 2021-04-15DataServer and JoinServer do not connect after running the ODBC file that came with the files
The .reg or .bat ODBC file bundled with many server files does not always create the data source on your Windows. Create it by hand: 1. Open the ODBC Data Source Administrator (on 64-bit...
✓ Konu sahibi tarafından onaylandıTUServerMU · 2021-06-08