Icy Phoenix
Old Support Topics - Enabling DB And Security?
Sarakin [ Tue 12 Jan, 2016 20:53 ]
Post subject: Enabling DB And Security?
Post subject: 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?
mort [ Tue 12 Jan, 2016 23:35 ]
Post subject: Re: Enabling DB And Security?
Post subject: Re: Enabling DB And Security?
This is the latest version.
ACP -> DB And Security -> Database Maintenance -> Rebuild search index
ACP -> DB And Security -> Database Maintenance -> Rebuild search index
Sarakin [ Wed 13 Jan, 2016 19:08 ]
Post subject: Re: Enabling DB And Security?
Post subject: 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...
I'd swear on old times I had to do something somewhere for that category to appear...
mort [ Thu 14 Jan, 2016 07:13 ]
Post subject: Re: Enabling DB And Security?
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
Post subject: Re: Enabling DB And Security?
Sarakin wrote: [View Post]
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
Sarakin [ Thu 14 Jan, 2016 19:30 ]
Post subject: Re: Enabling DB And Security?
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?
Post subject: Re: Enabling DB And Security?
mort wrote: [View Post]
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?
mort [ Fri 15 Jan, 2016 00:13 ]
Post subject: Re: Enabling DB And Security?
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. ?
Post subject: Re: Enabling DB And Security?
Sarakin wrote: [View Post]
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. ?
Sarakin [ Fri 15 Jan, 2016 12:30 ]
Post subject: Re: Enabling DB And Security?
OK, now I'm glad to have not tried that
Files are OK and they exist on adm folder
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"...
Post subject: Re: Enabling DB And Security?
mort wrote: [View Post]
OK, now I'm glad to have not tried that
Quote:
Files are OK and they exist on adm folder
Quote:
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"...
AndyGpy [ Fri 15 Jan, 2016 13:14 ]
Post subject: Re: Enabling DB And Security?
Post subject: Re: Enabling DB And Security?
Is this what your after
If so then its definately there, what template are you using ?
If so then its definately there, what template are you using ?
TheSteffen [ Fri 15 Jan, 2016 19:42 ]
Post subject: Re: Enabling DB And Security?
Post subject: 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
Change this like that
but you can change the main admin otr better enable the special features:
Take a look at this code \includes\constants.php
// 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');
// 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
mort [ Sat 16 Jan, 2016 00:50 ]
Post subject: Re: Enabling DB And Security?
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....
Post subject: Re: Enabling DB And Security?
TheSteffen wrote: [View Post]
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....
TheSteffen [ Sat 16 Jan, 2016 09:12 ]
Post subject: Re: Enabling DB And Security?
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.
Post subject: Re: Enabling DB And Security?
mort wrote: [View Post]
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.
Informpro [ Sat 16 Jan, 2016 13:23 ]
Post subject: Re: Enabling DB And Security?
Post subject: 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)
mort [ Sun 17 Jan, 2016 06:56 ]
Post subject: Re: Enabling DB And Security?
Post subject: 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..
If that was the case then Icy Phoenix would be requiring an URGENT patch/upgrade to fix it..
Mighty Gorgon [ Thu 21 Jan, 2016 17:28 ]
Post subject: Re: Enabling DB And Security?
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.
Post subject: Re: Enabling DB And Security?
mort wrote: [View Post]
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.
mort [ Fri 22 Jan, 2016 00:04 ]
Post subject: Re: Enabling DB And Security?
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".
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?
Post subject: Re: Enabling DB And Security?
Mighty Gorgon wrote: [View Post]
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:
Sarakin wrote:
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?
Sarakin [ Mon 25 Jan, 2016 20:26 ]
Post subject: Re: Enabling DB And Security?
Post subject: Re: Enabling DB And Security?
I have to try editing the constants.php file trick yet. If not, I cannot see it because my user ID is 5 (not main, the main admin left running the site several years ago. almost a decade 
). Now it works, thanks!
). Now it works, thanks!
mort [ Mon 25 Jan, 2016 22:49 ]
Post subject: Re: Enabling DB And Security?
If you had said that at first then it would have been a lot easier.... But you gave the impression that you were trying NEW installs as well??
So now the CORRECT way of doing it would be to change the old Admin 2 name and password to yours in the Db... (Cut and Paste). and put the constant back to default.
Post subject: Re: Enabling DB And Security?
Sarakin wrote: [View Post]
If you had said that at first then it would have been a lot easier.... But you gave the impression that you were trying NEW installs as well??
So now the CORRECT way of doing it would be to change the old Admin 2 name and password to yours in the Db... (Cut and Paste). and put the constant back to default.
Informpro [ Tue 26 Jan, 2016 09:50 ]
Post subject: Re: Enabling DB And Security?
Post subject: Re: Enabling DB And Security?
It's as easy to change the constant, really. So long you remember to change it when you update Icy ;).