Nginx install dbase error
Installation and Configuration
The version was 5.2.41 on my end. I will try the beta version. I just downloaded what was on the main page of Jamroom for all my test installs.
updated by @jimmy: 12/21/15 03:08:33PM
Forum Activity for @jimmy
Nginx install dbase error
Installation and Configuration
I got a reply back from the CENTMINMOD developer.
Quote:
Centmin Mod out of box /etc/my.cnf templates should of taken care of that in /etc/my.cnf with
Code (Text): innodb_large_prefix=1
Centmin Mod out of box /etc/my.cnf templates should of taken care of that in /etc/my.cnf with
Code (Text): innodb_large_prefix=1
Nginx install dbase error
Installation and Configuration
I can confirm that error. Didn't even think about checking the PHP error log. Good catch!
PHP Fatal error: Call to undefined function jruser_session_start() in /home/nginx/domains/10.0.0.151/public/modules/jrCore/router.php on line 90My system specs for the install
PHP 7.0.1 (first test)
PHP 5.6.16 (multiple tests)
Centos 7
MariaDB 10
updated by @jimmy: 12/21/15 02:42:10PM
Nginx install dbase error
Installation and Configuration
b360:
I am having this same error during a new install. I have jamroom installed on this server already working fine with various domains. However when I added a new domain today and I received this error.
I tried checking permissions, and different versions of Jamroom (5.2) yet nothing helps. I do have the Jamroom 5.3 beta installed on this server also.
I am having this same error during a new install. I have jamroom installed on this server already working fine with various domains. However when I added a new domain today and I received this error.
I tried checking permissions, and different versions of Jamroom (5.2) yet nothing helps. I do have the Jamroom 5.3 beta installed on this server also.
What's your system? Apache?
Nginx install dbase error
Installation and Configuration
I tried a few more things.
Made some setting changes in the my.cnf
Tried to install JR non-SSL
Both yielded the same results.
If you can think of anything else I can try, please let me know.
Nginx install dbase error
Installation and Configuration
Just so that it's posted here. This is the current vhost file I'm using with CENTMINMOD LEMP. If someone reading this wants to test out the install on Centminmod, to try to help solve this problem, you can use this demo vhost file.
# Jamroom Working NGINX site conf file
# This file is for a FORCED SSL site. Non-SSL requests will be directed to SSL.
# Jamroom forum thread: https://www.jamroom.net/the-jamroom-network/forum/off-topic/35854/jamroom-and-nginx-centmin-mod-lemp-stack
# Centminmod forum thread:
# 10.0.0.151 is a demo IP. Replace with your domain. Example: yourdomain.com
# Redirect to HTTPS from port 80
# Redirect from www to non-www with forced SSL
server {
listen 80;
server_name 10.0.0.151;
return 301 https://10.0.0.151$request_uri;
# Access and Error Logs
access_log /home/nginx/domains/10.0.0.151/log/access_via80.log combined buffer=256k flush=60m;
error_log /home/nginx/domains/10.0.0.151/log/error_via80.log;
}
server {
listen 443 ssl http2;
server_name 10.0.0.151;
root /home/nginx/domains/10.0.0.151/public;
ssl_dhparam /usr/local/nginx/conf/ssl/10.0.0.151/dhparam.pem;
ssl_certificate /usr/local/nginx/conf/ssl/10.0.0.151/10.0.0.151.crt;
ssl_certificate_key /usr/local/nginx/conf/ssl/10.0.0.151/10.0.0.151.key;
include /usr/local/nginx/conf/ssl_include.conf;
# Mozilla Recommended
ssl_ciphers ECDHE-ECDSA-CHACHA20-POLY1305:ECDHE-RSA-CHACHA20-POLY1305:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-AES256-GCM-SHA384:DHE-RSA-AES128-GCM-SHA256:DHE-DSS-AES128-GCM-SHA256:kEDH+AESGCM:ECDHE-RSA-AES128-SHA256:ECDHE-ECDSA-AES128-SHA256:ECDHE-RSA-AES128-SHA:ECDHE-ECDSA-AES128-SHA:ECDHE-RSA-AES256-SHA384:ECDHE-ECDSA-AES256-SHA384:ECDHE-RSA-AES256-SHA:ECDHE-ECDSA-AES256-SHA:DHE-RSA-AES128-SHA256:DHE-RSA-AES128-SHA:DHE-DSS-AES128-SHA256:DHE-RSA-AES256-SHA256:DHE-DSS-AES256-SHA:DHE-RSA-AES256-SHA:AES128-GCM-SHA256:AES256-GCM-SHA384:AES128-SHA256:AES256-SHA256:AES128-SHA:AES256-SHA:AES:CAMELLIA:DES-CBC3-SHA:!aNULL:!eNULL:!EXPORT:!DES:!RC4:!MD5:!PSK:!aECDH:!EDH-DSS-DES-CBC3-SHA:!EDH-RSA-DES-CBC3-SHA:!KRB5-DES-CBC3-SHA:!CAMELLIA:!DES-CBC3-SHA;
ssl_prefer_server_ciphers on;
#add_header Strict-Transport-Security "max-age=31536000; includeSubdomains;";
#add_header X-Content-Type-Options "nosniff";
#add_header X-Frame-Options DENY;
ssl_buffer_size 1400;
ssl_session_tickets on;
# ngx_pagespeed & ngx_pagespeed handler
# include /usr/local/nginx/conf/pagespeed.conf;
# include /usr/local/nginx/conf/pagespeedhandler.conf;
# include /usr/local/nginx/conf/pagespeedstatslog.conf;
# Limit Connections Per IP Address
# Modified from default to allow Admin directory to have more connections
# Modified in nginx.conf
# limit_conn_zone $limitconn_map zone=limit_per_ip:16m;
# ssi on;
# Access and Error Logs
access_log /home/nginx/domains/10.0.0.151/log/access_via443.log combined buffer=256k flush=60m;
error_log /home/nginx/domains/10.0.0.151/log/error_via443.log;
# Prevent access to ./directories and files
#location ~ (?:^|/)\. {
# deny all;
#}
location / {
# block common exploits, sql injections etc
# include /usr/local/nginx/conf/block.conf;
# Enables directory listings when index file not found
# autoindex on;
# Shows file listing times as local time
autoindex_localtime on;
index index.html index.php sitemap.xml $uri/modules/jrCore/router.php;
try_files $uri $uri/modules/jrCore/router.php?_uri=$1;
rewrite ^(.*)$ /modules/jrCore/router.php?_uri=$1;
}
#location ^(.*)$ {
# try_files $uri /modules/jrCore/router.php?_uri=$query_string;
#}
include /usr/local/nginx/conf/staticfiles.conf;
include /usr/local/nginx/conf/php.conf;
include /usr/local/nginx/conf/drop.conf;
#include /usr/local/nginx/conf/errorpage.conf;
include /usr/local/nginx/conf/vts_server.conf;
}
updated by @jimmy: 12/20/15 05:03:38PM
Nginx install dbase error
Installation and Configuration
Created a new database. Uploaded new files to the public folder. Got the install page, used root instead of the user and got the same results. Note: In the results below I didn't remove the jrBlog and jrPages modules which were giving me an issue when I installed (though the issue is still there).
MariaDB [jr5]> show tables;
+----------------------------+
| Tables_in_jr5 |
+----------------------------+
| jr_jraction_item |
| jr_jrblog_item |
| jr_jrcore_cache |
| jr_jrcore_count_ip |
| jr_jrcore_form |
| jr_jrcore_form_session |
| jr_jrcore_item |
| jr_jrcore_log |
| jr_jrcore_log_debug |
| jr_jrcore_menu |
| jr_jrcore_modal |
| jr_jrcore_module |
| jr_jrcore_pending |
| jr_jrcore_pending_reason |
| jr_jrcore_performance |
| jr_jrcore_play_key |
| jr_jrcore_queue |
| jr_jrcore_setting |
| jr_jrcore_skin |
| jr_jrcore_temp |
| jr_jrcore_template |
| jr_jrfollower_item |
| jr_jrmailer_throttle |
| jr_jrmarket_channel |
| jr_jrmarket_install |
| jr_jrmarket_system |
| jr_jrpage_item |
| jr_jrprofile_item |
| jr_jrprofile_profile_link |
| jr_jrprofile_quota |
| jr_jrprofile_quota_setting |
| jr_jrprofile_quota_value |
| jr_jrsearch_fulltext |
| jr_jrsearch_item |
| jr_jruser_cookie |
| jr_jruser_device |
| jr_jruser_forgot |
| jr_jruser_item |
| jr_jruser_language |
| jr_jruser_session |
| jr_jruser_url |
+----------------------------+
41 rows in set (0.00 sec)
updated by @jimmy: 12/20/15 05:14:10PM
Nginx install dbase error
Installation and Configuration
brian:
It doesn't make sense then that it's not working from the installer - that's the query it creates.
It doesn't make sense then that it's not working from the installer - that's the query it creates.
YEA! I was up to 4am trying to figure this out. Weirdest thing. I need that Staples "Easy" button!
Nginx install dbase error
Installation and Configuration
I can try the root creds later today when I get back from an Xmas party. I will report back my findings from that when I do it.
Thanks Brian for helping out. I'm sure this is going to end up getting solved at some point.
Nginx install dbase error
Installation and Configuration
I just deleted the dbase and created a new one. Added all the permissions, etc.
Logged into the mysql server with
mysql --user=peachpum --password=0HSnJWDFIlUfKI1VsLhu jr5
Result of running your code above.
MariaDB [jr5]> CREATE TABLE `jr_jruser_item_key` (
-> `_item_id` int(11) unsigned NOT NULL DEFAULT '0',
-> `key` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
-> `index` smallint(5) unsigned NOT NULL DEFAULT '0',
-> `value` varchar(512) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
-> PRIMARY KEY (`key`,`_item_id`,`index`),
-> KEY `_item_id` (`_item_id`),
-> KEY `index` (`index`),
-> KEY `value` (`value`(255))
-> ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
Query OK, 0 rows affected (0.06 sec)
MariaDB [jr5]> show tables;
+--------------------+
| Tables_in_jr5 |
+--------------------+
| jr_jruser_item_key |
+--------------------+
1 row in set (0.00 sec)
MariaDB [jr5]> Ctrl-C -- exit!
