Icy Phoenix

     
 

Enabling DB And Security?

Enabling DB And Security?

Article
Reply with quote    Download Post  
Post Enabling DB And Security? 
 
I have to rebuild search tables, but I could not find the category DB and Maintenance, listed here: http://www.icyphoenix.com/viewtopic...=search+rebuild Any can throw a wire with this?



 
Sarakin - View user's profile Send private message  
Sarakin [ Tue 12 Jan, 2016 20:53 ]
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.

Support us


Enabling DB And Security?

Comments
Reply with quote    Download Post  
Post Re: Enabling DB And Security? 
 
This is the latest version.

ACP -> DB And Security -> Database Maintenance -> Rebuild search index



 
mort - View user's profile Send private message  
mort [ Tue 12 Jan, 2016 23:35 ]
Reply with quote    Download Post  
Post Re: Enabling DB And Security? 
 
Point is that DB and Security is nowhere to be found... don't know if you are aware about what I mean   I'd swear on old times I had to do something somewhere for that category to appear...



 
Sarakin - View user's profile Send private message  
Sarakin [ Wed 13 Jan, 2016 19:08 ]
Reply with quote    Download Post  
Post Re: Enabling DB And Security? 
 
Sarakin wrote: [View Post]
I'd swear on old times I had to do something somewhere for that category to appear...


Templates options maybe - had to be "switched" on in the side panel - I Don't recall Db and Security being affected?

The files should only need to exist in the adm folder.

BTW - - What version ARE you talking about  



 
mort - View user's profile Send private message  
mort [ Thu 14 Jan, 2016 07:13 ]
Reply with quote    Download Post  
Post Re: Enabling DB And Security? 
 
mort wrote: [View Post]
Sarakin wrote: [View Post]
I'd swear on old times I had to do something somewhere for that category to appear...


Templates options maybe - had to be "switched" on in the side panel - I Don't recall Db and Security being affected?

The files should only need to exist in the adm folder.

BTW - - What version ARE you talking about  

Last update, 2.0, right? Anyway, I think I remember something about you had to be the user with ID=1 (not my case, but I could easily modifiy that using phpMyAdmin). Could I be right?



 
Sarakin - View user's profile Send private message  
Sarakin [ Thu 14 Jan, 2016 19:30 ]
Reply with quote    Download Post  
Post Re: Enabling DB And Security? 
 
Sarakin wrote: [View Post]
you had to be the user with ID=1 (not my case, but I could easily modify that using phpMyAdmin). Could I be right?


You're way off - Change it and you will no longer be Admin.

And your "User-Permissions" are encoded - Not that one should change them anyway!

Re-Upload all the files in the adm folder with BINARY and make sure you have 3 files that start with admin_db_

Do the same to the templates/common/ACP/*.*

GoTo - ACP - > Clear the cache's -> Refresh the Admin Index page...

If that don't work - then you will have to wait for either informpro or MG for an answer.

PS:

BTW - - Are you testing this on XAMPP/web etc - Or are you using it live on the web. ?



 
mort - View user's profile Send private message  
mort [ Fri 15 Jan, 2016 00:13 ]
Reply with quote    Download Post  
Post Re: Enabling DB And Security? 
 
mort wrote: [View Post]
Sarakin wrote: [View Post]
you had to be the user with ID=1 (not my case, but I could easily modify that using phpMyAdmin). Could I be right?


You're way off - Change it and you will no longer be Admin.

OK, now I'm glad to have not tried that

Quote:
Re-Upload all the files in the adm folder with BINARY and make sure you have 3 files that start with admin_db_

Files are OK and they exist on adm folder

Quote:
BTW - - Are you testing this on XAMPP/web etc - Or are you using it live on the web. ?

I tried both, local and remote installations with no results. DB and Maintenance category is nowhere to be found   Hope anyone could give another hand here... because I'd swear last time I used de DB feature I had to do something especial for it to be shown   Anyway, I could start from a blank IP 2.0 and import my already existent posts tables in order to rebuild the search tables and import them back on the "real site"...



 
Sarakin - View user's profile Send private message  
Sarakin [ Fri 15 Jan, 2016 12:30 ]
Reply with quote    Download Post  
Post Re: Enabling DB And Security? 
 
Is this what your after

 dbsec2

If so then its definately there, what template are you using ?



 
AndyGpy - View user's profile Send private message  
AndyGpy [ Fri 15 Jan, 2016 13:14 ]
Reply with quote    Download Post  
Post Re: Enabling DB And Security? 
 
I did not read everything,

but you can change the main admin otr better enable the special features:

Take a look at this code \includes\constants.php
Code: [Download] [Hide] [Select]
// Insert here the IDs of the main admins separated by commas, they will be able to access special features in ACP
// Allowed features: Action Logs, Private Messages, DB Tools, Templates Edit (XS Style)
// If the constant is deleted then every admin is able to access the Full ACP
define('MAIN_ADMINS_ID', '2');


Change this like that
Code: [Download] [Hide] [Select]
define('MAIN_ADMINS_ID', '2,YOUR_ID');




 
TheSteffen - View user's profile Send private message  
TheSteffen [ Fri 15 Jan, 2016 19:42 ]
Reply with quote    Download Post  
Post Re: Enabling DB And Security? 
 
TheSteffen wrote: [View Post]
I did not read everything,
  

The problem is he can't see the db-utils anywhere in the ACP/left panel?

Maybe he should take a snapshot of exactly what he DOES see in the ACP - along with the VERSION number in the left-side panel....  



 
mort - View user's profile Send private message  
mort [ Sat 16 Jan, 2016 00:50 ]
Reply with quote    Download Post  
Post Re: Enabling DB And Security? 
 
mort wrote: [View Post]
The problem is he can't see the db-utils anywhere in the ACP/left panel?

Yes, that was the point I got by quick reading.

And my answer was. Only Main Admins can see "DB and Security" on the left site in ACP.
You can change the Main Admin in \includes\constants.php
See my post above.



 
TheSteffen - View user's profile Send private message  
TheSteffen [ Sat 16 Jan, 2016 09:12 ]
Reply with quote    Download Post  
Post Re: Enabling DB And Security? 
 
Right. This is a very important security feature -- you don't want every admin to be able to access your whole DB, that'd be scary. (it's also why we have junior admin)



 
Informpro - View user's profile Send private message  
Informpro [ Sat 16 Jan, 2016 13:23 ]
Reply with quote    Download Post  
Post Re: Enabling DB And Security? 
 
I am still trying to work out how one can install Icy Phoenix and NOT end up as the "Main Admin" and then have to go through changing ID's and or permissions to access something only the Main Admin can..

     

If that was the case then Icy Phoenix would be requiring an URGENT patch/upgrade to fix it..  



 
mort - View user's profile Send private message  
mort [ Sun 17 Jan, 2016 06:56 ]
Reply with quote    Download Post  
Post Re: Enabling DB And Security? 
 
mort wrote: [View Post]
I am still trying to work out how one can install Icy Phoenix and NOT end up as the "Main Admin" and then have to go through changing ID's and or permissions to access something only the Main Admin can..

     

If that was the case then Icy Phoenix would be requiring an URGENT patch/upgrade to fix it..  

When you setup Icy Phoenix, you are the main admin... in constants.php ID 2 is already set.

But if you want to assign special features to other users, the main admin should be aware of what he is doing. By adding this check to a file, it should be more difficult to hack instead of "stealing" admins right from DB or sessions.



 
Mighty Gorgon - View user's profile Send private message  
Mighty Gorgon [ Thu 21 Jan, 2016 17:28 ]
Reply with quote    Download Post  
Post Re: Enabling DB And Security? 
 
Mighty Gorgon wrote: [View Post]
When you setup Icy Phoenix, you are the main admin... in constants.php ID 2 is already set.


I know - This is what has me beat, as I doubt very much that Sarakin would have been messing with permissions as soon as he installed it?

I could be wrong - But I'm not using the latest release from GitHub.. Maybe I should change that - "Today".
 

Mort to Sarakin wrote: 
BTW - - Are you testing this on XAMPP/web etc - Or are you using it live on the web. ?


Sarakin wrote: 
I tried both, local and remote installations with no results. DB and Maintenance category is nowhere to be found


Edit:

A clean - normal - change-nothing install from GitHub 16/01/2016.

Powered by Icy Phoenix 2.0.18.104

DB And Security

Actions Log
IP MySQLAdmin
DB Backup
DB Restore
DB Restore From File
Optimize Database
Database Maintenance
Checksum Scanner
Recovery
Filescanner
IP & Agent Blocker
Log Manager
Maintenance & Tests

I don't know what he's doing..... ?

@Sarakin - Do you actually see the category DB And Security in the side menu or not

And you say you are using "Last update, 2.0, right?"

2.0, WHAT?

WHAT is actually the full version you see in the bottom corner? - - - - -

Like THIS?

 capture



 
mort - View user's profile Send private message  
mort [ Fri 22 Jan, 2016 00:04 ]
Display posts from previous:    

HideWas this topic useful?

Post new topic  Reply to topic  Page 1 of 2
Goto page 1, 2  Next
 




 


 

  cron