Recent

Author Topic: "Server connect failed"  (Read 7686 times)

TheOddOne

  • Limited User (Deny Edit/Delete existing posts)
  • Jr. Member
  • *
  • Posts: 77
  • Hehe
    • SpawnScape614
"Server connect failed"
« on: November 27, 2014, 01:21:42 am »
Hi there, I'm using Lazarus 1.2.6 on a 64-bit system on Windows 7. My website uses MySQL 5.5 and I've spent days trying to sort the connection issue that I've been having problems with. So after sorting the libmySQL.dll problem, I've encountered another problem with when I try to connect and click on connected = true, it displays the message "Server connect failed". I've made sure that all of the credentials are correct for the connection. I've made sure that the firewall allows port 3306 and allows lazarus. I've made sure that my website accepts my remote ip address as well although I keep getting this error message. Here a screenshot:

http://i.imgur.com/0dhh1Nm.png

Have I done something wrong?
ShowMessage('Yes');

fredbrastux

  • New Member
  • *
  • Posts: 12
Re: "Server connect failed"
« Reply #1 on: November 27, 2014, 01:52:43 am »
First of all you need to know if your mysql database has permission for  remote and external access. It's not a lazarus issue. In your database use this sql command :  GRANT ALL ON *.* TO your_database_username@’%’ IDENTIFIED By ‘your_database_username_password’; 

Never

  • Sr. Member
  • ****
  • Posts: 409
  • OS:Win7 64bit / Lazarus 1.4
Re: "Server connect failed"
« Reply #2 on: November 27, 2014, 02:10:04 am »
Quote
Have I done something wrong?
yes you did
1) you delete the thread were 3 people contributed on your need
[http://forum.lazarus.freepascal.org/index.php/topic,26574.msg163567/topicseen.html ]
2) you have at least 2 niknames ThatGuyY / HelloWorld what is the porpouse of this?
i'll stop here about what you did wrong
i hope your age is under 12 other ways i can not see any excuses for your behaivor
Νέπε Λάζαρε λάγγεψων οξωκά ο φίλοσ'ς αραεύσε

TheOddOne

  • Limited User (Deny Edit/Delete existing posts)
  • Jr. Member
  • *
  • Posts: 77
  • Hehe
    • SpawnScape614
Re: "Server connect failed"
« Reply #3 on: November 27, 2014, 02:27:59 am »
Check your private messages please ^^.
ShowMessage('Yes');

TheOddOne

  • Limited User (Deny Edit/Delete existing posts)
  • Jr. Member
  • *
  • Posts: 77
  • Hehe
    • SpawnScape614
Re: "Server connect failed"
« Reply #4 on: November 27, 2014, 03:54:34 am »
First of all you need to know if your mysql database has permission for  remote and external access. It's not a lazarus issue. In your database use this sql command :  GRANT ALL ON *.* TO your_database_username@’%’ IDENTIFIED By ‘your_database_username_password’;

Oh wow, thanks I'll give it a try!
ShowMessage('Yes');

TheOddOne

  • Limited User (Deny Edit/Delete existing posts)
  • Jr. Member
  • *
  • Posts: 77
  • Hehe
    • SpawnScape614
Re: "Server connect failed"
« Reply #5 on: November 27, 2014, 04:08:14 am »
Thanks so much for your help. It was me placing the port number in the hostname, which is apparently unrequired. Thanks so much.
ShowMessage('Yes');

Never

  • Sr. Member
  • ****
  • Posts: 409
  • OS:Win7 64bit / Lazarus 1.4
Re: "Server connect failed"
« Reply #6 on: November 27, 2014, 12:38:33 pm »
Quote
Check your private messages please ^^
i just did
you been blocked and your other accounts as well
Νέπε Λάζαρε λάγγεψων οξωκά ο φίλοσ'ς αραεύσε

TheOddOne

  • Limited User (Deny Edit/Delete existing posts)
  • Jr. Member
  • *
  • Posts: 77
  • Hehe
    • SpawnScape614
Re: "Server connect failed"
« Reply #7 on: November 27, 2014, 01:45:01 pm »
No, the word is muted and blocked from you. Goodbye.
ShowMessage('Yes');

eny

  • Hero Member
  • *****
  • Posts: 1634
Re: "Server connect failed"
« Reply #8 on: November 27, 2014, 05:12:24 pm »
1) you delete the thread were 3 people contributed on your need
[http://forum.lazarus.freepascal.org/index.php/topic,26574.msg163567/topicseen.html ]
Remember the topic title by any chance?
Quote
2) you have at least 2 niknames ThatGuyY / HelloWorld what is the porpouse of this?
3 - 'Annoyed Chicken'
All posts based on: Win10 (Win64); Lazarus 2.0.10 'stable' (x64) unless specified otherwise...

Never

  • Sr. Member
  • ****
  • Posts: 409
  • OS:Win7 64bit / Lazarus 1.4
Re: "Server connect failed"
« Reply #9 on: November 27, 2014, 05:31:19 pm »
was something like 'can mysql connect?'
edit***: this is it [ Is Lazarus able to connect? - Free Pascal ]
edit2***: found the thread also cashed
edit3***:added attachment of the original thread saved with firefox
« Last Edit: November 27, 2014, 05:50:38 pm by Never »
Νέπε Λάζαρε λάγγεψων οξωκά ο φίλοσ'ς αραεύσε

 

TinyPortal © 2005-2018