Difference between revisions of "Lost Connection"
From TrueERP wiki
(3 intermediate revisions by one other user not shown) | |||
Line 18: | Line 18: | ||
[[Status and Type|Status and Type Screens]] | [[Status and Type|Status and Type Screens]] | ||
[[Units of Measure|Units of Measure]] | [[Units of Measure|Units of Measure]] | ||
− | </menu> | + | [[Updating]] |
+ | </menu> | ||
== Overview == | == Overview == | ||
Line 24: | Line 25: | ||
If you get this message box: This means your pc has lost connection to your server | If you get this message box: This means your pc has lost connection to your server | ||
− | [[Image:Lost1.JPG]] | + | [[Image:Lost1.JPG]] |
+ | |||
+ | <br> | ||
+ | |||
+ | You will then get this box - Click New and enter the name of your server <br>Click on Test which will give you a message confirming connection OK<br>Click Save<br> | ||
+ | |||
+ | <br> | ||
+ | |||
+ | [[Image:Lost2.jpg]]<br> | ||
+ | |||
+ | <br> | ||
+ | |||
+ | If the error keeps persisting the problem could be the server is going into sleep mode <br>- to fix this issue follow the steps below: | ||
+ | |||
+ | <br>Go to Start => Control Panel | ||
+ | |||
+ | Select System<br> | ||
+ | |||
+ | <br> | ||
+ | |||
+ | [[Image:Lost3.jpg]]<br> | ||
+ | |||
+ | Then select Hardware tab - then OK | ||
+ | |||
+ | [[Image:Lost4.jpg]]<br> | ||
+ | |||
+ | Then Select Device Manager then OK | ||
+ | |||
+ | <br> | ||
+ | |||
+ | [[Image:Lost5.jpg]]<br> | ||
+ | |||
+ | Expand the Network Adapters and double click on your controller or right mouse click then properties | ||
+ | |||
+ | <br> | ||
+ | |||
+ | [[Image:Lost6.jpg]]<br> | ||
+ | |||
+ | <br> | ||
+ | |||
+ | Select Power Management- Then OK<br> | ||
+ | |||
+ | <br> | ||
+ | |||
+ | [[Image:Lost7.jpg]]<br> | ||
+ | |||
+ | <br> | ||
+ | |||
+ | Now untick Allow the computer to turn off this device to save power then select ok<br> - this will now reset the computer network<br> | ||
+ | |||
+ | <br> | ||
+ | |||
+ | [[Image:Lost8.jpg]]<br> | ||
+ | |||
+ | <br> | ||
+ | |||
+ | Now also check the Fire wall connection - Go back to the Control Panel and select Windows<br>Firewall. | ||
+ | |||
+ | If the fire wall is turned off no action is required but we suggest you create the exceptions anyway. | ||
+ | |||
+ | <br> | ||
+ | |||
+ | [[Image:Lost9.jpg]]<br> | ||
+ | |||
+ | <br> | ||
+ | |||
+ | If Firewall is turned on then you will need to allow some exceptions - these exceptions are for<br>MySQL and ERP. | ||
+ | |||
+ | [[Image:Lost10.jpg]]<br> | ||
+ | |||
+ | <br> | ||
+ | |||
+ | If the ports are not already there then you will need to create them by selecting Add Port.<br>Create Port Number 3309 for ERP<br>and Port Number 3310 for MySQL as follows | ||
+ | |||
+ | [[Image:Lost11.jpg]]<br> | ||
+ | |||
+ | <br>Next if required | ||
+ | |||
+ | Right mouse click in the middle of your screen and select properties - then select Screen Saver<br> | ||
+ | |||
+ | <br> | ||
+ | |||
+ | [[Image:Lost13.jpg]]<br> | ||
+ | |||
+ | <br> | ||
+ | |||
+ | Then go into Power management | ||
+ | |||
+ | [[Image:Lost14.jpg]]<br> | ||
+ | |||
+ | Ensure that the Hardrives do not turn off, but ensure you have a screen saver active.<br> | ||
+ | |||
+ | <br> | ||
+ | |||
+ | [[Image:Lost15.jpg]]<br> | ||
+ | |||
+ | Lastly go into Start =>Control Panel and if you have any Virus scans running ensure the firewall settings <br>have also been given exceptions to Port 3309 and 3310 | ||
+ | |||
+ | Now go to your ERP icon and open up the programe if the following message box appears select Reconnect | ||
+ | |||
+ | <br> | ||
+ | |||
+ | <br> | ||
+ | |||
+ | Ensuring that all the databases are on the same Version. If any are in brackets the user version does not <br>match the server and will require updating. <br> | ||
+ | |||
+ | [[Image:Lost17.jpg]]<br> | ||
+ | |||
+ | <br> | ||
+ | |||
+ | How to test all is working go to Start=>explore=>Programe Files=> ERP Software=>Connection.ini | ||
+ | |||
+ | <br> | ||
+ | |||
+ | All server names should be the same<br> | ||
+ | |||
+ | [[Image:Lost19.jpg]]<br> | ||
+ | |||
+ | If they are not then the error message will appear again so you need to ensure you have the <br>Correct computer/server name | ||
+ | |||
+ | <br> | ||
+ | |||
+ | [[Image:Lost16.jpg]]<br> | ||
+ | |||
+ | <br> | ||
+ | |||
+ | Go to Start =>my computer double click or Right mouse click to select System Properties[[Image:Lost21.JPG]] | ||
+ | |||
+ | <br> | ||
+ | |||
+ | Full computer/server name is what is important | ||
+ | |||
+ | <br> | ||
+ | |||
+ | <br> | ||
+ | |||
+ | <br> | ||
+ | |||
+ | Once you have this you can go Start=> Run. Type in cmd (command) and click OK | ||
+ | |||
+ | [[Image:Lost23.jpg]]<br> | ||
+ | |||
+ | <br> | ||
+ | |||
+ | Now enter ping space name of the server<br>Then you should see the the reply which will show that the network is working | ||
+ | |||
+ | [[Image:Lost24.jpg]]<br> | ||
+ | |||
+ | If you get this message, due to the name not being correct, this means the network is not working | ||
+ | |||
+ | Now recheck the connection ini file<br>Start =>c;drive=>programe files=>ERP=> connection ini | ||
+ | |||
+ | <br> | ||
+ | |||
+ | [[Image:Lost27.jpg]]<br> | ||
+ | |||
+ | To ensure this name is correct - on the server go to Start=>c:drive=>mysql=>data<br>highlight the name eg sample_company, right mouse click and select rename, then<br>Control C (to copy) | ||
+ | |||
+ | <br> | ||
+ | |||
+ | [[Image:Lost26.JPG]]<br> | ||
+ | |||
+ | <br> | ||
+ | |||
+ | Go back to the connection ini and highlight the Database name and select Control V<br>(Paste) to ensure the correct name has been selected | ||
+ | |||
+ | <br> | ||
+ | |||
+ | [[Image:Lost27.jpg]]<br> | ||
+ | |||
+ | <br> | ||
+ | |||
+ | You will now be able to connect to ERP | ||
+ | |||
+ | <br> | ||
+ | |||
+ | <br> | ||
+ | |||
+ | <br> | ||
+ | |||
+ | <br> | ||
+ | |||
+ | <br> | ||
+ | |||
+ | <br> | ||
+ | |||
+ | <br> | ||
[[Image:Lost1.jpg]] | [[Image:Lost1.jpg]] |
Latest revision as of 10:58, 9 May 2011
Overview
If you get this message box: This means your pc has lost connection to your server
You will then get this box - Click New and enter the name of your server
Click on Test which will give you a message confirming connection OK
Click Save
If the error keeps persisting the problem could be the server is going into sleep mode
- to fix this issue follow the steps below:
Go to Start => Control Panel
Select System
Then select Hardware tab - then OK
Then Select Device Manager then OK
Expand the Network Adapters and double click on your controller or right mouse click then properties
Select Power Management- Then OK
Now untick Allow the computer to turn off this device to save power then select ok
- this will now reset the computer network
Now also check the Fire wall connection - Go back to the Control Panel and select Windows
Firewall.
If the fire wall is turned off no action is required but we suggest you create the exceptions anyway.
If Firewall is turned on then you will need to allow some exceptions - these exceptions are for
MySQL and ERP.
If the ports are not already there then you will need to create them by selecting Add Port.
Create Port Number 3309 for ERP
and Port Number 3310 for MySQL as follows
Next if required
Right mouse click in the middle of your screen and select properties - then select Screen Saver
Then go into Power management
Ensure that the Hardrives do not turn off, but ensure you have a screen saver active.
Lastly go into Start =>Control Panel and if you have any Virus scans running ensure the firewall settings
have also been given exceptions to Port 3309 and 3310
Now go to your ERP icon and open up the programe if the following message box appears select Reconnect
Ensuring that all the databases are on the same Version. If any are in brackets the user version does not
match the server and will require updating.
How to test all is working go to Start=>explore=>Programe Files=> ERP Software=>Connection.ini
All server names should be the same
If they are not then the error message will appear again so you need to ensure you have the
Correct computer/server name
Go to Start =>my computer double click or Right mouse click to select System Properties
Full computer/server name is what is important
Once you have this you can go Start=> Run. Type in cmd (command) and click OK
Now enter ping space name of the server
Then you should see the the reply which will show that the network is working
If you get this message, due to the name not being correct, this means the network is not working
Now recheck the connection ini file
Start =>c;drive=>programe files=>ERP=> connection ini
To ensure this name is correct - on the server go to Start=>c:drive=>mysql=>data
highlight the name eg sample_company, right mouse click and select rename, then
Control C (to copy)
Go back to the connection ini and highlight the Database name and select Control V
(Paste) to ensure the correct name has been selected
You will now be able to connect to ERP