XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. XOOPS general usage questions 
  4.  / How do I change the XOOPS_DB_PREFIX?
Register
1
falke
How do I change the XOOPS_DB_PREFIX?

  • 2005/9/7 19:26

  • falke

  • Friend of XOOPS

  • Posts: 158

  • Since: 2004/4/25


I have been using XOOPS Protector since this spring. After reading about the latest hackerattacks I decided to check it out once more. Then I saw this message in the Security Advisory:

XOOPS_DB_PREFIX' : XOOPS Not secure
This setting invites 'SQL Injections'.


Is it possible to fix this on a site that is up an running? If so.... how? I am using XOOPS 2.2.2

regards/falke
.........
2
indream
Re: How do I change the XOOPS_DB_PREFIX?

  • 2005/9/7 21:06

  • indream

  • Not too shy to talk

  • Posts: 170

  • Since: 2004/9/21


yes :)

1.
open your sql file in notepad
press ctrl+h (find+replace)
replace your old prefix to new prefix
and dumb

2.
open your mainfile.php
find
define('XOOPS_DB_PREFIX', 'xoops');
and replace new name and upload.
3
WarDick
Re: How do I change the XOOPS_DB_PREFIX?

  • 2005/9/7 21:38

  • WarDick

  • Just can't stay away

  • Posts: 890

  • Since: 2003/9/13


Quote:
I am using XOOPS 2.2.2


Doesn't 2.2.2 use a custom prefix.
Urging XOOPS to be the Best It Can Be.
Richard......
4
skenow
Re: How do I change the XOOPS_DB_PREFIX?

  • 2005/9/7 22:01

  • skenow

  • Home away from home

  • Posts: 993

  • Since: 2004/11/17


Newer versions of Protector has a prefix manager that allows you to change your prefixes. Your SQL files should NOT have any prefixes in them, they are added during the installation of the modules. But, your mainfile.php will need to be modified once your tables are renamed.

I'm not sure how 2.2.2 handles table prefixes, especially if it was an upgrade.
5
WarDick
Re: How do I change the XOOPS_DB_PREFIX?

  • 2005/9/7 22:08

  • WarDick

  • Just can't stay away

  • Posts: 890

  • Since: 2003/9/13


Good point about the upgrade issue. It will use your old prefix. I always use a custom prefix but it always the same for my sites. It givex me the ablility to easily share data between sites. It is especially handy for users and links, as well as quickly setting up a new site based on previous setting from an existing site.
Urging XOOPS to be the Best It Can Be.
Richard......
6
falke
Re: How do I change the XOOPS_DB_PREFIX?

  • 2005/9/11 12:32

  • falke

  • Friend of XOOPS

  • Posts: 158

  • Since: 2004/4/25


Well, I just updated the protector to the latest version. In the prefix manager I can read:

If you want to change prefix,
edit /customers/cykeltur.se/cykeltur.se/httpd.www/mainfile.php manually.

define('XOOPS_DB_PREFIX', 'xoops');

Then there is a copy field. I am not sure what to do here... ;o)

Should I enter the new prefix in the copy filed and then edit the mainfile.php to get this working with a new prefix.

As it says "copy" I presume that the old DB and all the information inside is left intact and that there will be a copy of all the information. Correct?

regards/falke
.........

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

338 user(s) are online (237 user(s) are browsing Support Forums)

Members: 0

Guests: 338

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits