About building notes using the Dede template website

2016.9.8

Company database File Import

Steps:

Export the SQL file from the Web site,

Using Xshell to pull into Linux,

Enter the database

First create a database and enter,

Set names UTF8; support Chinese

The source file path is imported in the database

Describe viewing the format of a table

flush privileges; Refresh the database

2016.9.9

Yesterday afternoon build httpd website, support PHP run,

Deploy the PHP environment first,

The last website can run,

Website management interface Can't get in

But the database is not connected.

By finding some information about the development of the Dede website

Finally find the password link of the database under the site root directory

data/common.inc.php

Replace the contents of the database with the basic information of my own database,

Now OK

Note: Support PHP run, first deploy the PHP environment, otherwise the loaded page will be all source code

admin password forgot

Enter the table to change the password,

Update dede_admin set pwd= ' **************** ';

The default password is ******,

From September 9, began to tidy up the new site, the company's previous network management said that the deployment of new sites, only need to ftp+phpmyadmin to deploy on OK.

I boarded the FTP only to find that the ftp inside is the old site, now, I understand as, FTP shared files, I need to copy the old website files out of the backup, and replace the new site, restart the service is OK.

So, just replace the new site for three days, the document I must have a copy, or failure. Special trouble, to the Monday, the FTP files are all replaced, I connect the company's server, ready to restart the service, found that services httpd restart and service Nginx Restart can not be used, good, is the source package installed, using the source code to start,/etc/ Init.d/apache Restart, this time up,,.

Previous network management, the company server to the whole of the special mess, do not know the site root directory where, has been LS to find, he told me to use Apapche+nginx, use, but only see Papache run again, nginx in the empty,

But the database this piece, tell me the password is ********, I have been logged in, the password is wrong, the database is not restarted, and finally I see the previous document there is a database of this fast information, holding the mentality of trying, and sure enough boarded.

Connected to the database, modified the background password, into the background only to find the administrator background of the page garbled, I thought is the problem of coding, to encode the idea of a day, and finally really can not find the location of the problem, the supervisor with select * from Dede_admin; found inside is also garbled, that is. The database is garbled from the beginning. So the display is garbled, this is the problem that bothers me a day. Operation and maintenance of this line, is to be careful

Summarize

Corporate Server before environment

apache2.4

php5.3

mysql5.5

Website backstage use is Dede weave dream template

At first, the site backstage is accessible, because I build bugzilla, download Perl module, changed the unknown

Name, the result is a 500 error in the access background, and finally Bugizlla no access rights

, also put that, is a build failure. Now the problem is that the background of the company's website is not going to go, error 500,

Go to Baidu to find documents, know that the server or PHP program caused.

There are several possible causes of 500 errors:

1, is the number of users too much, the server pressure is too large

One eye on the exclusion of the first, the company on a Linux server, also I operate alone, the site also no one to visit

No data is generated in the general database

2. There is no connection in the place where the connection is made.

This possibility, considered for a long time, did not quite understand what to do with the association

There are several possibilities below, and I don't feel so good.

I am thinking now, is not the website file itself out of error,

Then, in their own virtual machine to redeploy the environment, build a website, you can access the background PHP page,

That's a bit weird.

Have checked the related services

I found MSYQL didn't seem to run.

With ps-e| grep MySQL looked at a bit

Sure enough, don't know when, MySQL is in the off state

Quickly restart MySQL

Service mysqld Restart

At this time, the problem came out.

MSYQL can't get up,

Find a lot of documents, one to troubleshoot, and finally no results,

Let me have the idea of reinstalling MySQL, which would have produced

1, I took over the server inside the service, as well as the path, the site root directory, messy,

2, I really do not understand the installation method of MSYQL, a feeling is Yum installed, a will feel the source of packaging

Because, a lot of commands and the location of MySQL configuration files are not number

So Rpm-qa | grep MySQL

Rpm-e

One of the MySQL service packs was uninstalled,

Have manually deleted the configuration file

This piece, because before there was a backup, so no preparation,

Next is the source package to install MySQL

It's not going to last.

Through a few days of troubleshooting, thought might be PHP version wrong

Previously 5.3, now 5.4, incompatible with Dede templates

So the error is not connected to MySQL

So starting from here, found that the second installation of MySQL did not install php-mysql this package

After installation, restart the service.

Successfully resolved

This article from "12178027" blog, declined reprint!

About building notes using the Dede template website