Community AlphaAlpha MUADMINS
PTPortuguês (Brasil)
Entrar
No MuADMINSConfig ScannerEnvie o zip dos seus arquivos: rates, drops, spots, limitesAbrirNo MuADMINSEncontre-nos no DiscordPeça ajuda, mostre o que está criando e converse sobre MU com outros donos de servidores.Abrir

MuADMINS

Soluções

Correções curtas para problemas comuns de servidor, cliente e site de MU Online, cada uma com a fonte e a data. “Confirmado” significa que quem perguntou disse que a correção funcionou.

40 soluções para “sql login” · Limpar

  1. Configuração do servidorMuEmu / LouisSeason 8 Episode 3

    JoinServer and DataServer stopped connecting to the database (MuEmu Season 8)

    Restoring the database and the ODBC data sources again did not help: the SQL login the servers use did not have the rights it needs. 1. Open SQL Server Management Studio and go to Securit...

    ✓ Confirmado pelo autor do tópicoTUServerMU · 2018-10-06
  2. Configuração do servidor

    Could not find stored procedure 'WZ_CONNECT_MEMB' (or WZ_DISCONNECT_MEMB): what they do and how to restore them

    WZ_CONNECT_MEMB and WZ_DISCONNECT_MEMB keep MEMB_STAT up to date (ConnectStat 1 at login, 0 at logout). They must exist in the database the JoinServer / DataServer connects to: - IGCN: in...

    Not verifiedEscrito pelo MuADMINS
  3. Configuração do servidorany

    How to back up only the accounts and characters (inventory, warehouse, stats) instead of the whole MU database

    1. First make a full backup of the current database as it is (SQL Server Management Studio > Tasks > Back Up). 2. To move players to a clean database, copy over only the tables that hold...

    ✓ Confirmado pelo autor do tópicoTUServerMU · 2020-07-23
  4. Configuração do servidorMuEmu / LouisS6

    MuEmu S6 by Louis: DataServer and JoinServer say 'Could not connect to database' with both included databases, even with correct IPs and open ports.

    1. The included ODBC .reg created a data source named MuOnlineS6 pointing to database MuOnlineS6. 2. Edit the ODBC data source (or the .reg) so the name and database match what the server...

    ✓ Confirmado pelo autor do tópicoTuServerMU · 2017-10-10
  5. Site

    WebEngine: accounts made on the website cannot log in (password encryption must match memb__pwd)

    WebEngine 1.2.7 has four password modes (install/definitions.php PDO_PWD_ENCRYPT) and writes MEMB_INFO differently for each: - none: memb__pwd = :password (plain), for varchar columns (IG...

    Not verifiedEscrito pelo MuADMINS
  6. Siteany

    WebEngine shows a PDOException with my SQL Server host, user and password on screen when the database is down. How do I hide it?

    1. The full stack trace is printed only because debug mode is turned on in your WebEngine configuration. 2. Turn debug mode off on the live site so visitors only see a generic error. 3. I...

    ✓ Confirmado na issueGitHub (lautaroangelico/WebEngine) · 2017-08-10
  7. Site

    What does the DmN CMS setup change in the MU database (columns, Character.id, WZ_CONNECT_MEMB) and what can break?

    The DmN CMS 1.2.3 setup does more than create its own tables: 1. It ALTERs the game databases: adds columns from its version files, for example MEMB_INFO Admin, last_login, activated, act...

    Not verifiedEscrito pelo MuADMINS
  8. SiteS1 to S12

    DTweb 2.0 (MuOnline CMS for all seasons): how do I install it and log into its admin panel the first time?

    1. Run Script.sql in your SQL query analyzer on the server database. 2. Put the website in the main web directory, not in a subfolder: some files use the document root and images or inclu...

    Reescrita da fonte pelo MuADMINSNot verifiedGitHub (r00tmebaby/DT-Web-2.0-MuOnline-CMS-All-Seasons) · 2019-04-12
  9. Configuração do servidorIGCNS12

    IGCN Season 12: DataServer is not responding although TCP/IP is enabled in SQL Server

    1. Open DataServer.ini and check SQLServerName. 2. When SQL Server runs on the same machine use SQLServerName = (local) or the exact PC name as shown in SQL Server Management Studio (for...

    ✓ Confirmado pelo autor do tópicoRaGEZONE · 2020-01-08
  10. Site

    Which 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 verifiedEscrito pelo MuADMINS
  11. Configuração do servidorOpenMU

    OpenMU in Docker: how do I back up and restore the PostgreSQL database, and fix 'permission denied for schema config' after a restore?

    1. The openmu-db-backup container of nolt/openmu-docker runs pg_dump -Fc every BACKUP_INTERVAL seconds (default 86400), checks the dump and keeps gzipped files in ./backups/ for RETENTION...

    Reescrita da fonte pelo MuADMINSNot verifiedGitHub (nolt/openmu-docker) · 2026-10-24
  12. FerramentasWebZen 97d / 99b

    Cash Shop and VIP Editor (Dino): how to connect it to SQL Server and which columns it needs

    1. Enter the SQL Server IP, login, password and port, then click Connect. 2. Leave the filter empty to list all accounts, or type an account name. 3. Choose the VIP type and the amount of...

    Reescrita da fonte pelo MuADMINSNot verifiedImperyus Games Brasil · 2009-10-04
  13. Configuração do servidor0.97d

    Aminyuz 97d files: GameServer gives a conexion.ini connection error at start although all IPs are right (EventServer and Ranking open fine)

    The SQL login in the Aminyuz connection file was wrong. 1. Open C:\MuServer\Aminyuz\Conexion (the connection ini of these files). 2. In the [SQL] block set Usuario = sa (your SQL user), C...

    ✓ Confirmado pelo autor do tópicoTUServerMU · 2020-02-21
  14. Configuração do servidor

    Every time I leave the game my account is banned (after adding an anti-dupe ban script)

    The ban-dupers SQL script that was added to the database does not work with every version and bans normal accounts. 1. Remove that script (trigger / job) from the MuOnline database. 2. Un...

    ✓ Confirmado pelo autor do tópicoDarksTeam · 2010-01-05
  15. Configuração do servidor

    Players show online on the website after the server closed, or accounts stay "online" (MEMB_STAT.ConnectStat stuck at 1)

    How it works in every MSSQL files family we read (IGCN, MuEmu, Louis, MSPro, X-Team, MuDevs, WebZen): at login the server runs WZ_CONNECT_MEMB, which inserts or updates MEMB_STAT with Con...

    Not verifiedEscrito pelo MuADMINS
  16. Configuração do servidorIGCNS9, S12, S16, S17, S18

    How do I turn MD5 passwords on or off (enable / disable) on IGCN files (PasswordEncryptType, memb__pwd)?

    On IGCN files the password mode is chosen in the DataServer and the database column must be of the matching type. If they do not match, nobody can log in. 1. Close the whole server and ba...

    Not verifiedEscrito pelo MuADMINS
  17. FerramentasWebZen 97d / 99b97d-99

    MuEditor 2.1 (SkyTeam): how to set it up on another PC to edit the server database remotely (ODBC and DNS.ini)

    1. On the PC where you run MuEditor open Control Panel, Administrative Tools, Data Sources (ODBC). 2. In System DSN click Add, choose SQL Server: Name MuOnline, Description MuEditor, Serv...

    Reescrita da fonte pelo MuADMINSNot verifiedRaGEZONE · 2005-07-17
  18. Configuração do servidorMuEmu / LouisSeason 6 (Louis update 24)

    ODBC test works but JoinServer and DataServer still do not connect (Louis files on a VPS)

    The topic starter fixed it by reinstalling SQL Server: it was installed wrong. The helper's diagnosis was a named instance (SQLEXPRESS) while the files expect the default instance. 1. Ope...

    ✓ Confirmado pelo autor do tópicoTUServerMU · 2021-04-26
  19. Ferramentas

    MuWeb 0.8: accounts registered on the website say "Incorrect password" in game (the account count goes up)

    1. The website saves the password in a different format than the server expects: the MD5 option chosen in the MuWeb 0.8 install does not match your files. 2. Run the MuWeb 0.8 install aga...

    ✓ Confirmado pelo autor do tópicoRaGEZONE · 2008-04-17
  20. Configuração do servidorOpenMUS6E3

    OpenMu Client Babylon: how do I install my own OpenMU server with the browser client on a VPS?

    1. Use a VPS with Ubuntu 22.04+ or Debian 12+ (or Rocky/Alma 9) with at least 4 GB RAM and 30 GB disk; Windows 10/11 or Server 2022 also works. A domain is optional; with one, players get...

    Reescrita da fonte pelo MuADMINSNot verifiedGitHub (Ignies/OpenMu-Client-Babylon) · 2026-10-06

MuADMINS Community Alpha: grátis, feito pela comunidade e em desenvolvimento ativo.