Having major problems with mysqld causing CPU usage to rocket to 100% on one core for a short time, which usually drops back down again to 1-7%, though sometimes it can last an extended period of time. This is a problem because things using mysql become unresponsive in this time.
[Code]...
Just started noticing my Processor and RAM are going up to 100% even when idle.I can't see any processes that are using it all up and SWAP starts getting eaten into.
View 3 Replies View Relatedtop says there's only 12MB free (out of 1GB), but I can't figure out what's using all the RAM. rtorrent is using 13MB, and the rest are in bytes. (ran top as root)
[Code]...
Is anyone here fluent with the usage of the .htaccess file? Is it the way to go to deter search bots or is there a better method? Never mind. I already have a thread about .htaccess here.
View 1 Replies View RelatedI am trying to get mysql to start at boot without any success.
The mysqld scripts works fine when run from the command line, but it does not work when i use the links created by chkconfig. I checked the boot.log and found that mysql starts but then it stops or gets shutdown. This is the log message:
Starting mysqld daemon with databases from /data/mysql [ OK ]
Starting cups: [ OK ]
STOPPING server from pid file /var/run/mysqld/mysqld.pid
starting DenyHosts: /usr/bin/denyhosts.py --daemon --config=/usr/share/denyho
sts/denyhosts.cfg
090727 04:35:47 mysqld ended
The same init script works fine in Ubuntu.
so my server is doing fine, but there is one odd thing I would like to fix. When I start and stop services, the CPU is maxed out for about five seconds each time. The services start the same speed, but it still does this. Small things like lm_sensors don't do this, just things like httpd and sendmail. THis server was upgraded to Fedora 11 with a netinstall CD a few months ago.
View 4 Replies View RelatedI am working in a office where only one internet connection available. I have configured 5 other client machines to use internet through squid proxy server. Now I want to restrict the total data usage/transfer (upload+download) to say 1 GB during a calender month. How can I achieve this setting.
View 1 Replies View RelatedI have installed Mysql in Ubuntu 9, for the use of roundcube database.After installing iam getting the error like this
* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.
So because of this in the roundcube configuration its giving the error message that MYSQL is not installed. So Kindly give me a idea how to solve this.
i was trying to allow remote access to mysql by following mysql was running perfectly until i got here :
Code:
/sbin/iptables -A INPUT -i eth0 -s 192.168.1.0/24 -p tcp --destination-port 3306 -j ACCEPT
i changed my.cnf bind-address line to : "bind-address = 127.0.0.1" and nothing
[code]....
I've setup a fedora core 13 server and I am running mysql on it. I wanted to use MySQL Workbench on my Windows 7 computer on the same LAN to connect to the database. Currently I am unable to connect to the database except if I go through ssh. What ports do I need to open on my firewall? Is there any specific configuration that I need to do to my MySQL database to get it working?
View 3 Replies View RelatedI'm running into a problem where my system is running out of disk space on the root partition, but I can't figure out where the runaway usage is. I've had a stable system for a couple of years now, and it just ran out of space. I cleaned some files up to get the system workable again, but can't find the big usage area, and I'm getting conflicting results.For example, when I do a df it says I'm using 44GB out of 58 GB:
Code:
[root@Zion ~]# df -h
Filesystem Size Used Avail Use% Mounted on
[code]....
long time user of redhat, first time user of fedora...
Installed fedora 10 to the hard drive (building a new web server, switched from RHEL5)
Started to install everything I need, apache, php, mysql, odbc, iseries access for linux, etc...
Got to the php modules, installed php-odbc, php-mysql, etc... but php doesn't see the mysql module
doing a phpinfo() produces -without-mysql
uninstalled it, reinstalled it (this is all done through kpackagekit so far) - no good
uninstalled and tried to reinstall via yum, no good
all the config files are fine - copied my php.ini from the old server and let the installs create the new mysql ini files
how to get it in ? this is my last step before i can begin pen and vulnerability testing it.
Has anyone been able to successfully change MySQL's default datadir in Fedora? I've tried on two machines now (F7 and F11), but run into the same problem on both. Here is what I did:
1. shutdown MySQL (service mysqld stop)
2. create new mysql directory (e.g. ~/mysql/) and set ownership to mysql:mysql
3. move tables from /var/lib/mysql to the new directory (I've tried moving only one user-created table, and also moving system tables with same result).
4. edit my.cnf and change "datadir" to point to new location
5. start MySQL (service mysqld start)
[Code]...
I am running a mysql 5.0.41 community edition server.i have a user x and i need to set max connection limit for the user... Can any one give the correct syntax to update the current user to include max connection for the user x.
View 1 Replies View RelatedI have a server (fedora 11 , LAMP). I want to know if I can upload something to my server via http (I mean from WAN),and this data stream can directly run into MySQL database . Do I need to write some special codes on my web page , or just change apache's configure file
View 7 Replies View RelatedI installed Fedora 12 with package standard of the MYSQL, configured this the same twirling in such a way localhost as in one it schemes with windows VISTA, to put I have others 4 you scheme with windows XP that I do not obtain to have access in the MYSQL. What I have to make pra these you scheme with XP to have access?
View 2 Replies View RelatedLet me show you the Details:
[code]...
So that means the User Test can connect from any host without password and with the named privileges, but he has no right to grant any privileges. CONSOLE:
[code]...
This is my first post. After executing /usr/bin/mysqladmin -u root password 'thepass' as a root, I get this:
Code:
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
SELinux is off.
After securing webmin on my web server, with a custom SSL connection.I wanted to do the same with phpMyAdmin. But I am unsure of where to look for the best tutorial(s) to do this, can anyone help?Plus I saw once at work our network tech adding in accounts but then allocating that to the login itself.For example, when your brought up with a .htaccess prompt in the browser, thats assigned to you login within phpMyAdmin, taken from the db server no doubt, is it possible to do this?Should there be anything else I need to know in securing mysql?I have limited all services to a set number of IPs so non of its publically functional at the moment so I can take as long as possible, but naturally I'd like to be able to be as speedy as possible about getting this sorted.
View 7 Replies View Relatedis this command exact or do I replace anything with my own setu
" yum install mysql mysql-devel mysql-server "
who can't tell what has to be changed for "My server name" and "my setup"
I just installed FC12 x86_64. After a clean install I found that httpd, mysql, svn, svnadmin, etc are already installed. I still need to install and configure tomcat running as a worker behind httpd and configure everything. But my question is about security. What do I need to do to ensure that when I start httpd and mysql that they are secure? Are there default settings that I need to change? Are there security patches I need to apply?
System Config:
Fedora Core 12 x86_64
AMD Athlon II X2 250 3.0 GHz dual core
GIGABYTE GA-MA785GM-US2H
G.SKILL 4GB (2 x 2GB) 240-Pin DDR2 SDRAM DDR2 1066 (PC2 8500) Dual Channel Kit Desktop Memory Model F2-8500CL5D-4GBPK
it seems i have successfully installed LAMP.. i have a very basic page below that works when invoking "data()" but when i try to connect to mysql server (by removing the comments "//") it would just return a blank page.
[Code]...
I was installing a 2 server cluster ISPConfig3 with the help of GlusterFS. I was following this manual - Link
In the server the file /etc/glusterfs/glusterfsd.vol
Code:
# Configuration for the mysql server volume
volume posix-mysql
type storage/posix
option directory /media/big/myweb/export-mysql
[Code].....
I am not able to start mysql server...when i type command sevice mysqld start it saysMySQL Daemon failed to start.Starting mysqld: [FAILED]so how to solve this problem ?
View 10 Replies View Relatedanyone come across a mysql driver for Bind that is already in RPM format? I know there is one that you can compile, but i was just curious if anyone knew of a MAINTAINED package that does that same thing?
==Edit== While i'm at it, does anyone know of a way to have bind call a STORED PROCEDURE, instead of directly querying a table? That'd be sweet. --Or, even having bind query a php file, or a webhost, would be good... I'm going to google that one now....
==Edit== Screw the mysql driver: [URL]
how to use php to serve dns requests...
I've created a mysql user and he can connect Joomla to mysqld when everyone has full permissions to the mysql homedir but I know this is bad from a security standpoint. If I set mysql user as the only one with permissions then I can't connect. I know Joomla support is not very help from past experience, wish I could dump it for something else but it does work great once it is configured so I need to keep it around, can anyone make a guess as to what permissions I need to have set on mysql's home dir so that joomla can still connect yet I am more secure than now?
View 11 Replies View Relatedi'm new to MySQL and i designed a database using MySQL and PHP recently but dont know how to port it to my host company. How do i save the database on my flash drive then transfer to my host on my website's control panel.
View 1 Replies View RelatedTarget F12 mysql - 5.1.42-2
Source FC 5 mysql - 5.0.27-1
I've put SElinux into permissive mode as it was practically denying anything that moved. Both installed from the standard repos. I used mysql-administrator to create a backup of the FC5 server (all databases/tables) and transferred it to the new system. I restored it onto that machine and double checked that my standard admin user (full privs) was present and let me log in to make changes. All good so far.
So I copied over my files from my sites, point a browser at them and I get nothing, not even errors. Now it's a long while since I set the original up and have probably forgotten something simple but despite making the error output more verbose I can't seem to track anything down other than:
[Code]....
So it suggests my tables are invalid/trashed but I can't seem to figure out why. The original server is still running happily so I'm not in any rush to fix this, I'll keep plodding, Phpinfo reveals a normal operational php setup, so i think that side of the sites is functional. Apache test pages work on blank virtual hosts but viewing my sites reveals the favicon working fine but otherwise comepletely blank pages (zero output, even source). I tried running the page as a raw CLI input to the php package using php index.php and php returned nothing, logged nothing unusual but sat with my CPU at 100%, unsure if that is related.
My Linux server which is running my company website have been hacked. Today I saw a number of clients (customers) with some fun characters entries on my database. Access denial on really clients.
View 2 Replies View Relatedi'm not sure if this is because i'm having problems with my Raid setup, which mysql is running on, or if it is unrelated, but is anyone else noticing that mysql is VERY slow on Fedora 15?
View 5 Replies View Related