Forum Activity for @andrusito

alt=
@andrusito
09/24/18 01:17:21PM
300 posts

ERROR: dbConnect() unable to connect to database server "localhost"


Installation and Configuration

thanks, Paul... I did not find /data/config/config.php so this is definitely JR4.

I went to https://archive.jamroom.net/Jamroom4_Change_MySQL_Password again

I do not have a "settings.zip" file but a "settings.tar.gz" file.

I took the steps but I get the same "ERROR: dbConnect() unable to connect to database server "localhost"..." when going to mysite.com/settings.php

changed permissions from 0644 to 777 but I get the same...

Is there any other way to change dB info?
alt=
@andrusito
09/21/18 05:04:33AM
300 posts

Database Size almost 20GB!


Using Jamroom

Thanks! That did bring the data down.

is there a way to clean these?

jr_jrcore_cache (more than 600MB)
jr_jruser_session (about 1,5 GB)(You said "... Deleting this will cause any users logged in to be logged out... but on certain times there are no users logged in)
alt=
@andrusito
09/21/18 04:45:09AM
300 posts

ERROR: dbConnect() unable to connect to database server "localhost"


Installation and Configuration

Thanks, guys...

the thing is I did not find at /data/config/config.php

Yes, I upgraded from JR4 long time ago... but it's installed on main folder, on top of JR4...

Where should be the database details so I can change them?
alt=
@andrusito
09/20/18 05:57:23AM
300 posts

Database Size almost 20GB!


Using Jamroom

Thank you so much for the detailed explanation, that is VERY useful.

However, I still see data inside the log debug table... or that's what I think it is... take a look:
Screenshot (118).png Screenshot (118).png - 275KB
alt=
@andrusito
09/19/18 12:53:43PM
300 posts

ERROR: dbConnect() unable to connect to database server "localhost"


Installation and Configuration

Just today I found one of my sites with this

ERROR: dbConnect() unable to connect to database server "localhost"
MySQL error 1045 - Access denied for user 'mysite_jamroom'@'localhost' (using password: YES)

I tried this but did not work: https://archive.jamroom.net/Jamroom4_Change_MySQL_Password

I guess because I have installed JR5..?
updated by @andrusito: 01/24/19 12:37:50PM
alt=
@andrusito
09/19/18 09:38:52AM
300 posts

Database Size almost 20GB!


Using Jamroom

Thank you, Michael.

I deleted the debug log by going to the location you mentioned and also did another integrity check... but the numbers are the same, nothing was deleted...

Is it safe to delete the info there using Tools / Database Admin?
alt=
@andrusito
09/18/18 05:37:20AM
300 posts

Database Size almost 20GB!


Using Jamroom

Thank you SO much!

I found out the cache table was about 17GB!

now I have these... is there a way to empty the data inside JR?

jr_jrcore_log_debug InnoDB utf8_unicode_ci 272 269 312
jr_jrcharts_history InnoDB utf8_unicode_ci 66 600 960
jr_jruser_item_key InnoDB utf8_unicode_ci 32 079 872
jr_jruser_session InnoDB utf8_unicode_ci 1 581 252 608
alt=
@andrusito
09/17/18 04:28:40PM
300 posts

Database Size almost 20GB!


Using Jamroom

It has come to my attention my database size is 19,635.56 MB!

Is there a way to bring the size down? Where should I start to look?
updated by @andrusito: 12/22/18 09:30:50PM
alt=
@andrusito
05/01/18 05:14:22AM
300 posts

JR sites going down...


Using Jamroom

ok, if the server were the problem, why is there another JR site running without issues?
alt=
@andrusito
04/30/18 07:44:51AM
300 posts

JR sites going down...


Using Jamroom

thanks, but if the guys behind JR cannot figure it out, I hardly believe I can.
  2