Comments (4)
gabiudrescu
commented on July 23, 2024
PS: I have edited the screenshots to mask some sensible information; I am connecting to the MySQL server over a SSH tunnel.
from querytree.
gabiudrescu
commented on July 23, 2024
I rebuild the container to make sure I am using latest dev-master and ran it without the -d option and I have the following logs:
fail: Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddleware[0]
An unhandled exception has occurred: Fatal error encountered during command execution.
MySql.Data.MySqlClient.MySqlException (0x80004005): Fatal error encountered during command execution. ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Fatal error encountered attempting to read the resultset. ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Reading from the stream has failed. ---> System.IO.IOException: Unable to read data from the transport connection: Connection timed out. ---> System.Net.Sockets.SocketException: Connection timed out
at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
--- End of inner exception stack trace ---
at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
at MySql.Data.MySqlClient.TimedStream.Read(Byte[] buffer, Int32 offset, Int32 count)
at MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count)
at MySql.Data.MySqlClient.MySqlStream.LoadPacket()
at MySql.Data.MySqlClient.MySqlStream.LoadPacket()
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at QueryTree.Managers.DbManager.GetDbModel(DatabaseType type, DbConnection conn, Int32 connectionId, String databaseName) in /build/Web/Managers/DbManager.cs:line 227
at QueryTree.Managers.DbManager.<>c__DisplayClass5_0.<GetDbModel>b__0(DbConnection dbConn) in /build/Web/Managers/DbManager.cs:line 134
at QueryTree.Managers.DbManager.<>c__DisplayClass12_0.<TryUseDbConnection>b__0(SSHProxy proxy) in /build/Web/Managers/DbManager.cs:line 557
at QueryTree.Managers.SSHProxyManager.UseProxy(SSHProxy proxy, Action`1 action) in /build/Web/Managers/SSHProxyManager.cs:line 37
at QueryTree.Managers.SSHProxyManager.TryUseProxy(String server, Int32 port, String sshServer, Int32 sshPort, SshProxyCredentials credentials, Action`1 action, String& error) in /build/Web/Managers/SSHProxyManager.cs:line 93
at QueryTree.Managers.DbManager.TryUseDbConnection(DatabaseType type, String server, Int32 port, Boolean useSsh, String sshServer, Nullable`1 sshPort, SshProxyCredentials credentials, String username, String password, String databaseName, Action`1 action, String& error) in /build/Web/Managers/DbManager.cs:line 578
at QueryTree.Managers.DbManager.TryUseDbConnection(DatabaseConnection connection, Action`1 action, String& error) in /build/Web/Managers/DbManager.cs:line 540
at QueryTree.Managers.DbManager.GetDbModel(DatabaseConnection connection) in /build/Web/Managers/DbManager.cs:line 136
at QueryTree.Controllers.ApiController.GetTables(Int32 databaseId) in /build/Web/Controllers/ApiController.cs:line 164
at lambda_method(Closure , Object , Object[] )
at Microsoft.Extensions.Internal.ObjectMethodExecutor.Execute(Object target, Object[] parameters)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.<InvokeActionMethodAsync>d__12.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.<InvokeNextActionFilterAsync>d__10.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Rethrow(ActionExecutedContext context)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.<InvokeInnerFilterAsync>d__14.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.<InvokeNextResourceFilter>d__22.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Rethrow(ResourceExecutedContext context)
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.<InvokeFilterPipelineAsync>d__17.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.<InvokeAsync>d__15.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.AspNetCore.Builder.RouterMiddleware.<Invoke>d__4.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.AspNetCore.Builder.Extensions.MapMiddleware.<Invoke>d__3.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.<Invoke>d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddleware.<Invoke>d__6.MoveNext()
maybe it helps.
from querytree.
PandelisZ
commented on July 23, 2024
Docker creates its own internal network when running within it. Localhost would be used as a lopback to itself not your pc's network.
Is MYSQL exposed on your host computer at 3306? If so using localhost in the setting wont work from within docker.
If on windows you could try docker.for.win.localhost which should loop back to your host. On mac its docker.for.mac.localhost
Related forum post: https://forums.docker.com/t/accessing-host-machine-from-within-docker-container/14248
That's what I can tell from your current configuration for now. Please let me know if that's the case.
from querytree.
stale
commented on July 23, 2024
This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.
from querytree.
Related Issues (20)
- All columns from all tables in filter dropdowns instead of only selected columns HOT 1
- hostpolicy.dll is missing HOT 1
- cannot connect to either mysql or sql express on my PC HOT 1
- Can't see the option to use Advanced Reporting HOT 1
- Write my own sql Queries HOT 1
- Error during connectin to PostgreSQL: SSL is required HOT 2
- postgresql connection strings: support "sslmode" parameter HOT 1
- New tables/Views added to database not showing HOT 2
- Cannot install QueryTree from source HOT 1
- "No tables found" in PostgreSQL connection HOT 6
- Team Invite post failing with 404 error HOT 1
- Caution using this in production - scheduled emails creates many long running queries HOT 1
- Multi tenant situation HOT 2
- Advanced report builder is missing, no link displayed next to simple report builder header. HOT 1
- how to deploy query tree HOT 2
- how to integrate/embeded it into existing app (angular 14)
- QueryTree dotnet version update in Dockerfile breaks invitation HOT 1
- Scheduled reports error on save HOT 2
- Querytree
- QueryTree Documentation Empty - No content displayed
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from querytree.