Im trying to get 64bit MYSQL 5.1 installed on a CENTOS 5.2 64bit box. But after a week of wrangling with it I just dont seem to be able to get it running. I have tried both installing via the MYSQL.com RPM's and via a added YUM Repo.
Below is my error log.
Quote:
090522 15:33:04 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
090522 15:33:04 [ERROR] Error message file '/usr/share/mysql/english/errmsg.sys' had only 472 error messages,
but it should contain at least 630 error messages.
Check that the above file is the right version for this program!
/usr/libexec/mysqld: Unknown error 1146
090522 15:33:04 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
090522 15:33:04 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
090522 15:33:04 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
090522 15:33:04 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
090522 15:33:04 InnoDB: Started; log sequence number 0 0
090522 15:33:04 [ERROR] Aborting
Getting the following when trying to install DNN. A similar thing also happened when trying to install WordPress.
Error: Installation of DotNetNuke at http://domain.com/dnn failed. Non-zero exit status returned by script. Output stream: 'Error during MSSQL version checking [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. '. Error stream: 'Error during MSSQL version checking [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. '.
When it happened with WordPress, I tried the install again and it worked the second time. However, with DNN it does not seem to be working after a second try. Yes, the MS SQL server does exist and is ready to provide.
This is the second time this has happened last time my host fixed it and they should be right now but why does this happen to a server?
Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/xxxxx/domains/xxxxx.com/public_html/includes/open_db.php on line 12 Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
My server very slow and the is very loaded. How can I fix this problem? My server specialities and loaded softwares which are below. And sometimes there is "mysql connect failed", "Lost connection to MySQL server during query" errors. Thanks for kinds...
-- MYSQL PERFORMANCE TUNING PRIMER -- - By: Matthew Montgomery -
MySQL Version 5.0.41-log i686
Uptime = 3 days 4 hrs 34 min 17 sec Avg. qps = 92 Total Questions = 25406284 Threads Connected = 1
Server has been running for over 48hrs. It should be safe to follow these recommendations
To find out more information on how each of these runtime variables effects performance visit: .............
SLOW QUERIES Current long_query_time = 5 sec. You have 115 out of 25406302 that take longer than 5 sec. to complete The slow query log is enabled. Your long_query_time seems to be fine
WORKER THREADS Current thread_cache_size = 8 Current threads_cached = 7 Current threads_per_sec = 0 Historic threads_per_sec = 0 Your thread_cache_size is fine
MAX CONNECTIONS Current max_connections = 500 Current threads_connected = 2 Historic max_used_connections = 110 The number of used connections is 22% of the configured maximum. Your max_connections variable seems to be fine.
MEMORY USAGE Max Memory Ever Allocated : 835 M Configured Max Per-thread Buffers : 3 G Configured Max Global Buffers : 46 M Configured Max Memory Limit : 3 G Total System Memory : 3.96 G
Max memory limit exceeds 85% of total system memory
KEY BUFFER Current MyISAM index space = 35 M Current key_buffer_size = 32 M Key cache miss rate is 1 : 73658 Key buffer fill ratio = 34.00 % Your key_buffer_size seems to be too high. Perhaps you can use these resources elsewhere
QUERY CACHE Query cache is enabled Current query_cache_size = 4 M Current query_cache_used = 1 M Current query_cach_limit = 1 M Current Query cache fill ratio = 29.83 % MySQL won't cache query results that are larger than query_cache_limit in size
SORT OPERATIONS Current sort_buffer_size = 2 M Current record/read_rnd_buffer_size = 1 M Sort buffer seems to be fine
JOINS Current join_buffer_size = 1.00 M You have had 14127 queries where a join could not use an index properly You should enable "log-queries-not-using-indexes" Then look for non indexed joins in the slow query log. If you are unable to optimize your queries you may want to increase your join_buffer_size to accommodate larger joins in one pass.
Note! This script will still suggest raising the join_buffer_size when ANY joins not using indexes are found.
OPEN FILES LIMIT Current open_files_limit = 2500 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
TABLE CACHE Current table_cache value = 256 tables You have a total of 636 tables You have 256 open tables. Current table_cache hit rate is 1% , while 100% of your table cache is in use You should probably increase your table_cache
TEMP TABLES Current max_heap_table_size = 16 M Current tmp_table_size = 32 M Of 2271787 temp tables, 3% were created on disk Effective in-memory tmp_table_size is limited to max_heap_table_size. Created disk tmp tables ratio seems fine
TABLE SCANS Current read_buffer_size = 1 M Current table scan ratio = 28 : 1 read_buffer_size seems to be fine
TABLE LOCKING Current Lock Wait ratio =1 : 112 You may benefit from selective use of InnoDB. If you have long running SELECT's against MyISAM tables and perform frequent updates consider setting 'low_priority_updates=1' If you have a high concurrentcy of inserts on Dynamic row-length tables consider setting 'concurrent_insert=2'.
how can i stop php and mysql errors from being displayed on a live site. I'd rather just check the error log than have the errors displayed to all users.
The main function of my dedicated server is the vBulletin forum that we run.
Ever since I had bastille firewall installed and configured on my server we have been getting regular vBulletin errors.
Everything runs pretty smoothly most of the time, we can carry lots of connections without any issues, server has plenty of free RAM and CPU is never overloaded even during peak hours. I have been told bastille firewall (iptables) is configured correctly, all ports that need to be open are open.
But about twice per day we have a MySQL "disconnect" that lasts about 30-60 seconds per incident. For example we will start getting the following message via e-mail, and it will amount to 20-30 e-mails like this during the 30-60 second incident. After that, the e-mails and problems will go away, until next time.
vBulletin Database Error! mysql_connect(): Can't connect to MySQL server on 'sql.datacolony.com' (4) /hsphere/local/home/site/site.com/forum/includes/class_core.php on line 274 MySQL Error : Error Number : Date : Saturday, January 26th 2008 @ 07:53:05 PM Script : [url] Referrer : [url] IP Address : 92.3.190.54 Username : Classname : vb_database
The server is running CentOS 4.6, PHP 4.4.7, MySQL 5.0.45. The vBulletin software has been patched to the latest version. The vBulletin people are not sure why this could be happening.
Well we never believed that the firewall was causing the issue BUT it only started happening on the day the new firewall was installed. So we tried stopping the firewall for a full week and the MySQL database errors stopped happening, completely. So I'm convinced the problem is the firewall blocking MySQL connections but I can't figure out why?
There are no entries in the MySQL .err logs pertaining to this. Can't figure this out, any help or ideas is appreciated since the people who installed the firewall are not sure either.
when i try to install the VB forum it's show me this warning Messege!
Code: Error description: mysql_connect() [function.mysql-connect]: Access denied for user 'user_db'@'localhost' (using password: YES) /home/*****/public_html/includes/class_core.php on line 274
The database has failed to connect because you do not have permission to connect to the server. Please confirm the values entered in the 'includes/config.php' file. how can i fix this problem in Mysql USER ?
Plesk has mysql installed with it to run properly and I need to upgrade that version to the latest. Now I am not talking about the mysql server that it provides for me to create databases on. I am talking about the version it uses to run.
on my Ubuntu 14.04 LTS server, I have ran the install script. This process stopped with the message: ERROR while trying to establish test connection. If you are installing Plesk on an already configured MySQL server, you need to specify the administrator's credentials to succeed with the installation.
To do this, you need to create a file - /root/.my.cnf with the 'client' section where you need to provide user and its password ("user = $admin_name" and "password = $admin_pass").
After installation is finished, the file /root/.my.cnf will be renamed to /root/.my.cnf.bak
Check the error reason(see log file: /var/log/plesk/install/plesk_12.0.18_installation.log), fix and try again
Accordingly, I have the existing my.conf copied to the ROOT directory and added the two missing lines in the client area. After that I started the plesk-installer.sh again. The process stopped at a line
"Installed product components are determined" and nothing still happend. The log files says nothing but the last information at the previous try.
I am trying to install Joomla on httpme.com but I seem to have problems with it recognising the username/password. Could it be a localhost issue or something?
I just can't seem to get a solution to this. I am referring to step 1 of the Joomla installation.
I'm noticed I was getting bounced email errors from a company I was sending email through and I further investigated this by running a dnsreport on my domain.
Turns out that it fails at Acceptance of NULL <> sender, Acceptance of postmaster address, and Acceptance of abuse address. The domain that I ran a test on is using a new IP that I had recently added to my Direct Admin server. None of the other domains on my server are having issues like this.
Is is possible that I need to do something to enable these new IP addresses in exim? I mean, exim obviously responds to that IP address, but it seems to be having some issues with it.
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 am doing the Security Check provided by Config Server Firewall.
It is giving me 3 errors, and I want to fix them, so here they are.
Check /dev/shm is mounted noexec,nosuid /dev/shm is not mounted with the noexec,nosuid options (currently: none). You should modify the mountpoint in /etc/fstab for /dev/shm with those options and remount On this one I actually went and added the noexec,no suid options. Here is what i've got configured and what it looks like. (it's most likely not correct so help correct it.) [url]
Check /etc/named.conf for DNS recursion restrictions
You have a local DNS server running but do not have any recursion restrictions set in /etc/named.conf. If the named process is using this configuration file, then this is a security and performance risk and you should look at restricting recursive lookups to the local IP addresses only
Check dovecot weak SSL/TLS Ciphers (ssl_cipher_list) Cipher list []. Due to weaknesses in the SSLv2 cipher you should disable SSLv2 in WHM > MailSever Configuration > SSL Cipher List > Remove +SSLv2 or Add -SSLv2 Alright so this one I followed the instructions, and i've got everything set correctly but it still shows up on the thing. I don't think the ssl_cipher_list is even available in WHM
I don't know much of anything about server settings or errors, so I need your help. Recently one of my servers have been getting a lot of 500 error messages, and I can't pinpoint the reason or replicate the error on my end. I did some Google searching and although I found out in general what a 500 error is, I still am not clear on what exactly causes them or how to reduce them. Could it be caused by intense amounts of traffic? Is the server just being overloaded?
Also, I see that my server is throwing a lot of 404 errors for a variety of URLs on my site, however when I visit the URLs specified by the error log they work fine for me - seems like only sometimes for whatever reason the server can't find/access them and throws a 404. Again, I can't replicate it and have no clue how to fix it since the list of 404 URLs work fine when I type them in.
I have a VPS account with an hosting site. For the past 2 days i have done a lot of uploads. I have 25+ sites on this account. Today when i try to login into my sites via ftp, its showing ftp login failed for all sites.
The hosting company is still sleeping on my queries regarding this matter.
Interestingly logins for WHM & cpanel for all sites are working fine.
Any experienced members plz guide me on how to get the ftp working to upload files to my sites.
there is "Cannot Resolve Dns" for my site for one or 2 regions .. Everytime i check my site my site with a Website Monitoring site , i get Cannot Resolve Dns for one or two regions .. can anyone please tell me what the problem can be ..
When i go to dnsreport.com , i get Fail in Missing (stealth) nameservers
Quote:
FAIL: You have one or more missing (stealth) nameservers. The following nameserver(s) are listed (at your nameservers) as nameservers for your domain, but are not listed at the parent nameservers (therefore, they may or may not get used, depending on whether your DNS servers return them in the authority section for other requests, per RFC2181 5.4.1). You need to make sure that these stealth nameservers are working; if they are not responding, you may have serious problems! The DNS Report will not query these servers, so you need to be very careful that they are working properly.
ns1.mysite.ws. ns2.mysite.ws. This is listed as an ERROR because there are some cases where nasty problems can occur (if the TTLs vary from the NS records at the root servers and the NS records point to your own domain, for example).
Jun 29 12:35:48 server kernel: Firewall: *TCP_OUT Blocked* IN= OUT=eth0 SRC=(my server ip) DST=(another server IP of mine) LEN=44 TOS=0x00 PREC=0x00 TTL=64 ID=3858 DF PROTO=TCP SPT=33891 DPT=2534 WINDOW=5840 RES=0x00 SYN URGP=0 Jun 29 12:35:49 server kernel: Firewall: *TCP_OUT Blocked* IN= OUT=eth0 SRC=(my server ip) DST=(another server IP of mine) LEN=44 TOS=0x00 PREC=0x00 TTL=64 ID=17089 DF PROTO=TCP SPT=33897 DPT=3306 WINDOW=5840 RES=0x00 SYN URGP=0 Jun 29 12:35:52 server kernel: Firewall: *TCP_OUT Blocked* IN= OUT=eth0 SRC=(my server ip) DST=(another server IP of mine) LEN=44 TOS=0x00 PREC=0x00 TTL=64 ID=17091 DF PROTO=TCP SPT=33897 DPT=3306 WINDOW=5840 RES=0x00 SYN URGP=0 Jun 29 12:35:53 server kernel: Firewall: *TCP_OUT Blocked* IN= OUT=eth0 SRC=(my server ip) DST=(another server IP of mine) LEN=44 TOS=0x00 PREC=0x00 TTL=64 ID=39040 DF PROTO=TCP SPT=33899 DPT=2534 WINDOW=5840 RES=0x00 SYN URGP=0 Jun 29 12:35:56 server kernel: Firewall: *TCP_OUT Blocked* IN= OUT=eth0 SRC=(my server ip) DST=(another server IP of mine) LEN=44 TOS=0x00 PREC=0x00 TTL=64 ID=39042 DF PROTO=TCP SPT=33899 DPT=2534 WINDOW=5840 RES=0x00 SYN URGP=0
Here's the strange thing. The part that says "another server IP of mine" are two different OTHER servers of mine, BUT do not have cpanel nor part of the cluster. What could it be?
Jan 31 04:39:22 servername kernel: ATA: abnormal status 0x7F on port 0xE807 Jan 31 04:39:22 servername kernel: ATA: abnormal status 0x7F on port 0xE007
I had made a page on my site earlier and when i went to it it gave me a 403 error so i tried fixing the .htacess then the site got messed up so i reset the .htacess to tis original settigns and now when i redirect to anything but the home directory it gives me a 403 error can anyone help?
