[SOLVED] Trouble connecting to Server Database..

[xMoonlightx]

=======================================================================

Hi.
I'm having rather a spot of bother, :huh:
I was wondering if anyone could help.

=======================================================================

I've got my server up and running, almost.. all is well.:glare:

I used ¤ The Complete PW Package ¤ to set up my server..

Probelm is that I can't connect to the server files, I've tried using WinSCP, FileZilla and Navicat.
I've been entering the correct login details and such, but I can't connect using WinSCP or FileZilla.

On WinSCP I've had two different errors, but the one I have now is this one;
"Network error: Software caused connection abort."
Before that error I had something like; Could not connect to server.

=======================================================================

On FileZilla I've also had one or two different errors..

"Status: Connecting to XXX.XXX.XXX.XXX...
Response: fzSftp started
Command: open "pwAdmin@XXX.XXX.XXX.XXX" 22
Error: Network error: Software caused connection abort
Error: Could not connect to server
Status: Waiting to retry..."

I tried using port 3306 too (I'm a rookie - I'll try anything)

"Status: Connecting to XXX.XXX.XXX.XXX:3306...
Response: fzSftp started
Command: open "pwAdmin@XXX.XXX.XXX.XXX" 3306
Error: Server unexpectedly closed network connection
Error: Could not connect to server"

I've also tried all possible login combinations using 343's ¤ The Complete PW Package ¤ guide.

=======================================================================

I've added both WinSCP and FileZilla to my Firewall Exceptions,
Though I didn't need to add NaviCat, as it worked well.


However..
I can connect using Navicat, Though if using Navicat. I can't see or access the files I need to update,
I can see a bunch of files, but they're not the ones I'm looking to update. :/:
In other words I don't see any PWServer folder, or anything related.

I've searched the forums, and have found that someone else had the same issue here.
I've both possible solutions, but to no joy. :*:

I actually wanted to just edit the gshop data, as I'm also having this error.
Plus the fact..
That you should naturally be able to access the server's database whenever you need to anyway, right?

=======================================================================

Any suggestions?
Any that a rookie, would understand.. should I say?

=======================================================================

 

[leonara]

Re: [HELP] Trouble connecting to Server Database..

but I can't connect using WinSCP or FileZilla.

The Answer ::: Change Your Ip
With This Command :: nano /etc/network/interfaces and then restart

And to Check The Port Use This :: nano /etc/ssh/sshd_config
For Install ssh server use this # apt-get install openssh-server

 

[xMoonlightx]

Re: [HELP] Trouble connecting to Server Database..

The Answer ::: Change Your Ip
With This Command :: nano /etc/network/interfaces and then restart

And to Check The Port Use This :: nano /etc/ssh/sshd_config
For Install ssh server use this # apt-get install openssh-server

I use the command "nano /etc/network/interfaces" but I don't see what I need to change..

I also used the "nano /etc/ssh/sshd_config" command, even though I typed in exactly what you said. It just came up blank.

I tried the "apt-get install openssh-server" command, but openssh was already installed and up-to-date.

I didn't modify anything on the "nano /etc/network/interfaces" screen, I don't understand how to change the IP. Though the LAN IP almost always changes everytime I restart my main PC.

What should I do? :ehh:

 

[Romulan]

Re: [HELP] Trouble connecting to Server Database..

Stop your vbox machine.
Check the network configuration tab for your vbox.
Set it to bridged mode and select the network card of your computer.
Start your vbox.

Type in console:
nano /etc/network/interfaces

Change:

iface eth0 inet dhcp

To:

iface eth0 inet static
address 192.168.1.50
network 192.168.1.0
netmask 255.255.255.0
broadcast 192.168.1.255
gateway 192.168.1.1

Ctrl+X (to exit) and choose Yes (press simply Y...)

Type in console:
/etc/init.d/networking restart

Tada! Your network configuration is now working. Enjoy!

PS: Your server have now a static ip (192.168.1.50), use it to connect to your server with navicat, filezilla, etc...

PS2: You should learn a bit on linux and basic networking also...

 

[xMoonlightx]

Re: [HELP] Trouble connecting to Server Database..

Stop your vbox machine.
Check the network configuration tab for your vbox.
Set it to bridged mode and select the network card of your computer.
Start your vbox.

