Lost SSH Connection During The Upgrade Process
May 11, 2008if i lost SSH connection during the upgrade process, ie. apache upgrade
will this have any impact?
if i lost SSH connection during the upgrade process, ie. apache upgrade
will this have any impact?
MySQL Error : Lost connection to MySQL server during query
I get this error around 10 times a day and the MySQL server goes down
Here are my.cnf contents
Quote:
[mysqld]
safe-show-database
old_passwords
back_log = 75
skip-innodb
max_connections = 650
key_buffer = 48M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 3000
thread_cache_size = 128
wait_timeout = 90
connect_timeout = 10
tmp_table_size = 64M
max_heap_table_size = 64M
max_allowed_packet = 64M
net_buffer_length = 16384
max_connect_errors = 10
thread_concurrency = 4
read_rnd_buffer_size = 786432
bulk_insert_buffer_size = 8M
query_cache_limit = 3M
query_cache_size = 48M
query_cache_type = 1
query_prealloc_size = 262144
query_alloc_block_size = 65536
transaction_alloc_block_size = 8192
transaction_prealloc_size = 4096
default-storage-engine = MyISAM
[mysqld_safe]
nice = -5
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
[mysqlhotcopy]
interactive-timeout
some vBulletin customers facing to that error message, with session table with attachment only. Other just work fine. It's not because of server load. The load is just around 0 - 0.1
I have increased wait_timeout to 200 and max_allowed_packet to 64MB. Each attachment file in those vBulletin is just around 1-3MB.
Is there any idea why and how to fix?
We have recently had an IT guy perforn the upgrade from wss 2.0 to wss 3.0 and we have since lost the entire database architecture and I believe the data stored therein. Is there someplace on the server where the data records could be stored and has anyone had similar problems with this type of upgrade? The IT firm says it's a problem with a security patch from microsoft but I can't find anythying referencing that online.
The following may provide some background on what transpired and how it has been handled thus far; these are from correspondence between our company and the IT firm in chronological order:
Our initial inquiry:
5/23 We have several questions regarding the upgrade of the SPS software, not the least of which being why was the upgrade performed without any advance notice to our office, this notice would have allowed us to take the precaution of having our people save their work in progress and prevented the loss of data and time that we experienced. In the future we would ask that we be shown the professional courtesy of prior notification before commencing any major work to the server environment.
At about 1:00 yesterday all of the computers at the shop went down, we contacted (IT REP) and he said that you had started the install of the 3.0 software that morning and at the time he said that the install was complete.
And since that time we have had multiple problems with the system. First we have no remote access, and receive a server error of the server application is not available, the lay-out of the pages does not process properly ie…the column order displays in a random sequence and not as called for in the column settings. The default page now has the added search feature however the format of the prior software has been retained which causes the navigation of that particular page to differ from the rest of the site.
Please contact us as soon as possible, as (COMPANY OWNER) has no access to the system and no e-mail.
Reply from IT Rep:
5/24 IT REP worked on the phone for over 7 hours yesterday. The Microsoft Tech and IT REP agreed to continue this morning. I know as of last night the remote portion of the Companyweb and the internal site were functioning. However, they are continuing to work to retrieve the existing data.
Did you ever add the other external hard drive to your backup rotation? If so, please let IT REP know. I have meeting this morning until 11:30, if you need anything please contact IT REP.
We will discuss what caused the problem and future prevention after all is resolved.
Our response:
5/25 I am inquiring as to the progress toward restoration of the company web. As you are already aware, the data contained in the company web is crucial to the day to day operation of our business. We are not able to access any of our scheduling information for installations, production or customer service issues. While we have been able to track most of these items thus far, the amount of information available for scheduling next week is quite limited.
It would be helpful to have some indication of when we expect to be restored as well as an estimate of the percentage of data which may be lost, so that we can begin to formulate our response to the situation.
I am certain that you and IT REP understand just how serious the consequences of this situation can become, and assume that you will be capable of providing us with periodic updates as to your progress.
I would also be interested to find out if there are plans to work this out over the weekend or if it has been decided to place this on the back burner and resume restoration of our vital data on tuesday. IT Reply:
5/25 At this point, this is a Microsoft issue that they are working on to resolve – I’m only facilitating their ability to access the server and work. I am doubtful that they work on the weekend, but I will find out. IT REP and I have spent roughly 25 hours in the last 2.5 days working on this, myself until almost midnight last night, so he and I are putting forth every conceivable effort to resolve this. In the mean time, I have turned off the automatic updates (which are enabled by default) to prevent this type of thing from happening again. Keep in mind that if there were 2 hard drives being used in a rotation as IT REP suggested, we’d have backups from before the failed patch to revert to.
As soon as I have any indication of a target time for resolution, I will not hesitate to let you know.Our next question:
5/25 Have we checked to hard drive that is currently in use to see if there is anything salvageable on there. Isn't the server partitioned and mirrored?Latest IT correspodence:
5/25 I have a few suggestions from microsoft that we were going to try, but it looks as though someone took the external drive off the server, so we were unable to do it. I was just checking to see that someone did do that, and that it's in a safe place until it can be reconnected.. The server uses a RAID 5, not mirroring. Mirroring wouldn't matter either, as in a mirrored configuration, 2 drives mirror each other - when the primary is written to, the secondary (mirror) is immediately updated. I'm pretty sure we can get the data files (.dwg, .xls. ,doc, etc) out of the sharepoint database, but we'll need the drive reconnected. The Microsoft engineers have left for the day, but we'll be back on it next week on Tues when they're back in.
For some reason FTPS is no longer working as it used to before plesk upgraded. At this point, I am not sure which Plesk upgrade caused this since I do not FTPS or ftp in general often. its enabled as it was before, even disabled and re-enabled it again. Still gives a "could not establish connection". Restarted the service via command Line with "service xinetd restart". still isnt working...
View 19 Replies View RelatedI have ftp server (pure-ftp). with firewall.
i allowed 20 and 21 port in "CSF" firewall
now when i or our client connect to the server connection done.
and the they fire dir or ls command they will receive error
"425 Could not open data connection to port 2535: Connection timed out"
what is the problem.i have already allowed passive port 2500:3500 then why i received this types of error
I have a server running cPanel.
At the moment, I am been hosted on an unmanaged server (dedicated).
My server provider is offering $25/hour for managed support.
My Kernal and Centos have not been updated for a while and I am looking to upgrade both of them. I am wondering how long would these 2 jobs normally take?
I have been using cpanel for last years. just today got DA on a new dedicated server and now have problem with dns.
[url]
I know the basics of dns and nameserver but i am kinda lost in DA
Changing php version to 5.2.6
I just lost the handler....no php handler at all( old: DSO), rebuilding again (second time)...
anyone knows why this happened?
and what should I do, since the last easyapache rebuild didn't work?
We delete LOGS.
We delete QUEUE mail.
After we add up all the space of the counts.
space of count1 + space of count2 + space of count3 + ... ALL COUNTS
And TOTAL < to 2GB included MySQL space
But space used (say Vistuozzo), is 8.47 Gb!
How we can understand this?
Ok, maybe 2 GB of CENTOS + cpanel + WHM+ MySQL + Files config = 2 GB
Home + MySQL = 2GB
4 GB is very different to 8.5 GB!
Ok think in 3 GB of SO+WHM+CONFIG add 2 GB of files this = 5 GB
is there any chance to reset WHM password?
i have 2 root user account
1. root (this password same as the WHM password)
2. admin (i know this password)
isthere any chance to change root password with my admin password
i have a problem with my server today with centos 4, it dont boot anymore the system report that i have a bad superblock, i have restore it with e2fsck -b 32768 /dev/sda1 but it dont boot, i have try also the other 4 backup but nothing to do, the system report that i have a bad superblock on each partition,
View 5 Replies View Relatedhow can i find a file xxx.tar.gz i have lost it on the root i know don't say it,
i wanna use ssh to find it.
what is packets lost,
I used just-pings.com site and its says my site had 100% losts packets in some locations, what does this mean?
One of my other host doesn't have any packets lost, so for a new package should I go with them, rather than the host which has packets lost?
[url]
When I asked my host they said do not trust just-ping and told me to use,
[url]
Does this site check for packets lost?
i'm running centOS i don't know what version it is as i can't find anywhere on the net what the command is to get the version of os i'm running.
But yum is apparently not setup. whenever running "yum install php" for example i get the following error,
"bash: yum: command not found"
Now i've also tried "su -c 'yum intall php'" even while logged in as root. But i get the same error.
Anybody have any direction for me on this? I've been googling this for wlan hour and have come up totally empty.
We have a large problem here, we lost access to using our ftp client to the server. We also lost our email with our main account well.
We can't ftp in to our accont or any accounts on the server.
I have reset the passwords for the cpanel and email etc still nothing.
We need to gain access to download all the files on our server.
We have a off site backup service and I am trying to figure out how we can download from there as well.
I have a problem with PHP installed on my Linux server.
PHP 5.2.3 worked fine with JSON, MySQL and other libraries.
But when I:
- installed FFmpeg-PHP module
- added extension=FFmpeg module into php.ini (nothing was changed in php.ini)
- installed PHP-devel with yum
- rebooted server
PHP stopped working with MySQL and JSON. I've added absolute path for mysql.so in php.ini and it works now. But I couldn't find json.so library on my server (with find command).
So, I've downloaded and compiled Json 1.2 and added absolute path to .so in php.ini, but it doesn't work.
FFmpeg-PHP doesn't work also.
I get these errors in php error log file:
Quote:
[20-Nov-2007 03:27:30] PHP Warning: PHP Startup: json: Unable to initialize module
Module compiled with module API=20060613, debug=0, thread-safety=0
PHP compiled with module API=20050922, debug=0, thread-safety=0
These options need to match
in Unknown on line 0
[20-Nov-2007 03:27:30] PHP Warning: PHP Startup: ffmpeg: Unable to initialize module
Module compiled with module API=20060613, debug=0, thread-safety=0
PHP compiled with module API=20050922, debug=0, thread-safety=0
These options need to match
in Unknown on line 0
Trying to set up mysql and php a number of times I have manage to install duplicates. I installed individuals and then found xampp. When trying to get rid of Xampp I seem to have lost some vital info needed for apache. where apache is on Mac X tiger. I need to know what the folder structure is "supposed to be". Terminal is picking up 2 different mysql versions.
View 0 Replies View Relateda few days ago one of the dedicated servers i was using got wiped out by midphase/softlayer. i also wrote a post on digital point and the users there suggested i mention this incident here for people to know......
View 14 Replies View Relatedwhat i need to do? I've lost whm root password..
when I try to login, this message apear
This account is currently locked out because a brute force attempt was detected. Please wait 10 minutes and try again. Attempting to login again will only increase this delay. If you frequently experience this problem, we recommend having your username changed to something less generic.
I have registered a domain name with vanguard-hosting and have a hosting with them. But now I can't enter my e-mail nor cpanel. There's a message that I should contact them, but nobody answers the phone and e-mail.
Plus their site vanguard-hosting.com is no longer exist (it redirects to dynadot.com).
What's going on?
Is it possible to transfer my domain name to another host provider?
I was trying to istall csf and after all it effect my second vps also and when i ping my ip is ok but not for my domain and when i run ifconfig in my working ip reports:
Quote:
HWaddr 00-00-00-00-00-00-00-00-00-00-00-00-00-00-00
?
My vps that i was try to install the csf is working only my second vps doesn't (both ip and domain).
I'm getting slow server response times I've been struggling with this for quite some while.
Here is what I know so far:
1. My website divinelightingdotcom through justping returns average 60-80% packets lost for all locations but Santa Clara, which usually has 0-20% loss.
2. My VPS is in Dallas
3. My ISP is also in Dallas, yet justping their website returns 0 packets lost
4a. When I ping my site from Atlanta, the avg trip is 44 ms
4b. However, the first access of my website through a browser usually takes about 5-10 seconds to respond
4c. I assume that my customers have this same experience (if so, this is killing me on my sponsored search advertising)
5. subsequent navigation through the website is usually acceptably fast.
6. wait an hour or so, and the initial page load has 5-10 second response delay again (can be any page on the site)
7. perhaps related, WinMTR from my location in Atlanta shows an comcast IP in virginia that consistently has 20% loss. I have opened a trouble ticket with Comcast.
I edit "/etc/ssh/sshd_config" file to chang default ssh port. So I restart ssh and close my connection without test.
Now I can not access SSH on dedicated. I try restart ssh on WHM and I receive "sshd has failed, please contact the sysadmin."
I'm just wanting some feedback in response to what I feel is gross neglegence of a Webhost I used. I have a website thru this company, WebsitePros. They seemed great for someone like myself, a retail business owner/operator w/ no eployees. I pay 1 company to host, market, and provide software for me to build & manage my site & store. My site had an ecommerce store which was mistakenly deleted by someone at their company. They lost all my pics, product descriptions, customer info, etc, from 2 years of business. They have no backups at all for the store (i had to login to my account to manage store using thier software-- no ability to backup the info on my computer). I was told by their supervisor that traditional webhosts like WebsitePros don't backup store files, just the site itself, and that they would only be willing to help rebuild but offer no monetary compensation (oh yeah, and 3months at 1/2 price...sweet). This isn't a case of failure to pay a bill or anything along those lines---they admit total liability.
My questions are:
1) Is it not the webhost's responsibility to backup these "store" files?
2) Do I seem unreasonable in asking for damages since they lost all this info, including 100's of customer profiles & outstanding orders?
3) Heard of precedents here? Right compensation?
ping: 64.191.50.55
location result min. rrt avg. rrt max. rrt
Santa Clara, U.S.A. Okay 108.6 127.3 165.2
Florida, U.S.A. Okay 86.9 94.8 110.9
San Francisco, U.S.A. Okay 101.0 115.2 142.9
New York, U.S.A. Packets lost (30%) 47.0 50.2 54.3
Austin1, U.S.A. Packets lost (10%) 80.7 88.9 118.2
Austin, U.S.A. Packets lost (10%) 77.1 86.4 116.8
Vancouver, Canada Okay 172.9 185.3 240.5
Chicago, U.S.A. Packets lost (10%) 59.2 66.1 71.5
London, United Kingdom Okay 102.2 113.3 119.9
Amsterdam3, Netherlands Packets lost (30%) 126.7 129.9 132.7
Amsterdam2, Netherlands Packets lost (30%) 112.7 117.5 123.5
Stockholm, Sweden Packets lost (10%) 139.2 145.6 148.2
Cologne, Germany Packets lost (10%) 129.3 135.5 143.4
Amsterdam, Netherlands Packets lost (10%) 121.9 126.4 130.0
Krakow, Poland Packets lost (20%) 139.0 147.2 152.5
Madrid, Spain Packets lost (10%) 129.2 136.5 143.3
Paris, France Packets lost (10%) 129.4 132.1 135.7
Munchen, Germany Packets lost (20%) 133.5 137.0 142.0
Copenhagen, Denmark Packets lost (20%) 110.9 120.2 124.2
Lille, France Packets lost (10%) 117.8 123.5 127.6
Cagliari, Italy Packets lost (20%) 156.8 159.3 162.8
Sydney, Australia Packets lost (20%) 251.4 264.2 268.4
Melbourne, Australia Okay 280.7 291.1 301.5
Zurich, Switzerland Packets lost (10%) 155.3 163.6 169.1
Shanghai, China Okay 321.8 328.5 337.7
Hong Kong, China Packets lost (30%) 282.9 292.8 304.5
Porto Alegre, Brazil Packets lost (10%) 200.1 208.8 217.1
Singapore, Singapore Packets lost (20%) 311.3 333.3 371.3
Mumbai, India Packets lost (20%) 240.5 245.2 249.7
Johannesburg, South AfricaPackets lost (40%) 390.4 427.0 517.8
It is bad than my vps on vps4less.de .
Just got a new VPS, working on securing it and I was configuring sshd_config changed the port logged out, new port didn't work! Ok so I login to hypervm and i figure i'll just change it back with the hypervm file manager. Well the file seems to have dissepeared?
View 2 Replies View RelatedI am trying to change to a different server within the same webhosting company and they have asked me for the username and password of the SQL database I have in my site. Call me stupid, but I have lost this and now I am wondering what I can do.
Since I can log into the cpanel etc I can very well make a copy of the database etc., if that helps. Is there somewhere I should look in the files and folders where the username password info may be store in? I seem to recall reading somewhere that is the case. Any info appreciated.
The reason the host needs this info is because the new server doesnt use cpanel, it uses something called plesk. So if all fails, I am thinking, I just move to a different host who uses cpanel, that way I dont need the UN/PW? Seems a rather silly thing to do, but I have t consider all alternatives now.