Forum Activity for @jimmy

jimmyk
@jimmy
12/20/15 09:44:31AM
514 posts

Nginx install dbase error
Installation and Configuration

brian:
jimmyk:
Sorry, I updated my last post with what I use to grant the permissions in mysql server.

When you created the table above from the MariaDB CLI - did you do that as the root user?

Now that you mention that, yes I did.
jimmyk
@jimmy
12/20/15 09:40:42AM
514 posts

Nginx install dbase error
Installation and Configuration

Sorry, I updated my last post with what I use to grant the permissions in mysql server.
jimmyk
@jimmy
12/20/15 09:37:48AM
514 posts

Nginx install dbase error
Installation and Configuration

I use

GRANT ALL PRIVILEGES ON jr5. * TO 'peachpum'@'localhost';

So that should allow for creating anything.
updated by @jimmy: 12/20/15 09:39:06AM
jimmyk
@jimmy
12/20/15 09:31:41AM
514 posts

Nginx install dbase error
Installation and Configuration

Results:

MariaDB [(none)]> use jr5
Database changed
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]>



MariaDB [jr5]> show tables;
+--------------------+
| Tables_in_jr5      |
+--------------------+
| jr_jruser_item_key |
+--------------------+
1 row in set (0.00 sec)

MariaDB [jr5]>

updated by @jimmy: 12/20/15 09:32:58AM
jimmyk
@jimmy
12/20/15 09:25:10AM
514 posts

Nginx install dbase error
Installation and Configuration

Got a post back from the developer of Centminmod:

Quote: early MariaDB 5.5 installs had this, MariaDB 10 with 123.08 stable and higher switched to enable InnoDB by default

https://community.centminmod.com/posts/22756/
jimmyk
@jimmy
12/20/15 09:18:09AM
514 posts

Nginx install dbase error
Installation and Configuration

I have all the errors going to log-error=/var/log/mysqld.log in the my.cnf

[mysqld_safe] 
socket=/var/lib/mysql/mysql.sock
log-error=/var/log/mysqld.log
#nice = -5
open-files-limit = 8192

Output:

(snipped)
updated by @jimmy: 12/20/15 09:20:18AM
jimmyk
@jimmy
12/20/15 08:24:37AM
514 posts

Nginx install dbase error
Installation and Configuration

brian:
My guess here based on the tables showing is that you do NOT have the InnoDB engine enabled - make sure InnoDB is an enabled engine in MariaDB.

Let me know if that helps.

InnoDB engine is enable and is actually the default engine. You can see in the my.cnf above that the engine is enabled.

I tested with the InnoDB engine enabled and disabled. No luck.





updated by @jimmy: 12/20/15 08:57:50AM
jimmyk
@jimmy
12/19/15 10:21:52PM
514 posts

Nginx install dbase error
Installation and Configuration

For some reason it's skipping tables. Why would it create some tables and not others? I even went in and switched the default to MyISAM just to see if that might be the issue. Below are the tables JR created with a "successful" install - successful meaning that I got to the "success" page - after removing the jrPages and jrBlog modules which would give me an error during the install.

MariaDB [jr5]> show tables;
+----------------------------+
| Tables_in_jr5 |
+----------------------------+
| jr_jraction_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_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 |
+----------------------------+
39 rows in set (0.00 sec)

I appear to have the re-writes working in the vhost conf file. I'm getting a successful routing to the installer, create account, login, create new account, etc. Why it's creating some and not all the tables is beyond me, unless those tables have something special about them which is forcing some kind of skip.

I've also checked the mysqld.log and the site error_log file to see if anything was showing up, nothing out of the ordinary. The error log is showing some broken image files, but that's probably a specific re-write issue I have to handle when and if I get JR working.

I'm not getting any help from the CENTMINMOD developer, he doesn't have time to test out JR (he's never even heard of it). Every other piece of software works fine on CENTMINMOD - IPB, Xenforo, VB, Wordpress, Drupal, etc.

I did my last test with very minor tweaks to CENTMINMOD and the initial install test of JR was done with STOCK Centminmod install. I only did tweaks after I will still getting the errors.

At this point, I'm kinda stuck. I'm really out of energy creating a new database every time the install fails to create the tables I need to have the site working. I really would love to get this working for everyone. Any help with this would be much appreciated.
updated by @jimmy: 12/19/15 10:34:42PM
jimmyk
@jimmy
12/19/15 01:29:41AM
514 posts

Nginx install dbase error
Installation and Configuration

Attached is the my.cnf file I'm using if anyone wants to take a gander.
my.zip - 2KB
jimmyk
@jimmy
12/19/15 01:17:43AM
514 posts

Nginx install dbase error
Installation and Configuration

Hmmm... wonder how I should proceed with this one. Didn't have any problems with the other scripts I installed, they're all working no db issues. The only thing I can think of besides something in the my.cnf would be that I'm using the same user for this dbase as another dbase. I could create a new user, maybe for some strange reason that is affecting the DB.

Do you know of any setting in the my.cnf that might need to be changed for JR. Maybe I have something set too low?

The only thing I changed was the session.serialize_handler from igbinary to php which I need for IPB, but that's PHP related. I can't really see how that would be an issue. I'll mention nevertheless.

Maybe tomorrow, it's late here on the US east coast, I'll create a new VM with stock settings. Try to install JR again. Though, this local machine is pretty much stock right now.
updated by @jimmy: 12/19/15 01:18:46AM
  33