estan

Hi guys, I recently moved to a new server + updated to latest IPS. On my old server the security was not maintained well and the server was pretty old - 7-9 years old Linux with no updates. Because of that I suspect my Uploads folder was hacked somehow. In the Uploads folder I noticed 2, it looks like malicious scripts: c99madshell.php and shell.php. When I try to download them my antivirus blocks them 🙂 I renamed them now and I hope this fixes the main issue. But there are some consequences I think that I need to deal with and clean further and ensure this is not happening again. In the Upload folder I have 25k+ files and folders and I need to understand what is really needed + it is part of IPS and what is due to the hack. I have: - 96 folders - with numbers, like 1188391108. I guess this is normal, right? - I have 21 folders with JS, gallery, emoticons and few more it seems system stuff. I assume this is normal, right? - 162 folders like monthly_2021_10 - this is normal, I'm pretty sure; these are monthly uploads - 2500+ png files with numbers for titles, like ff812dd57bef267ce49605e7f32b8b5c.png. Is this normal? - 17k+ files in jpg in format like: 000350f0a7e8513606596d0bf4e7a394.jpg Is this normal? I hardly doubt it. Or are these images uploaded by forum users? Seem to be too many to me - 10+ zip files like this: 664f232715c7811bfca59a09bc6e15f9.zip. Total of 454 MB? Seems they are automatically generated and added. Is this normal? It does not seem to me. Did the script somehow created a cron to generate these files and later someone to download them maybe? Or there is more reasonable explanation I hope? - I also have some other files in format likes: 1268c864fc8cfabe7e2fe7ab1a57ff65.txt, av-6495.txt, 00e917845c1d7d5746d61bd0a2681fc4.gif, av-10074.gif, 74e4d649f14099afd772b791faf5173b-32DevChanges - Front End Skin.pdf, default_3d_141.gif (I think this is editor extra emoticons), photo-4570_thumb.png. I assume most of these are fine. Please look directly at my server and let me know which files/folders I can directly delete. I followed all security advices (disable PHP functions etc etc) from the Support system and I'm on a new VPS, so it should be much better now. Any further suggestions or advise please?

@Daniel FI check the advertisements and I noticed I have few google ads here and also a banner. Can you please clarify for me how does this represent a security/support problem? Should I improve the code somehow? Use advertisements in some other way or what to do? It is not clear to me why I get this warning message and what I should do about it. For the Editor message, it has extra 2 fields added before (font and size). I also do not understand why this is a security / support problem and warning. Please clarify.

Yes, this is what I'm already doing @Marc Stridgen. I will send you the name in Private Message, so you can take a look. And please let me know how to fix this.

@Mark H Thank you very much! This is helpful. Maybe a warning in Support page for old unapdated / disabled apps would be nice feature to have in such cases.

@Marc Stridgen it is done Please have a look and let me know if there is anything further that needs to be done.

Can we have Pages template for this - index + article? @Marc Stridgen or anyone else from the team. Looks really cool!

Hi guys, I did the upgrade from 4.3 to 4.6.7 yesterday and I keep checking different items in the admin panel to ensure all is ok. One of the things I noticed is that during the upgrade the Systems Logs in the admin panel grew with like 130+ pages. Seems most of these are: template_error and uncaught_exception. Is this normal? Anything I should do about it? All seems to be working find with the community so far (except some images in posts that do not load for ome reason). Or could this be because of people trying to access the software until I do the upgrade maybe?

Hi guys, In the get support admin section I see that I have 12 third party customizations: - Customized Editor - 11 ads I do not remember customizing the Editor to be honest, except some emoticons maybe. Also I'm not sure what 11 ads means. I have the option to disable these customizations. But if I disable will they be kept and I can enable again? Also how exactly I can know where these customizations are, so I can go and check if they are still relevant. I'm using IPS for many years and I do not remember at all what I have customized and where.

@Marc Stridgen It looks like you are right, it seems like caching issue. Now all seems to be fine, even though it was not the last time I checked and modified few items. But there is one more thing. My forum is located in /board/ and my index is in / When I put the first menu item to point to /, after I save it will automatically add /board/ at the end of the URL and I can not seem to change this in any way. Even though this is an external link menu item. Any way to fix this?

Thank you, I will follow the instructions here:

I did not change the domain, but I added SSL certificate and I changed URL to https google auth details - where I should change this? And what / how to change? I do not seem to be find it in the admin panel, @Daniel F

Hi there,I recently moved to new VPS + upgraded from 4.3 to 4.6. I have some problem with connecting to Google in my Account Settings (frontend). I click the Sign In with Google button and I got an Error Any suggestions how to fix this? It seems it is somehow OAuth related.

Hi there, I recently moved to new VPS + upgraded from 4.3 to 4.6. I have some problem with the Admin -> Site Features -> Menu Manager Steps to Reproduce: 1. Admin -> Site Features -> Menu Manager 2. Click Main Menu Item (with a link to a page on my website) 3. I change the link from http://mydomain.com/pagename to https://mydomain.com/pagename 4. I click Save Menu Item 5. I click Publish this Menu and I see a message: Your menu changes are now live Current Result I go to the site home, click the link and it is still the old one; sometimes change works, sometimes it does not; I tried to change in the DB in the table, but does not seem to work as well Expected Result Link should be changed appropriately Any suggestions how to fix this? Any permission problem in the files or DB? Any special caching or option I'm not aware of? Or is this a bug maybe?

I did the upgrade and all seems to be fine. Index outside of /board/ is still ok. So, page index from Pages is still loading from / instead of /board/. Actually it loads from both, but that is fine. /articles is now redirected to /board/articles; same for other DBs. While not ideal, it is ok Thank you!

Also, if I go with the /board/ option and now I have the tunneling outside of board for index + articles + others, during/after the upgrade any recommendations? What should I do or not do? Should I change some settings or files (like .htaccess in /) before the upgrade? Or what I should do after the upgrade? Any specific instructions, tips or recommendations? @Jim M or anyone else maybe?

Thank you! This is helpful. However, this is not most probably how I will proceed for now. Most probably I will keep the board/ at least for now. But if at some point in the future I want to move everything to / , I just move the files & folders from /board/ and then change conf_global.php and Data Storage path in admin panel. Anything else needed?

What about if I do not want to move the files to the / ? What are my options then to still keep index page, articles etc?

@Marc Stridgen thank you for your reply! Yeah, it seems that I misread the guide. It is from 3 to 4.x. Thank you anyway! Can you clarify further this point please? Now I have the following setup. - IPS is installed in /board/ - using pages, I have / - index page simulated/loading in root - using pages, I haver /articles - also loading outside of board - using pages, I have multiple other databases Are you saying that after the upgrade, it will not be possibly any more to have index page outside of /board/? And also that I will not be able to have /articles? What would I have instead? Would it be: board/articles and board/index.php? No any workaround about this to have it as it was before in previous versions?

Hi guys, I'm will be upgrading from 4.3 to 4.6 soon. I moved to a new server and now planning to do a test install first to ensure all is ok. Few questions guys: 1. I checked the Upgrade Guide and it says: Can you please clarify where I should doublecheck this? I checked conf_global.php and also Admin -> Advanced Configuration -> Data Storage Both seems to be ok. Any other URLs or Storage Paths that I need to check to ensure a smooth upgrade? I do not understand this to be honest 2. As I understand after upgrading to 4.6 the language translation will be totally lost and I will need to translate from scratch again. Is this correct? 3. My tables collation is utf8_general_ci. All tables are the same collation as well. Would that still require an upgrade? 4. I should re-build / resave ALL pages + blocks built with ip.Content? I have plenty. And if not, they will not work? 5. My forum now is in a subfolder and I use ip.content with .htaccess to show a homepage outside of the forum folder, index page. I will be able to keep that after the upgrade, right? 6. Anything else I should know about (besides the requirements checker and making files/db backup) before upgrading from 4.3 to 4.6?

Thank you for your reply, @Marc Stridgen! I did some further research and I noticed in the forum there are multiple posts of people using MariaDB. So, at first look, it seems it would be safe to use it. Any plans by chance to support MariaDB officially in the near future?

Hi guys! I'm in the process of moving my IPS community to a shiny new VPS. I was about to start the move today, but in the last minute, when I asked the hosting company which MySQL version they support (to ensure it will work with IPS 4.6), they told me that they have MariaDB 10.1. They say, this is the same as MySQL 5.6. However, I never heard of MariaDB before. I did a bit of research, but I'm still a bit confused. Is it safe and ok to use IPS with MariaDB 10.1? Any cons, problems or challenges I can expect? Any comments on this? I have IPS 4.3.3 now on my old server and planning to upgrade to latest IPS 4.6 version as soon as I move to the new VPS. Would appreciate your help!

Thank you! This helps a lot!

Well, this is a old Debian 7.11 dedicated server with PHP 5.6 and MySQL 5.6. I plan to move now to a new modern VPS server. Any recommendations for how to do the move?; Should I upgrade first PHP + MySQL (and if so to which versions?) and upgrade IPS to latest stable version and then move to the VPS? OR Move to the VPS first and then upgrade? Any other recommendations?

Thank you very much for letting me know @Mark H! It is helpful to know that I can delete all the content of the folder fully. Here are some entries in one of the exception files: 2021_10_07_uncaught_exception.php Any further advice here? Thu, 07 Oct 2021 01:02:48 +0000 IPS\Db\Exception: Too many connections (1040) #0 /home/mysite/public_html/board/system/Db/Db.php(119): IPS\_Db::_establishConnection('IPS\\Db', Array, false) #1 /home/mysite/public_html/board/system/Data/Cache/None.php(119): IPS\_Db::i() #2 /home/mysite/public_html/board/system/Dispatcher/Front.php(424): IPS\Data\Cache\_None->getWithExpire('page_c68a64d368...', true) #3 /home/mysite/public_html/board/system/Dispatcher/Front.php(38): IPS\Dispatcher\_Front->checkCached() #4 /home/mysite/public_html/board/system/Dispatcher/Dispatcher.php(103): IPS\Dispatcher\_Front->init() #5 /home/mysite/public_html/board/index.php(13): IPS\_Dispatcher::i() #6 {main} #0 /home/mysite/public_html/board/init.php(533): IPS\_Log::log('\nIPS\\Db\\Excepti...', 'uncaught_except...') #1 [internal function]: IPS\IPS::exceptionHandler(Object(IPS\Db\Exception)) #2 {main} ------------- Thu, 07 Oct 2021 01:02:48 +0000 IPS\Db\Exception: Too many connections (1040) #0 /home/mysite/public_html/board/system/Db/Db.php(119): IPS\_Db::_establishConnection('IPS\\Db', Array, false) #1 /home/mysite/public_html/board/system/Data/Cache/None.php(119): IPS\_Db::i() #2 /home/mysite/public_html/board/system/Dispatcher/Front.php(424): IPS\Data\Cache\_None->getWithExpire('page_bfcf30f9ae...', true) #3 /home/mysite/public_html/board/system/Dispatcher/Front.php(38): IPS\Dispatcher\_Front->checkCached() #4 /home/mysite/public_html/board/system/Dispatcher/Dispatcher.php(103): IPS\Dispatcher\_Front->init() #5 /home/mysite/public_html/board/index.php(13): IPS\_Dispatcher::i() #6 {main} #0 /home/mysite/public_html/board/init.php(533): IPS\_Log::log('\nIPS\\Db\\Excepti...', 'uncaught_except...') #1 [internal function]: IPS\IPS::exceptionHandler(Object(IPS\Db\Exception)) #2 {main} ------------- Thu, 07 Oct 2021 01:03:17 +0000 IPS\Db\Exception: Too many connections (1040) #0 /home/mysite/public_html/board/system/Db/Db.php(119): IPS\_Db::_establishConnection('IPS\\Db', Array, false) #1 /home/mysite/public_html/board/system/Data/Cache/None.php(119): IPS\_Db::i() #2 /home/mysite/public_html/board/system/Dispatcher/Front.php(424): IPS\Data\Cache\_None->getWithExpire('page_5b623adba6...', true) #3 /home/mysite/public_html/board/system/Dispatcher/Front.php(38): IPS\Dispatcher\_Front->checkCached() #4 /home/mysite/public_html/board/system/Dispatcher/Dispatcher.php(103): IPS\Dispatcher\_Front->init() #5 /home/mysite/public_html/board/index.php(13): IPS\_Dispatcher::i() #6 {main} #0 /home/mysite/public_html/board/init.php(533): IPS\_Log::log('\nIPS\\Db\\Excepti...', 'uncaught_except...') #1 [internal function]: IPS\IPS::exceptionHandler(Object(IPS\Db\Exception)) #2 {main} ------------- Thu, 07 Oct 2021 02:28:26 +0000 SELECT * FROM `ibf_core_members` AS `core_members` WHERE `member_id`=11723 IPS\Db\Exception: Lost connection to MySQL server during query (2013) #0 /home/mysite/public_html/board/system/Db/Select.php(378): IPS\_Db->preparedQuery('SELECT * FROM `...', Array, true) #1 /home/mysite/public_html/board/system/Db/Select.php(440): IPS\Db\_Select->runQuery() #2 /home/mysite/public_html/board/system/Db/Select.php(361): IPS\Db\_Select->rewind() #3 /home/mysite/public_html/board/system/Patterns/ActiveRecord.php(110): IPS\Db\_Select->first() #4 /home/mysite/public_html/board/system/Member/Member.php(190): IPS\Patterns\_ActiveRecord::load(11723, NULL, NULL) #5 /home/mysite/public_html/board/system/Content/Search/Results.php(530): IPS\_Member::load(11723) #6 /home/mysite/public_html/board/applications/core/modules/front/members/profile.php(237): IPS\Content\Search\_Results->addExtraItems(Array, Object(IPS\Member)) #7 /home/mysite/public_html/board/system/Dispatcher/Controller.php(96): IPS\core\modules\front\members\_profile->manage() #8 /home/mysite/public_html/board/applications/core/modules/front/members/profile.php(65): IPS\Dispatcher\_Controller->execute() #9 /home/mysite/public_html/board/system/Dispatcher/Dispatcher.php(146): IPS\core\modules\front\members\_profile->execute() #10 /home/mysite/public_html/board/index.php(13): IPS\_Dispatcher->run() #11 {main} #0 /home/mysite/public_html/board/init.php(533): IPS\_Log::log('SELECT * FROM `...', 'uncaught_except...') #1 [internal function]: IPS\IPS::exceptionHandler(Object(IPS\Db\Exception)) #2 {main} ------------- Thu, 07 Oct 2021 02:28:26 +0000 SELECT * FROM `ibf_core_members` AS `core_members` WHERE `member_id`=19278 IPS\Db\Exception: Lost connection to MySQL server during query (2013) #0 /home/mysite/public_html/board/system/Db/Select.php(378): IPS\_Db->preparedQuery('SELECT * FROM `...', Array, true) #1 /home/mysite/public_html/board/system/Db/Select.php(440): IPS\Db\_Select->runQuery() #2 /home/mysite/public_html/board/system/Db/Select.php(361): IPS\Db\_Select->rewind() #3 /home/mysite/public_html/board/system/Patterns/ActiveRecord.php(110): IPS\Db\_Select->first() #4 /home/mysite/public_html/board/system/Member/Member.php(190): IPS\Patterns\_ActiveRecord::load(19278, NULL, NULL) #5 /home/mysite/public_html/board/system/Content/Search/Results.php(530): IPS\_Member::load(19278) #6 /home/mysite/public_html/board/applications/core/modules/front/members/profile.php(237): IPS\Content\Search\_Results->addExtraItems(Array, Object(IPS\Member)) #7 /home/mysite/public_html/board/system/Dispatcher/Controller.php(96): IPS\core\modules\front\members\_profile->manage() #8 /home/mysite/public_html/board/applications/core/modules/front/members/profile.php(65): IPS\Dispatcher\_Controller->execute() #9 /home/mysite/public_html/board/system/Dispatcher/Dispatcher.php(146): IPS\core\modules\front\members\_profile->execute() #10 /home/mysite/public_html/board/index.php(13): IPS\_Dispatcher->run() #11 {main} #0 /home/mysite/public_html/board/init.php(533): IPS\_Log::log('SELECT * FROM `...', 'uncaught_except...') #1 [internal function]: IPS\IPS::exceptionHandler(Object(IPS\Db\Exception)) #2 {main} ------------- Thu, 07 Oct 2021 02:28:26 +0000 REPLACE INTO `ibf_core_cache` ( `cache_key`, `cache_value`, `cache_expire` ) VALUES and then very very big query ------------- Thu, 07 Oct 2021 02:28:26 +0000 REPLACE INTO `ibf_core_cache` ( `cache_key`, `cache_value`, `cache_expire` ) VALUES and another one --------------- Thu, 07 Oct 2021 02:28:44 +0000 SELECT word_key, word_default, word_custom FROM `ibf_core_sys_lang_words` AS `core_sys_lang_words` WHERE lang_id=2 AND word_key='404_error_title' IPS\Db\Exception: MySQL server has gone away (2006) #0 /home/mysite/public_html/board/system/Db/Select.php(378): IPS\_Db->preparedQuery('SELECT word_key...', Array, true) #1 /home/mysite/public_html/board/system/Db/Select.php(440): IPS\Db\_Select->runQuery() #2 /home/mysite/public_html/board/system/Db/Select.php(361): IPS\Db\_Select->rewind() #3 /home/mysite/public_html/board/system/Lang/Lang.php(605): IPS\Db\_Select->first() #4 /home/mysite/public_html/board/system/Output/Output.php(560): IPS\_Lang->checkKeyExists('404_error_title') #5 /home/mysite/public_html/board/init.php(458) : eval()'d code(26): IPS\_Output->error('node_error', '2F173/I', 404, '', Array, NULL, NULL) #6 /home/mysite/public_html/board/applications/forums/modules/front/forums/topic.php(1024): IPS\cms_hook_Output->error('node_error', '2F173/I', 404, '') #7 /home/mysite/public_html/board/system/Dispatcher/Controller.php(85): IPS\forums\modules\front\forums\_topic->__call('findComment', Array) #8 /home/mysite/public_html/board/system/Dispatcher/Controller.php(85): IPS\forums\modules\front\forums\topic->findComment() #9 /home/mysite/public_html/board/system/Content/Controller.php(50): IPS\Dispatcher\_Controller->execute() #10 /home/mysite/public_html/board/applications/forums/modules/front/forums/topic.php(39): IPS\Content\_Controller->execute() #11 /home/mysite/public_html/board/system/Dispatcher/Dispatcher.php(146): IPS\forums\modules\front\forums\_topic->execute() #12 /home/mysite/public_html/board/index.php(13): IPS\_Dispatcher->run() #13 {main} #0 /home/mysite/public_html/board/init.php(533): IPS\_Log::log('SELECT word_key...', 'uncaught_except...') #1 [internal function]: IPS\IPS::exceptionHandler(Object(IPS\Db\Exception)) #2 {main} ---------------- Thu, 07 Oct 2021 02:30:25 +0000 IPS\Db\Exception: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) (2002) #0 /home/mysite/public_html/board/system/Db/Db.php(119): IPS\_Db::_establishConnection('IPS\\Db', Array, false) #1 /home/mysite/public_html/board/system/Data/Cache/None.php(119): IPS\_Db::i() #2 /home/mysite/public_html/board/system/Dispatcher/Front.php(424): IPS\Data\Cache\_None->getWithExpire('page_5ec345424d...', true) #3 /home/mysite/public_html/board/system/Dispatcher/Front.php(38): IPS\Dispatcher\_Front->checkCached() #4 /home/mysite/public_html/board/system/Dispatcher/Dispatcher.php(103): IPS\Dispatcher\_Front->init() #5 /home/mysite/public_html/board/index.php(13): IPS\_Dispatcher::i() #6 {main} #0 /home/mysite/public_html/board/init.php(533): IPS\_Log::log('\nIPS\\Db\\Excepti...', 'uncaught_except...') #1 [internal function]: IPS\IPS::exceptionHandler(Object(IPS\Db\Exception)) #2 {main}

Hi guys, I'm still with IPS 4.3.3 and finally planning to upgrade soon to the latest version. I'm using a dedicated server. And I try to clean a bit stuff on the server before doing the upgrade. And I noticed something weird. That is why I need your help guys! I noticed that the uploads/logs folder on the server is 24GB large! I have no idea why. It has 2700+ files. And many of them are 25+ MB each. Here it is a list of the files generated today and yesterday: Today 2021_10_08_javascript.php - 53KB 2021_10_08_uncaught_exception.php - 28MB ! 2021_10_08_dispatcher.php - 2kb Yesterday 2021_10_07_uncaught_exception.php - 14MB 2021_10_07_topic_call.php - 1kb And so on, basically every day there is a large uncaught_exception file generated with a size between 185MB and 5MB. How can I get rid of these files? Anything I can do in the IPS admin panel? Or can I just delete all these exception files + others directly from the server? Please advise!