MySQL Error Took Store Down
Sep 22, 2007
I've got a Fully Managed VPS hosting service running my sites and this morning I got the following error messages. My host says they do not monitor mySQL yet this error took my whole store down and kept it down for several hours until I noticed that. It's not a complaint, just asking your opinions on what this could be and what should i do about it etc.:
Warning: mysql_select_db() [function.mysql-select-db]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11) in /home/store/public_html/include/func/func.db.php on line 47
Warning: mysql_select_db() [function.mysql-select-db]: A link to the server could not be established in /home/store/public_html/include/func/func.db.php on line 47
Sorry, the shop is inaccessible temporarily. Please try again later.
View 12 Replies
ADVERTISEMENT
Jan 30, 2015
We use Apache as part of a 'consumer' software which as been working fine with Apache 2.0.64 (running as a 'regular' user). We want to transition to version 2.4, but it seems to be working a little bit differently than the 2.0 version.
In httpd.conf, we have "ErrorLog logs/error.log". With version 2.0, the error.log file is created in the "...AppDataLocalVirtualStore..." path (since user cannot write to 'Program Files (x86)' were it is installed), but with version 2.4.10 we only get an "Access is denied. AH00015: Unable to open logs" error.Is this a known difference between 2.0 and 2.4.
View 4 Replies
View Related
Jan 21, 2007
I installed the MySQL binary packages in /usr/local/mysql/ after removing the MySQL RPM package. MySQL is functioning when I executed /usr/local/mysql/bin/safe_mysqld. I reinstalled MySQL before I installed PHP. When I used a PHP script to access a MySQL database, it outputs an error:
Code:
Warning: mysqli::mysqli() [function.mysqli-mysqli]: (HY000/2002): can't connect to local mysql server through socket /var/lib/mysql/mysql.sock in index.php on line 2
However, I installed MySQL in /usr/local/mysql, not in /var/lib/mysql. How do I fix MySQL?
View 1 Replies
View Related
Dec 18, 2007
I keep getting this error :
MySQL Error : MySQL server has gone away
How do I fix it?
my.cnf contents
Quote:
[mysqld]
safe-show-database
old_passwords
back_log = 75
skip-innodb
max_connections = 800
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 = 30
tmp_table_size = 128M
max_heap_table_size = 64M
max_allowed_packet = 256M
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
max_user_connections = 500
[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
View 5 Replies
View Related
Oct 1, 2009
I would like some tips on how to create back ups with WHM/cPanel on a Reseller if you could.
Also where to store them?
I was thinking of storing them up on a VPS or Dedi server that just has backups or should I buy a enternal Hard Drive for my computer and store them on that? I have a 500GB Hard Drive.
View 14 Replies
View Related
Dec 30, 2008
i am about to run my own online store but i am wondering if im doing it right
my domain name i am gona buy it off godaddy.com
my hosting would be in site5.com
and shopping chart im gona use is magento
i think i am doing it right but im not sure if these company r good?
View 14 Replies
View Related
Jul 22, 2008
I am completely new to VPS, and I was wondering, where would I put my files in the VPS? Normally I am used to just storing them in public_html, or whatever I am given, but I can't find that on my server. Apache has already been installed.
View 11 Replies
View Related
May 7, 2008
I am currently shopping for web hosting for an online store (that would provide software - mostly automatically downloadable upon payment).
My estimates for initial operation of my web/online store are:
Storage: (10MB/app x 50 apps) + 50MB overhead = 550 MB
Monthly transfer: 5000 purchases/month x 10MB/app = 10 GB
Number of email accounts: up to 10
By "initial" I mean first year, not first month.
My intent is to develop my own osCommerce based web store for downloadable software that I develop. PHP and MySQL support are must. My estimates are not carved in stone. In the beginning I will certainly use much less "monthly transfer" than I specified and in the long term I hope to be using much more "monthly transfer" (as marketing evolves and the business becomes more established)...
The most important factors to me are (in the following order):
1) Reliability (up-time, security)
2) Tech support
3) Expandability (room to grow)
The company that registered my domain name provides web hosting with much more than I initially need (5GB space, 250GB transfer, 50 email accounts) for under $3 a month.
This is a price that I can afford. However, I am not sure whether it is a good idea to have both the web hosting and domain registration provided by the same company? Any opinions/comments you have about this? Is my doubt in this regard unfounded?
Secondly, is there some independent source (user/customer reviews OK) that compares the reliability of web hosting providers? (I would have given the name of my registrar here but I am unsure whether this would constitute advertising. If mentioning names or asking for references is allowed please let me know and I will post it here so that I can get your opinions about it).
Thirdly, is there any significance for where, geographically, the actual servers are located? Main consideration is access speed for customers...
View 14 Replies
View Related
Nov 19, 2007
I have a few questions for those of you who are familiar with the security side of hosting.
If you have a dedicated server is used for general hosting purposes, what can you "safely" store on that server? What type of customer data would you have on a server that is exposed to the Internet, assuming that server received regular security audits?
View 2 Replies
View Related
Mar 27, 2009
I intend to store and serve files that is around 1-200mb from servers that is physically separate. I wish to store 2 or 3 copies of each file as a redundancy solution. When the file is requested I want to serve a direct downloadable link to the file. I am looking for logic to distribute load, and to detect if a server is down. I also whish to redistribute the files if a server is taken out of the pool..
Is there any open/free systems for this I can use?
View 9 Replies
View Related
May 28, 2008
Is there a way in the php.ini file to force all sessions to be stored in a database? For example, in ColdFusion you can configure sessions to be stored in a db. Can you do this in PHP? Thereby forcing all sessions no matter what the customer specifies to be stored in a db.
View 3 Replies
View Related
Apr 22, 2008
I want to host my online store. Please tell me best web host. I am thinking of godaddy or 1and1. How are they both? Is there any better web host? I am looking for shared hosting in starting with good features like SSL too.
View 14 Replies
View Related
Jan 11, 2008
I need a medium of some kind to store my backup drive images of a windows 2003 standard x64 server. I will be taking DriveImage XML images every Sunday. The medium must have a minimum capacity of 250gb.
I am wondering what is the best/most cost efficient option? My budet is around $500.
I have heard tape and usb external drives.
Can you provide specific models, costs, pros/cons of each technology and product?
View 0 Replies
View Related
May 14, 2009
Is there any host out there that is compliant (say to PCI type standards) that would allow me to create a online form that will be used to fill out a rental application?
These applications will need to have the SSN / Drivers Lic. of the user filling them out, as well as CC info to be processed.
The CC info does not need to be stored, just processed for the application fee.
The SSN / DL need to be stored in such a manner that the realty agents can retrieve the form the users filled out so they can then use it to submit the application for whatever purposes.
(I would imagine it also needs to be stored so that if they ever get called by the GOVT for information about certian tenants they can retrieve the forms if necessary.
If i do this for the client, I will of course have a contract signed that basically makes sure that I am not liable if the system is breached, as i don't want the host i use for the website part itself to be storing this information at all.
I am kind of looking for a API like setup such as a merchant account, but one that allows the storing / retrieval of SSNs / DL.
View 2 Replies
View Related
May 20, 2007
We are using Putty SSH clients it's great but we are looking for SSH client which can store passwords. So we don't have to enter password each time we login to the server using SSH client.
View 9 Replies
View Related
Jun 28, 2008
I am paying around 15 bucks for 1.0TB bandwith in a shared hosting.
i thought of getting a vps for the site, and just stream videos from the shared hosting server....
the problem would be users uploading videos, is it possible for them to upload files through VPS, and onto the shared host ?
View 5 Replies
View Related
Jul 21, 2008
Wich is the most adequate hosting plan to install a Magento E-Commerce Online Store with:
Number of products: 100 to 300
Number os Visitor / Moth: 10.000 to 80.000
I will need a Shared Accout, VPS, or Dedicated Server?
View 6 Replies
View Related
Mar 28, 2014
I recently started building out a new network rack to provide a production web site. The new equipment stack includes a disk array providing a CIFS file share to store images to be served up by Apache.
I have had zero luck in getting Apache to properly access the imagestore from the network share. I've read more Google pages on this subject today than I can count, but I am still not having any success getting this working right.
I'll do my best to explain the configuration.
I have an ESXi host running several virtual machines. Each machine needs to be able to access the shares. Each host has multiple network interfaces, each connected to a separate subnet. The virtual machines are running Windows Server 2012 Datacenter edition.
The disk array is file mode access, with NFS and CIFS shares. It has interfaces on both subnets that each VM can reach. I have established a stand alone CIFS server, with the shares configured. They are accessible from the VMs.
I have mapped the share to a drive letter on the VM client, and it works properly from the logged in account. I have full control over files on the file system (create, modify, delete).
The VM has Apache 2.4.9 installed.
Things I've tried with no success:
-created a symlink to the CIFS mounted drive into the webroot directory
-added an alias to the CIFS mounted drive
-added the aliased directory using the <Directory> directive
-added the alias and directory directives using UNC references
I am seeing errors like "path is invalid" mostly, but when I try to add the mapped drive (f or the UNC referenced directory, the Apache service won't start.
I added a separate user for the Apache service, and added it to the group that has privileges to talk to the share, still didn't work.
View 1 Replies
View Related
Jan 17, 2008
Been running a server for 2 years now on Windows SBS 2003, and within the past 2 weeks, the server has been locking up or going very sluggish after only a few hours of use.
I've noticed that STORE.EXE is using a lot of memory, there are a number of people within the building using this server for various tasks with Microbiz, Quickbooks, and Exchange server. I researched the topic and was told if I can archive Exchange, that this should help with performance. Anyone know how to do this or to lower the use of memory with the server?
View 8 Replies
View Related
Sep 29, 2014
I've been running a Plesk server with around 100 domains for years and years now. I've always used a backup service provided by the server vendor, but with a new server, I wanted to consider some of the backup options built into Plesk.
1. It looks like Plesk/Acronis is dead or only for Windows. Is that right?
2. If I add a backup drive to the server, can I setup Plesk Backup Manager to store the backups there (instead of on the main RAID array)?
3. Are there any other 3rd party extensions that I should consider?
View 8 Replies
View Related
Jul 21, 2007
I have this error my site:
dbconn: mysql_connect: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
*dbconn: mysql_connect: Can't create a new thread (errno 12); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug*
View 4 Replies
View Related
Mar 3, 2007
I recived this error message while testing my website registartions form and was wondering what to do with this and i think it should be permission to access to the database is not given to the user but this is my own account and im the admin and how come the access is denied?
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'alien'@'localhost' (using password: YES) in /home/seektran/public_html/db_connect.php on line 12
Error: Could not connect to database server. Please try again later.Access denied for user 'alien'@'localhost' (using password: YES)
View 5 Replies
View Related
Jul 1, 2009
in phpMyadmin when trying to import a database from a file, i'm getting the error:
#1153 - Got a packet bigger than 'max_allowed_packet' bytes
The file I'm importing is only 7.08MB
I have tried setting the packet size in the shell as follows:
mysql> mysqld --max_allowed_packet=32M
I got no error or no confirmation either using this command, sorry I dont use shell commands much so I dont know if thats a problem or if it worked.
View 3 Replies
View Related
Jul 8, 2009
I have a new customer moving from another host. His account was terminated already, so just have backup file. When restoring his mysql database, I have this error
Quote:
Unable to restore database dbname.sql to agesuke_forum : ERROR at line 521 in file: '/backup/dbname.sql': Unknown command ''.
Googling shows error in version < 5.0.6 but we are using 5.1.35 already. Is there any idea to fix? This account will run on CentOS 5 - 64bits, FYI.
View 6 Replies
View Related
Nov 7, 2008
MySQL Error : Out of memory
I'm getting this very frequently today
MySQL Error : Out of memory (Needed 76760 bytes)
Error Number : 5
Request Date : Friday, November 7th 2008 @ 01:52:17 PM
Error Date : Friday, November 7th 2008 @ 01:52:18 PM
Script : [url]
Referrer : [url]
IP Address :
Username :
Classname : vB_Database
MySQL Version :
I have Mysql 5 installed, on a Centos/Cpanel box. Server has 4GB memory, server load is green/normal.
I already ran optimization on the database too.
It started happening yesterday, pretty much after I installed this hack:[url]
Quote:
[mysqld]
local-infile=0
datadir=/var/lib/mysql
skip-locking
skip-networking
safe-show-database
query_cache_limit=2M
query_cache_size=128M ## 32MB for every 1GB of RAM
query_cache_type=1
max_user_connections=500
max_connections=500
interactive_timeout=10
wait_timeout=28800
connect_timeout=20
thread_cache_size=128
key_buffer=512M ## 128MB for every 1GB of RAM
join_buffer=8M
max_connect_errors=20
max_allowed_packet=32M
table_cache=1024
record_buffer=8M
sort_buffer_size=4M ## 1MB for every 1GB of RAM
read_buffer_size=4M ## 1MB for every 1GB of RAM
read_rnd_buffer_size=4M ## 1MB for every 1GB of RAM
thread_concurrency=8 ## Number of CPUs x 2
myisam_sort_buffer_size=64M
server-id=1
collation-server=latin1_swedish_ci
[mysql.server]
user=mysql
old-passwords = 1
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192
[mysqldump]
quick
max_allowed_packet=24M
[mysql]
no-auto-rehash
#safe-updates
[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[mysqlhotcopy]
interactive-timeout
View 6 Replies
View Related
Jul 22, 2007
Warning: mysql_connect() [function.mysql-connect]: Can't create a new thread (errno 11); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug in /home/user/public_html/includes/functions.php on line 423
Can't create a new thread (errno 11); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug
View 7 Replies
View Related
Dec 12, 2007
Error: Missing Dependency: php = 4.3.9-3.22.9 is needed by package php-mysql
above is the error if i try to install php-mysql
tried several times:
yum install php-mysql
but i get the same error everytime
i am using Centos4 + PHP5 + mySQL5
View 7 Replies
View Related
Jan 30, 2007
MySQL 5.0.27
phpMyAdmin 2.5.0
Php ver 4.4.0
IIS6 Win2003 Web Edition - dedicated
I cannot work out what is going wrong here. I have been up all night trying to work it out!
Have installed MySQL + PHPmyAdmin no errors no problems. Log into phpmyadmin and look at a database but it will not show how many records are in the field nor what size the records are. It says records - unknown, size unknown
View 4 Replies
View Related
Dec 27, 2007
Getting this frequently
MySQL Error : MySQL server has gone away Error Number : 2006
/etc/my.cnf
[mysqld]
local-infile=0
datadir=/var/lib/mysql
skip-locking
skip-innodb
skip-networking
safe-show-database
query_cache_limit=1M
query_cache_size=32M ## 32MB for every 1GB of RAM
query_cache_type=1
max_user_connections=300
max_connections=1000
interactive_timeout=10
wait_timeout=20
connect_timeout=20
thread_cache_size=128
key_buffer=512M ## 128MB for every 1GB of RAM
join_buffer=1M
max_connect_errors=20
max_allowed_packet=16M
table_cache=1024
record_buffer=4M
sort_buffer_size=4M ## 1MB for every 1GB of RAM
read_buffer_size=4M ## 1MB for every 1GB of RAM
read_rnd_buffer_size=4M ## 1MB for every 1GB of RAM
thread_concurrency=8 ## Number of CPUs x 2
myisam_sort_buffer_size=64M
server-id=1
collation-server=latin1_general_ci
[mysql.server]
user=mysql
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192
[mysqldump]
quick
max_allowed_packet=16M
[mysql]
no-auto-rehash
#safe-updates
[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[mysqlhotcopy]
interactive-timeout
I have mysql 5 / php 5 / apache 2 with cpanel/whm.
View 2 Replies
View Related
