-
Contributor
Originally Posted by
daverrion
yes using whats in the world conf and in the mysql table database on heidisql also tried 127.0.0.1 user root pass test like on the front page both allows me to connect to heidisql and have full access to the database
but WDBX editor will not Connect to this mysql using the right info
it does when i fully close down this server and connect say my mop server running mysql 5.5.9
from what i can tell looking on the web with the error log mysql community started using a new version of tls or ssl to encrypt/secure connections from version 8xx on
thats why its giving a
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.Security.Authentication.AuthenticationException: A call to SSPI failed, see inner exception. ---> System.ComponentModel.Win32Exception: The message received was unexpected or badly formatted
--- End of inner exception stack trace ---
at System.Net.Security.SslState.StartSendAuthResetSignal(ProtocolToken message, AsyncProtocolRequest asyncRequest, Exception exception)
at System.Net.Security.SslState.CheckCompletionBeforeNextReceive(ProtocolToken message, AsyncProtocolRequest asyncRequest)
at System.Net.Security.SslState.StartSendBlob(Byte[] incoming, Int32 count, AsyncProtocolRequest asyncRequest, Boolean renegotiation)
at System.Net.Security.SslState.ProcessReceivedBlob(Byte[] buffer, Int32 count, AsyncProtocolRequest asyncRequest)
at System.Net.Security.SslState.StartReadFrame(Byte[] buffer, Int32 readBytes, AsyncProtocolRequest asyncRequest)
at System.Net.Security.SslState.StartReceiveBlob(Byte[] buffer, AsyncProtocolRequest asyncRequest)
at System.Net.Security.SslState.CheckCompletionBeforeNextReceive(ProtocolToken message, AsyncProtocolRequest asyncRequest)
at System.Net.Security.SslState.StartSendBlob(Byte[] incoming, Int32 count, AsyncProtocolRequest asyncRequest, Boolean renegotiation)
at System.Net.Security.SslState.ForceAuthentication(Boolean receiveFirst, Byte[] buffer, AsyncProtocolRequest asyncRequest, Boolean renegotiation)
at System.Net.Security.SslState.ProcessAuthentication(LazyAsyncResult lazyResult)
at System.Net.Security.SslStream.AuthenticateAsClient(String targetHost, X509CertificateCollection clientCertificates, SslProtocols enabledSslProtocols, Boolean checkCertificateRevocation)
at MySql.Data.MySqlClient.NativeDriver.StartSSL()
at MySql.Data.MySqlClient.NativeDriver.Open()
at MySql.Data.MySqlClient.Driver.Open()
at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
at MySql.Data.MySqlClient.MySqlPool.GetConnection()
at MySql.Data.MySqlClient.MySqlConnection.Open()
at WDBXEditor.LoadSQL.btnRefresh_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
also on of the websites i visited said i can use a my.ini or my.cfg to disable ssl but i dont have that file anywhere
It's because the repack uses a portable version of mysql. I never had to edit that file so your best bet is search the net or ask a LLM on how to create/use that file with a portable mysql.
-
Contributor
Originally Posted by
icore2
Hi, do you have a sql thread to restore the honor vendors in old town?
Nope. What do you mean by old town?
-
Member
In Old town , Stormwind city, where you can buy pvp gear by honor. Btw yesterday tested the repack many vendor broke cause individual, rogue poisone, regaens vendors etc etc
-
Contributor
Originally Posted by
icore2
In Old town , Stormwind city, where you can buy pvp gear by honor. Btw yesterday tested the repack many vendor broke cause individual, rogue poisone, regaens vendors etc etc
Does this happen with old versions of the repack?
-
Member
Hi there, and thank you for the awesome repack.
While running the worldserver, I keep seeing the following message:
SmartScript::ProcessAction: Entry 18945 SourceType 0, Event 3, Link Event 4 not found or invalid, skipped.
However, when I check the smart_scripts table, I can confirm that both Event ID 3 and the linked Event ID 4 do exist for Entry 18945. This makes me think it may be a false warning or a logging issue in the core.
Would it be possible to:
Suppress this log in future versions if the linked event exists?
Or clarify whether this message has any actual impact on game behavior?
Thanks in advance for any clarification or fix!
-
Contributor
Originally Posted by
aromy
Hi there, and thank you for the awesome repack.
While running the worldserver, I keep seeing the following message:
SmartScript::ProcessAction: Entry 18945 SourceType 0, Event 3, Link Event 4 not found or invalid, skipped.
However, when I check the smart_scripts table, I can confirm that both Event ID 3 and the linked Event ID 4 do exist for Entry 18945. This makes me think it may be a false warning or a logging issue in the core.
Would it be possible to:
Suppress this log in future versions if the linked event exists?
Or clarify whether this message has any actual impact on game behavior?
Thanks in advance for any clarification or fix!
This has been reported to the azerothcore github. It has no impact in my experience.
-
Member
Do you check in playerbot config don't have option playerbot join to arena, only you can set how much arena teams join and total arena team / bracet count
-
Member
-
Post Thanks / Like - 1 Thanks
Aldebaraan (1 members gave Thanks to x77x for this useful post)
-
Member
Originally Posted by
Aldebaraan
Since you cannot get it to work use this powershell code:
Code:
#Using a Timer in the Script
$stopwatch = [System.Diagnostics.Stopwatch]::StartNew()
$SourceDirectory = "E:\Games\WoW Server Files"
$RepackDirectory = "L:"
# Define the source directory to copy
$sourceFile = "$SourceDirectory\Azerothcore WoTLK Repack (Playerbots + Individual Progression) 11-02-2025.7z"
$sourceDataFiles = "$SourceDirectory\AC Data v16 enUS.7z"
$UpdateFiles = "$SourceDirectory\Update Individual Progression 2025-04-21.7z"
Write-Host "Extracting files..."
#Full repack
7z x $sourceFile -o"$RepackDirectory" -y
Write-Host "Extracting data files..."
#datafiles
7z x $sourceDataFiles -o"$RepackDirectory\Azerothcore WoTLK Repack (Playerbots + Individual Progression)" -y
Write-Host "Extracting update files..."
#Update
7z x $UpdateFiles -o"$RepackDirectory\Azerothcore WoTLK Repack (Playerbots + Individual Progression)" -y
$stopwatch.Stop()
Write-Host "Done in $($stopwatch.Elapsed.TotalSeconds) seconds."
pause
Create a folder and add the full repack, data and update files to it. Then set $SourceDirectory to it. $RepackDirectory is the folder you want the repack folder to be in.
You need powershell 7 and 7zip installed and in PATH for this script to work. I tested it and the repack boots fine and it's fully updated.
Here's the code for the repack without individual progression:
Code:
#Using a Timer in the Script
$stopwatch = [System.Diagnostics.Stopwatch]::StartNew()
$SourceDirectory = "E:\Games\WoW Server Files"
$RepackDirectory = "L:"
# Define the source directory to copy
$sourceFile = "$SourceDirectory\Azerothcore WoTLK Repack (Playerbots) 11-02-2025.7z"
$sourceDataFiles = "$SourceDirectory\AC Data v16 enUS.7z"
$UpdateFiles = "$SourceDirectory\Update Playerbots 2025-04-20.7z"
Write-Host "Extracting files..."
#Full repack
7z x $sourceFile -o"$RepackDirectory" -y
Write-Host "Extracting data files..."
#datafiles
7z x $sourceDataFiles -o"$RepackDirectory\Azerothcore WoTLK Repack (Playerbots)" -y
Write-Host "Extracting update files..."
#Update
7z x $UpdateFiles -o"$RepackDirectory\Azerothcore WoTLK Repack (Playerbots)" -y
$stopwatch.Stop()
Write-Host "Done in $($stopwatch.Elapsed.TotalSeconds) seconds."
pause
One thing, why is this happening now? It didn't before. I even reset my pc(I had nothing special on it) and tried it from scratch and it did the same thing. I am gonna try the Powershell stuff but do you think its a problem with the files or did something happen to my pc itself? If its the latter I am legitmately impressed in my skill to mess up like this.
-
Contributor
Originally Posted by
raiderjoseph
One thing, why is this happening now? It didn't before. I even reset my pc(I had nothing special on it) and tried it from scratch and it did the same thing. I am gonna try the Powershell stuff but do you think its a problem with the files or did something happen to my pc itself? If its the latter I am legitmately impressed in my skill to mess up like this.
I did not alter the files so it's probably a problem with your pc. Make sure to check the appdata temp folder. Maybe some files extracted are getting stuck there.
-
Contributor
Originally Posted by
icore2
Do you check in playerbot config don't have option playerbot join to arena, only you can set how much arena teams join and total arena team / bracet count
You have to ask the playerbots devs to add that to you.
-
Member
Originally Posted by
Aldebaraan
I did not alter the files so it's probably a problem with your pc. Make sure to check the appdata temp folder. Maybe some files extracted are getting stuck there.
The thing is, a whim I downloaded the older version, the second most recent, and it works. I believe you by the way, I just have no idea how this works.
-
Post Thanks / Like - 1 Thanks
Aldebaraan (1 members gave Thanks to raiderjoseph for this useful post)
-
Member
co commands
anyone figured out the co commands heres what i have tried
/whisper charname co -tank assist,+unholy,-blood,-tank face,+behind
as well as some others i didnt mention
none of witch is giving the desired effect
dk still has blood presence tank assist and tank face and has the quite annoying habit of no matter what i cast event spell id 41602 with adds a whopping 900000 threat to the target and is spammable theres no reason he should be tanking at all
must be using a force target me effect witch gos back to combat orders?
its not adding the attack behind
multibot addon seems to work somewhat but doent have all the stratts
i have to config that every time i summon bots 25 times? no thank you lol if i can id rather use a macro
basically want all bots to dps unless there heals
thanks
-
Member
never mind I'm stupid didn't know you have to enter/exit combat did so its working now=p
but is there a strat that will make the bot tank but keep its hate below mine ie offtank?
Last edited by daverrion; 05-10-2025 at 03:33 AM.
-
Contributor
Originally Posted by
daverrion
never mind I'm stupid didn't know you have to enter/exit combat did so its working now=p
but is there a strat that will make the bot tank but keep its hate below mine ie offtank?
You better ask questions about bots in the playerbot discord. They have the technical knowledge about these things.