I am trying to increase my open file limit on my CentOS release 4.6 VPS.
I have tried modifying my /etc/security/limits.conf with the following:
@mysql soft nofile 4096
@mysql hard nofile 4096
@mysql soft sigpending 4096
@mysql hard sigpending 4096
Even is a mannual set it with "ulimit -n 4096 mysql" it will not stick.
Any ideas what I can do to get this limit increased permanently?
I been having a heck of a time just with this one cpanel server and open files limit. At first using open_files_limit did not work so I changed it to open-files-limit that seemed to work but now it rejects the value and sets its down to 65535.
Then system open files limit is 500000. I try to set it to any value about 65535 in my.cnf and here is usual error:
090630 9:32:07 [Warning] option 'open_files_limit': unsigned value 120510 adjusted to 65535
090630 9:32:07 [Warning] option 'open_files_limit': unsigned value 120510 adjusted to 65535
When I run something like the tuning-primer it shows:
Current open_files_limit = 120510 files
The open_files_limit should typically be set to at least 2x-3x
that of table_cache if you have heavy MyISAM usage.
Your open_files_limit value seems to be fine
But Im not sure if it is just reading my.cnf or something. I am still getting complaints from users about lost connections and I see the errors in error log. Ive looked everywhere and cant seem to find a solution to this.
Rapidly growing error logs showing the same message
$ug-non-zts-20020429/ffmpeg.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20020429//usr/local/lib/php/extensions/no-debug-non-zts-20020429/ffmpeg.so: cannot open shared object file: No such file or directory in Unknown on line 0
root@server [~]# ls /usr/local/lib/php/extensions/no-debug-non-zts-20020429
./ ../ eaccelerator.so*
root@server [~]# ls /usr/local/lib/php/extensions/no-debug-non-zts-20020429
./ ../ eaccelerator.so*
Using cpanel 11 / centos 4
How to increase the Open Files limits descriptor in Apache. In the earlier version of Cpanel, we had an option of Raise FD Size Limit to 16384, but the option no longer appear while rebuilding Apache. What is the way to do it and make the change permanent?
View 2 Replies View Relatedi can't enter to the SSH secure file transfer and show me that msg':
Failed to open a secure file transfer session
Most likely the sftp-server is not in the path of user on the server-side
MY VPS IS DOWN.
i have this error on concole on hypervm
enter into CT 1820 failed
Unable to open pty: No such file or directory
I have following error when try to login in my vps, how can resolve this issue?
Code:
Last login: Thu Jun 19 21:00:43 2008 from xxx.xxx.xxx.xxx
ALERT! You are entering a secured area! Your IP and login information
have been recorded. System administration has been notified.
This system is restricted to authorized access only. All activities on
this system are recorded and logged. Unauthorized access will be fully
investigated and reported to the appropriate law enforcement agencies.
enter into VE 270 failed
Unable to open pty: No such file or directory.
none:0: open: /etc/named.conf: file not found
i had install cpanel on Cent Os 5 on a VPS
Cpanel Correctly Running but named does not working !
i try to restart named but it say :
root@server [/etc]# service named restart
Stopping named: [ OK ]
Starting named:
Error in named configuration:
none:0: open: /etc/named.conf: file not found
[FAILED]
c:Apache24bin>openssl.exe
WARNING: can't open config file: c:/openssl-1.0.1e-X64/ssl/openssl.cnf
OpenSSL>
I can't seem to remember, but what's that command or file used in Linux so that you can view/adjust the number of open files and others in the system?
View 3 Replies View Relatedmy server runs centos with whm/cpanel,
some folder may contain over 1000s files,
and the ftp only can show 1000s files well,
where can i large the value and let it show more?
Basically mysql is behaving very very intermittently. Crashes were every 4 hours, I've brought them down to once every 8 or so hours but mysql keeps dying.
the error log will show the same routine each time.
on mysql start:
Quote:
091101 21:58:03 [Warning] option 'open_files_limit': unsigned value 120000 adjusted to 65535
091101 21:58:03 [Warning] Could not increase number of max_open_files to more than 65535 (request: 200110)
091101 21:58:03 [Note] /usr/sbin/mysqld: ready for connections.
Then we'll see errors due to crashed databases:
Quote:
091102 0:33:07 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './<nameofdatabase.frm>'
following this a heap of:
Quote:
091102 0:36:35 [ERROR] /usr/sbin/mysqld: Can't open file: '>another database here.frm>
091102 0:36:36 [ERROR] /usr/sbin/mysqld: Sort aborted
091102 0:36:52 [ERROR] /usr/sbin/mysqld: Sort aborted
091102 0:43:00 [ERROR] Error in accept: Too many open files
On attempting to select the configuration->filter option on RoundCube, we got the error message:
SERVICE CURRENTLY NOT AVAILABLE!
Error No. [501]
On /var/log/plesk-roundcube/errors we can see the following logs:
[06-Jun-2015 14:57:17 -0300]: PHP Error: SieveRules plugin: Unable to open default rule file in /usr/share/psa-roundcube/plugins/sieverules/sieverules.php on line 1523 (GET /roundcube/?_task=settings&_action=plugin.sieverules)
...
[06-Jun-2015 14:57:17 -0300]: PHP Error: SieveRules plugin: Unable to open example rule file in /usr/share/psa-roundcube/plugins/sieverules/sieverules.php on line 1560 (GET /roundcube/?_task=settings&_action=plugin.sieverules)
...
[06-Jun-2015 14:57:17 -0300]: PHP Error: Error loading template for sieverules.sieverules in /usr/share/psa-roundcube/program/include/rcmail_output_html.php on line 496 (GET /roundcube/?_task=settings&_action=plugin.sieverules)
i have a server and let friends put images on it,
i find some people put big .zip and .iso files on it,
it make my server waste many bandwinth and make the images show lower and lower,
can i install any software to do the control,
to make "if user browse .zip or .iso files, they can only use the 1Mb bandwidth, if the content is images or html,the speed is no limit",
I wanted to add a maximum file size limit of 10mb to all files uploaded via cpanel, php scripts or ftp.
I am currently running cpanel and whm on a linux server.
how i can do this. (i have root access)
I have a file on my server called admin.php and a folder called "admin" I only want 2 IP addresses to be allowed access to those files.
can this be done in .htaccess? if so can someone give me an example?
I have spent ages trying to work it out myself but I'm a bit of a noob
thanks in advance
what should .htaccess files be chmod'ed to ideally?
I just upgraded to the latest version of APF. I am running CentOS with the 2.6 kernel.
I added my ports to allow, started it up, and it does not seem to be blocking anything.
I get no errors on startup though. If i do an nmap, mysql shows up as open still. I can even telnet to it.
root@me [~]# /usr/local/sbin/apf -r
apf(6367): {glob} flushing
I have a big problem concerning the file upload limit (I need a large size, around 2Go) : I was using my app in /var/www/vhost/default and it was working perfectly, I decided to change it and use /var/www/vhost/mydomain.com to have it throught the plesk panel, and there I have an upload limit than I need to push. I can't upload files larger than 128Mo and I don't know why.
- I have checked all php.ini files (with locate php.ini) and they are all correct.
- I used plesk panel to set php conf -> done.
- I put :
php_value memory_limit 2000M
php_value upload_max_filesize 2000M
php_value post_max_size 2000M
in my .htaccess in htdocs
[Code]....
I reload/restart apache2, psa, ... And it still doesn't work, I have no more idea every conf file seems correct. It's not a permission problem because I can upload some 80Mo files but not 500Mo ...
i dont want clients taking the servers I/O and server load over 4.00 when they do major update ect... querys on sql. is there a way to limit the ammount they can do?
View 4 Replies View RelatedWe have found that we need to limit the amount of cpu uage by users on our video share server. On this server we currently have 20 users on a sharred plan. Thought that the obvious BW usage would be the biggest challenge, as it turns out we havent gone over the 2 TB that we have.
We have come up with an encoding process that uses the 264 codec and gives us excellent results in terms of quality but is very cpu intensive to the point of really slowing down the server when 10 or more users simutaneously are encoding their videos.
Can someone suggest a script that would allows us to limit the file size in terms of MB/GB that each user could upload per month.
So for example a client pays 10.00 per month and we wanted to limit their uploads to a total of 900 MB per month vs the client that is paying 50.00 per month who would have the ability to upload say 8 GB per month.
Cento 5
c-panel
Dual Quad Core 2.0 ghz
6Mb Ram
1TB HDD
2 TB of BW
I try to search and not found the solutions to limit concurrent of db users to connect to MySQL in same time for example:
Limit user root to connect to MySQL maximum 5 connections in same time
There have max_connections setting but it limit for all users in all connection to MySQL.
But I found that in version 4.1.x there have max_connections property in user table (Users and global privileges) of mysql database, this setting is limit connection in 60 minutes.
I would like to know if there any setting or code modify for this solution that I want.
error message: [Warning] Could not increase number of max_open_files to more than 65535 (request: 71410)
in my.cnf, I have this already
open_files_limit=90000
and
#cat /proc/sys/fs/file-max
370603
Is there any idea to fix this error?
how i can limit http and mysql connection limit on per domain basis.
View 2 Replies View RelatedI always have this error with mysql
Can't create/write to file '/tmp/#sql_7042_0.MYI' (Errcode: 13)
the /tmp has been chmoded 1777. I installed mysql downloaded from rpm on www.mysql.com, version 5.0.51a 64bits for CentOS-5
how to achieve the following:
We have a dedicated server, on which we hosts about 15 sites. I am needing to:
Backup each site individually (all files)
Backup each Db associated with each site
FTP to our own in-house ftp server
I have been searching around all afternoon, and possible solutions to each point above are the following:
Iterate through each top level folder in, say /var/www/vhosts/ and tar each folder individaully
I have only been able to do a mysqldump the whole server, and have only found scripts into which you have to manually specify each db if i need separate backups for each one done
Not an issue, we currently have backups from a separate server running
Is it possible to set this all up in one, top-level cron job?
I have a server with many db on mysql 5
Any db contains 5 table with data
This data is processed by routine
Many time routine die with the error:
"Incorrect key file for table '/var/tmp/#sql_3018_0.MYI'; try to repair it"
The table sql_3018_0.MYI not exist, think that this is refered to a temporary table but is deleted by process..
what I can do about the following database error in mysql?
Incorrect key file for table '/tmp/#sql_(number of table.MYI); try to repair it
I've repaired, optimized and checked the database in phpmyadmin. Initially 2 tables were showing overhead, but the error message is for a temp table and I'm not sure how to try to repair a temp table.
How to import mysql dump file to database by SSH?
How to import mysql database host to other host database by SSH?