Shulou(Shulou.com)05/31 Report--

Windows platform bugfree3.0.3 build experience is what, for this problem, this article details the corresponding analysis and answer, hope to help more want to solve this problem of small partners to find a simpler and easier way.

I haven't done windows server management before, my understanding is still stopped in the cognition of individual user operating system, this time to build bugfree environment, quite troublesome;

Before installation, most of my bugfree builds were installed using the xampp integrated environment, and then I followed suit:

Download xampp and install it to system c disk. Basic fool-like installation. Then open control-panel and install apache and mysql.(php is included in apache), because this system already has mysql service and apache service running, I don't know who is using the service, so I changed apache port to 81, mysql port to 3308, php.ini and phpMyAdmin configuration changed the installation path and mysql port number, there is always a bit of mess in the middle, The overall reason is that the configuration has not been improved, so I will not repeat it again.

Then according to the online tutorials and so on, download bugfree to hotdocs, start the service, found bugfree unexpectedly can not detect mysql?!!! What the hell? Already have ~~

Start to find the problem at first thought it was the configuration file where there may be no port modification, find a lot of configuration files, all 3306 are changed to 3308, however, and eggs, but start phpMyAdmin can be used, I manually created an index.php, which wrote phpinfo and test function connected to mysql, found the problem, this php connection database is not connected ~, do not know why, and then I check phpinfo found that there is no php mysql module ~? Only mysqli and mysqlndt these two things, the original xampp automatic integration php version is the latest 7.3, and php has long been weakening mysql this module, the default is commented out, to 7.3 this version ext this extension library does not have mysql.dll, but bugfree3.0.3 mysql detection method is required to be able to, I tried to use mysqli and pdo methods, but bugfree how can not detect, so I realized that the integration environment is really not easy to use, No freedom, no software version control, change routine!

I decided to install the software manually, using nginx+php5.6+mysql to build the environment, simple not to repeat, nginx configuration: in my local modified listening port added index.php default delete location php comments, modify the root path of the page file:

client_max_body_size 10M;

#This is the size limit for opening late uploads. By default, it is not set to be 1M or 2M. I forgot... It's not big anyway

server { listen 81; server_name localhost; #charset koi8-r; #access_log logs/host.access.log main; location / { root C:/program/nginx1.10/html; index index.php index.html index.htm; } ......... Omitted here... location ~ \.php$ { root html; fastcgi_pass 127.0.0.1:9000; fastcgi_index index.php; fastcgi_param SCRIPT_FILENAME C:/program/nginx1.10/html$fastcgi_script_name; include fastcgi_params; }

php installation, is the decompression process, php.ini needs to open mysql extension php_mysql.dll, others because later to import the database, so modify the upload file size limit upload_file_xxxx and post_max_size two parameters value;

mysql installation uses the default port 3306, is also basically a fool installation, configuration of a password is over;

3306 The service is operating normally;

Download RunHiddenConsole.exe, which is a console running in the background. Make two copies and place them in the directories of nginx and php respectively.

Create the files start.bat and shutdown.bat and place them under the nginx directory. The content of start is:

@echo offecho start_nginx.batecho Starting PHP FastCGI... cd C:/program/php5.6RunHiddenConsole php-cgi.exe -b 127.0.0.1:9000 -c php.iniecho Starting nginx... cd C:/program/nginx1.10RunHiddenConsole nginx.exeExit

------------

Shutdown is:

@echo offecho stop_nginx.batecho Stopping nginx... taskkill /F /IM nginx.exe > nulecho Stopping PHP FastCGI... taskkill /F /IM php-cgi.exe > nulexit

Note: tasklist is similar to linux ps command, taskkill is the kill process command, here you need to modify is nginx and php path, do not forget this

RunHiddenConsole.exe must be placed in the directory of nginx and php ~~ otherwise it won't start ~ now test the connection between php and mysql in nginx ~, index.php content: test mysql+php+nginx

I have no problem testing here success! If you have problems, please check the connection between php and mysql to see if there is any problem with mysql and configuration in phpinfo. After that, unzip phpMyAdmin and put it under the root of the web. This is used to manage the database. The default one I downloaded is authentication mode. If not, modify the configuration file config.inc.php. Change authxxxx to cookie mode. The user name and password are mysql users and passwords.

Next download bugfree, Unzip bugfree to the root directory of the page file, Create a folder BugFile in the same directory, Then configure the appropriate permissions, Note, Windows platform using nginx web and bugfree must modify a configuration bugfree, Otherwise the path is similar to this C:\program\nginx\html/bugfree/xxxx/xxx slash is two directions, Especially pit, I also get a long time will not, Consult other people php development to know, The reason or do not understand, But will modify,/protected/config/main.php code in this part of the comment out: (/* xxx */multi-line comments)

'urlManager' => array ('urlFormat' => 'path','showScriptName' => false,'rules' => array ('//' => 'info/edit','/list/' => 'info/index','/' => 'info/edit','/view/' => '/view','/' => '/view','//' => '/','/' => '/',),),

Then you can visit ~, if there is a visit to bugfree index.php jump index.php/site/login 404 situation, so solve ~!

When importing the database, there are pits. If the bugfree export database is compressed in zip format, try to extract this file when importing it, and then use mysql client source to enter (when the size is limited, modify the configuration of nginx, see above, php two parameter configuration, see above), otherwise it always fails.

About windows platform bugfree3.0.3 build experience is what the answer to the problem is shared here, I hope the above content can be of some help to everyone, if you still have a lot of doubts not solved, you can pay attention to the industry information channel to learn more related knowledge.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.