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.
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.
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?
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.
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.
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...
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?
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?
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.
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.
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?
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.
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.
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.
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?
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?
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*
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)
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.
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
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
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
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
