internall server error all sites

mamadletsgo

Verified User
Joined
Mar 2, 2015
Messages
69
Location
iran,tehran
hello

all sites to my server show this error

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator at webmaster@ to inform them of the time this error occurred, and the actions you performed just before this error.

More information about this error may be available in the server error log.

my web server is nginx_apache + php-fpm and php version 5.5

this commands entered

cd /usr/local/directadmin/custombuild
./build update
./build apache
./build nginx
./build all d
./build rewrite_confs

im change php version and rebuild all service but this problem not resolve

please help me for solve this problem

thanks
 
my problem is mysql

Error connecting to MySQL: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

How do you fix this?
 
Is mysql running?

There is a way to check things, you can find it here:
https://help.directadmin.com/item.php?id=332

Unfortunately, it was not resolved

this error show in the log (/var/lib/mysql/server.hostname.com.err)

InnoDB: is in the future! Current system log sequence number 204304995349.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
InnoDB: for more information.
2019-03-03 20:06:07 b775f770 InnoDB: Error: page 220 log sequence number 204314780872
InnoDB: is in the future! Current system log sequence number 204304995349.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
InnoDB: for more information.
2019-03-03 20:06:07 b775f770 InnoDB: Error: page 250 log sequence number 204314780983
InnoDB: is in the future! Current system log sequence number 204304995349.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
InnoDB: for more information.
2019-03-03 20:06:07 b775f770 InnoDB: Error: page 29003 log sequence number 204314780983
InnoDB: is in the future! Current system log sequence number 204304995349.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
InnoDB: for more information.
InnoDB: 1 transaction(s) which must be rolled back or cleaned up
InnoDB: in total 0 row operations to undo
InnoDB: Trx id counter is 384873216
190303 20:06:07 [Note] InnoDB: Starting final batch to recover 58 pages from redo log
2019-03-03 20:06:07 99dfbb70 InnoDB: Error: page 27720 log sequence number 204307298169
InnoDB: is in the future! Current system log sequence number 204304995349.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
InnoDB: for more information.
2019-03-03 20:06:07 9a7fcb70 InnoDB: Error: page 31274 log sequence number 204314779475
InnoDB: is in the future! Current system log sequence number 204304995349.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See^

and this error show when service mysqld restarat

ERROR! MariaDB server PID file could not be found!
Starting MariaDB.190303 21:03:19 mysqld_safe Logging to '/var/lib/mysql/server.hostname.com.err'.
190303 21:03:19 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
./etc/init.d/mysqld: line 260: kill: (9281) - No such process
ERROR!

Please help me solve the problem

thanks
 
i'm created backup to directory /var/lib/mysql

and entered this command for install again mysql

cd /usr/local/directadmin/scripts
./mysql.sh rootpass da_admin daadminpass

cd /usr/local/directadmin/custombuild
./build roundcube

but after entered this command is not resolve my problem !!

ERROR! MariaDB server PID file could not be found!
Starting MariaDB.190304 00:17:46 mysqld_safe Logging to '/var/lib/mysql/server.hostname.err'.
190304 00:17:47 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
....../etc/init.d/mysqld: line 260: kill: (17450) - No such process
ERROR!

What can I do to solve the problem?
 
The command you gave is not to install mysql again but to install roundcube again.

Have a look at this first:
https://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html

Which in fact says to put:
Code:
innodb_force_recovery = 1
To /etc/my.cnf under the [mysqld] part and then try to restart mysql.
But don't forget to read the rest of it. Often this could fix things.

If this won't help, you have to wit for somebody else, I'm no mysql guru.
If this helps, don't forget to create a backup of the databases first.
 
If MySQL InnoDB is corrupted, you should probably do a fresh installation of MySQL, as there too little chances to recover it if you've never done it before. So you should do something like this: https://help.directadmin.com/item.php?id=559

1. find the latest backups, dumps

2. Move old directory