Type in console:
nano /etc/network/interfaces

Change:


To:


Ctrl+X (to exit) and choose Yes (press simply Y...)

Type in console:
/etc/init.d/networking restart

Tada! Your network configuration is now working. Enjoy!

PS: Your server have now a static ip (192.168.1.50), use it to connect to your server with navicat, filezilla, etc...

PS2: You should learn a bit on linux and basic networking also...

Thank You!
That's that problem solved.. well sort of anyway. :/:
I've done everything you said, and reconfigured the server LAN IP files along with the client LAN IP and saved them.

But..
Even though the software error has stopped, I still can't connect to the database. :huh:
I've tried NaviCat, WinSCP & FileZilla.. None of which can connect to my database. :/:
Along with the issue that I can no longer connect to iWeb either. :*:

Spoiler

NaviCat

WinSCP

FileZilla

iWeb

VBox

Did I miss something? :?:

 

[Romulan]

Re: [HELP] Trouble connecting to Server Database..

Ok... what's your ip config on your computer?

 

[xMoonlightx]

Re: [HELP] Trouble connecting to Server Database..

Untouched as far as I can tell..
Did a complete reinstallation of Windows 7 to see if this problem would still occur.
Here's the configuration screenshots..

Spoiler

LAN Configurations..

 

[Romulan]

Re: [HELP] Trouble connecting to Server Database..

I see lol ... Your network is 192.168.0.0 and not 192.168.1.0, so simply change the config in "/etc/network/interfaces" :

Old:

iface eth0 inet static
address 192.168.1.50
network 192.168.1.0
netmask 255.255.255.0
broadcast 192.168.1.255
gateway 192.168.1.1

New:

iface eth0 inet static
address 192.168.0.50
network 192.168.0.0
netmask 255.255.255.0
broadcast 192.168.0.255
gateway 192.168.0.1

 

[xMoonlightx]

Re: [HELP] Trouble connecting to Server Database..

Thanks again. :
Believe it or not..
I've hit another brick wall. Doubt I'll ever have a working Perfect World Server at this rate.:/:

I typed in ifconfig eth0 as usual, only this time it came up with an error: "Device not found". Then I typed it just ifconfig and it was only displaying Local Loopback IP and such.

Checked the Network Adapter, but it's still the same as it was before (Bridged Adapter & Host-only Adapter)

Think I'll create another virtual machine and start over..

 

[Romulan]

Re: [HELP] Trouble connecting to Server Database..

Create another virtual machine with Bridged Adapter ONLY... Reconfigure everything (network and stuff)... and come back with good news!

 

[xMoonlightx]

Re: [HELP] Trouble connecting to Server Database..

Create another virtual machine with Bridged Adapter ONLY... Reconfigure everything (network and stuff)... and come back with good news!

Good news, yes..
I can use WinSCP to connect.. partially.

Searching for host..
Connecting to host..
Authenticating..
Using username "pwAdmin".
Authenticating with pre-entered password..
Access denied.

I did everything you said in the previous posts..
I've installed openssh-server and have added rules using: ufw allow 22, ufw allow from XXX.XXX.XXX.XXX and ufw allow from XXX.XXX.XXX to any port 22.
But that didn't help.

Like before.. I can login using NaviCat on MySQL, but the game database files aren't there.

 

[Romulan]

Re: [HELP] Trouble connecting to Server Database..

WinSCP... Uses the same login/password that you use to connect on the server console... lol! SSH stands for Secure Shell ... It allow you to remotely access to your server to do stuff on it.

Same thing if you use a remote ssh client... (ie: putty).

Ah! And if it's a local test server... you don't need any firewall thingy for it... Unless you have doubt about your brother/friend that could do things that could harm your server lol.

 

[xMoonlightx]

Re: [HELP] Trouble connecting to Server Database..

WinSCP... Uses the same login/password that you use to connect on the server console... lol! SSH stands for Secure Shell ... It allow you to remotely access to your server to do stuff on it.

It does? :blink:
Thank You so much! It works. :laugh:
I didn't know that it was your virtual machine/server's username and password.

I have so much to learn.. :/:

 

[343]

I'm glad to hear your problem has been resolved (I will now close the thread) :