Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 463
  • Last Modified:

MySql connecting to dataabse problem

I have installed MySql 5.1 on a server and imported a database. When a client PC tries to connect to the database the below log is writen. Is there any-one that can help with the
error. If i run the program locally to the server it works.

        Exception: System.Net.Sockets.SocketException: A request to send or receive data was disallowed because the socket is not connected and (when sending on a datagram socket using a sendto call) no address was supplied
   at System.Net.Sockets.Socket.Shutdown(SocketShutdown how)
   at MySql.Data.Common.SocketStream.Read(Byte[] buffer, Int32 offset, Int32 count)
   at System.IO.BufferedStream.ReadByte()
   at MySql.Data.MySqlClient.PacketReader.ReadHeader()
   at MySql.Data.MySqlClient.PacketReader.OpenPacket()
   at MySql.Data.MySqlClient.NativeDriver.Open()
   at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
   at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
   at MySql.Data.MySqlClient.MySqlPool.GetConnection()
   at MySql.Data.MySqlClient.MySqlPoolManager.GetConnection(MySqlConnectionString settings)
   at MySql.Data.MySqlClient.MySqlConnection.Open()
   at Chillisoft.Db.v2.DatabaseConnection.GetOpenConnectionForReading()
        Stacktrace:    at System.Net.Sockets.Socket.Shutdown(SocketShutdown how)
   at MySql.Data.Common.SocketStream.Read(Byte[] buffer, Int32 offset, Int32 count)
   at System.IO.BufferedStream.ReadByte()
   at MySql.Data.MySqlClient.PacketReader.ReadHeader()
   at MySql.Data.MySqlClient.PacketReader.OpenPacket()
   at MySql.Data.MySqlClient.NativeDriver.Open()
   at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
   at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
   at MySql.Data.MySqlClient.MySqlPool.GetConnection()
   at MySql.Data.MySqlClient.MySqlPoolManager.GetConnection(MySqlConnectionString settings)
   at MySql.Data.MySqlClient.MySqlConnection.Open()
   at Chillisoft.Db.v2.DatabaseConnection.GetOpenConnectionForReading()
2010-09-17 16:32:46,637 [3536] ERROR Chillisoft.Db.v2.DatabaseConnection [] - Error reading from database :
          Exception: System.Net.Sockets.SocketException: A request to send or receive data was disallowed because the socket is not connected and (when sending on a datagram socket using a sendto call) no address was supplied
   at Chillisoft.Db.v2.DatabaseConnection.GetOpenConnectionForReading()
   at Chillisoft.Db.v2.DatabaseConnection.LoadDataReader(ISqlStatement selectSQL)
          Stacktrace:    at Chillisoft.Db.v2.DatabaseConnection.GetOpenConnectionForReading()
   at Chillisoft.Db.v2.DatabaseConnection.LoadDataReader(ISqlStatement selectSQL)
2010-09-17 16:32:46,637 [3536] ERROR Chillisoft.Db.v2.DatabaseConnection [] - Sql: Raw statement: select SettingValue from tbnumbers where SettingName = ?Param0   , Parameter values: InvoiceNumber,
2010-09-17 16:32:46,637 [3536] ERROR Kwanalu.MainForm [] - Exception: There was an error reading the database.
 Please contact your system administrator.
The DataReader could not be filled with
Raw statement: select SettingValue from tbnumbers where SettingName = ?Param0   , Parameter values: InvoiceNumber,
Stacktrace:    at Chillisoft.Db.v2.DatabaseConnection.LoadDataReader(ISqlStatement selectSQL)
   at Chillisoft.Db.v2.DatabaseNumberGenerator..ctor(String settingName, String tableName, Int32 seedValue)
   at Chillisoft.Db.v2.DatabaseNumberGenerator..ctor(String settingName, String tableName)
   at Chillisoft.Db.v2.DatabaseNumberGenerator..ctor(String settingName)
   at Kwanalu.Program.Main()
        Inner Exception:
        Exception: System.Net.Sockets.SocketException: A request to send or receive data was disallowed because the socket is not connected and (when sending on a datagram socket using a sendto call) no address was supplied
   at Chillisoft.Db.v2.DatabaseConnection.GetOpenConnectionForReading()
   at Chillisoft.Db.v2.DatabaseConnection.LoadDataReader(ISqlStatement selectSQL)
        Stacktrace:    at Chillisoft.Db.v2.DatabaseConnection.GetOpenConnectionForReading()
   at Chillisoft.Db.v2.DatabaseConnection.LoadDataReader(ISqlStatement selectSQL)
0
PaulMcDonogh1
Asked:
PaulMcDonogh1
  • 2
1 Solution
 
wolfgang_93Commented:
Did you run the client program without needing to change it -- and it worked?

From that I deduce that you have configured the MySQL connecting setting
to be "localhost" and the default port of "3306".

Replace "localhost" with the actual IP address of the server you are accessing.

What MySQL id were you trying to connect to? If it is "root", the default is to
allow connection to it only from localhost.
0
 
PaulMcDonogh1Author Commented:
Found out there was a ini file that needed o be configured in a Hubenero clinet app
0
 
PaulMcDonogh1Author Commented:
there have been no answers to this and had to hack the solution myself
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now