Code:
mv [COLOR=#333333]/var/lib/mysql [/COLOR][COLOR=#333333]/var/lib/mysql.moved

3. and then install a fresh copy with

[/COLOR]
Code:
/usr/local/directadmin/scripts/mysql.sh

see your password here /usr/local/directadmin/conf/mysql.conf:

Code:
/usr/local/directadmin/scripts/mysql.sh mysqlrootpass da_dbuser da_pass

4. update MySQL version with custombuild

Code:
cd /usr/local/directadmin/custombuild/
./build mysql

5. And then re-import backups, see step #5 https://help.directadmin.com/item.php?id=559

 
thanks for answer

but my problem not resolved :(

i entered all commands but when restart mysql show this error

ERROR! MariaDB server PID file could not be found!
Starting MariaDB.190304 10:41:06 mysqld_safe Logging to '/var/lib/mysql/server.hostname.com.err'.
190304 10:41:06 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
/etc/init.d/mysqld: line 260: kill: (16244) - No such process
ERROR!

:(

# /usr/local/directadmin/scripts/mysql.sh
Usage: /usr/local/directadmin/scripts/mysql.sh mysqlrootpass da_dbuser da_pass
*** do not use spaces in your passwords ***
[root@server2 scripts]# /usr/local/directadmin/scripts/mysql.sh mysqlrootpass da_dbuser da_pass

*****************************************************
*****************************************************

It seems as though mysql has already been installed.
The directory /var/lib/mysql has been found. For the best results, its recommended that this be deleted.
All database data will be lost if you delete it

Do you want to delete it? (y is recommended)? (y,n) : y
mv: cannot move `/var/lib/mysql' to `/var/lib/mysql.backup/mysql': Directory not empty
Installing MySQL
Preparing... ########################################### [100%]

******************************************************************
A MySQL server package (MariaDB-server-10.0.38-1.el6.i686) is installed.

The current MySQL server package is provided by a different
vendor (Monty Program AB) than MySQL AB, Sun Microsystems, Inc., or Oracle and/or its affiliates.
Some files may be installed to different locations, including log
files and the service startup script in /etc/init.d/.

Upgrading directly from MySQL 10.0 to MySQL 5.5 may not
be safe in all cases. A manual dump and restore using mysqldump is
recommended. It is important to review the MySQL manual's Upgrading
section for version-specific incompatibilities.

A manual upgrade is required.

- Ensure that you have a complete, working backup of your data and my.cnf
files
- Shut down the MySQL server cleanly
- Remove the existing MySQL packages. Usually this command will
list the packages you should remove:
rpm -qa | grep -i '^mysql-'

You may choose to use 'rpm --nodeps -ev <package-name>' to remove
the package which contains the mysqlclient shared library. The
library will be reinstalled by the MySQL-shared-compat package.
- Install the new MySQL packages supplied by Oracle and/or its affiliates
- Ensure that the MySQL server is started
- Run the 'mysql_upgrade' program

This is a brief description of the upgrade process. Important details
can be found in the MySQL manual, in the Upgrading section.
******************************************************************
error: %pre(MySQL-server-5.5.31-1.linux2.6.i386) scriptlet failed, exit status 1
error: install: %pre scriptlet failed (2), skipping MySQL-server-5.5.31-1.linux2.6
Preparing... ########################################### [100%]
1:MySQL-client ########################################### [100%]
Preparing... ########################################### [100%]
1:MySQL-devel ########################################### [100%]
ls: cannot access /var/lib/mysql/mysql/: No such file or directory
Data needs to be created in /var/lib/mysql/mysql ...
Neither host 'server.hostname.com' nor 'localhost' could be looked up with
'/usr/sbin/resolveip'
Please configure the 'hostname' command to return a correct
hostname.
If you want to solve this at a later stage, restart this script
with the --force option

The latest information about mysql_install_db is available at
https://mariadb.com/kb/en/installing-system-tables-mysql_install_db
usermod: no changes
Starting MariaDB.190304 10:57:13 mysqld_safe Logging to '/var/lib/mysql/server.hostname.com'.
190304 10:57:14 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
.../etc/init.d/mysqld: line 260: kill: (17311) - No such process
ERROR!
Waiting for mysqld to start....
Setting MySQL Root Password...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Setting DirectAdmin user and password...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Securing installation...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)


plese help me ...

thanks
 
1. See Upgrading directly from MySQL 10.0 to MySQL 5.5 may not be safe in all cases.

Well, before installing MySQL/MariaDB from a scratch you should make sure and remove all mysql/mariadb rpm-packages.

2. See /usr/local/directadmin/scripts/mysql.sh mysqlrootpass da_dbuser da_pass

I hope you replaced the passwords with your values and did not use the listed here.

3. See Neither host 'server.hostname.com' nor 'localhost' could be looked up with '/usr/sbin/resolveip' Please configure the 'hostname' command to return a correct
hostname.
You should set a correct hostname.

Please note, the all errors are taken from your post, you should really read carefully all outputs or get someone to fix it for you via SSH.
 
Back
Top