Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: 2 different databases user & dump  (Read 6817 times)

0 Members and 1 Guest are viewing this topic.

CPG Guru

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Female
  • Posts: 40
  • Cool Buddy
2 different databases user & dump
« on: October 27, 2005, 06:44:57 pm »

Hi All

Ive used photopost 5.2.1 & there is an option of if we want to integrate photopost with mambo cms r any forum we can do that with option that we can install photopost standlone in different database & can configure user of mambo database.

This is an excellent Feature whcih will help in messing up two databases , for ur reference im attaching config file of that, please suggest if we have this feature or mod as ivenot found any in forum

Code: [Select]
<?php
//**************** External Header Configuration ****************//
//
// the isset prevents vB headers from being sent during login/logout -
// do not remove this line as it may cause the vB headers to interfere with the login/logout process
//
// To include the file, edit the header-inc.php
//

if ( !isset($skip_exheader) ) {
    include "header-inc.php";
}

// PhotoPost Pro Version Number
$VERSION "5.21";

// Path to your PhotoPost installation - no end slashes
$PP_PATH "/home/sitename/public_html/gallery";

// All of the .tmpl files are placed into a directory called "templates"; if you wish to change the
// name of the directory to something else to protect your files, you may do so and indicate the name
// of the directory here - this is not a path to the directory, just the directory name; the directory
// cannot be moved from the PhotoPost main directory.
$TMPL_PATH "templates";

//**************** MySQL Database Configuration ****************//

// PhotoPost database host address, or leave as localhost
$host="localhost";

// PhotoPost's database name
$database="PHOTOPOST DEFAULT DATABASE";

// MySQL username and password to access PhotoPost's database
//
// These two variables are for the userid and password needed to access
// the PhotoPost database named above.
$mysql_user="gallery_user";
$mysql_password="xxxxxxx";

// User database host address, or leave as localhost
$host_bb="localhost";

// If you want to use a prefix for your database, enter it here.
// NOTE: This variable can only be set PRIOR to your first installation of PhotoPost;
// existing databases will not be changed and you will be unable to connect if you change
// this variable after performing a default installation.
$pp_db_prefix "pp_";

// User database MySQL database name
//
// This is the variable for the User Database; if you are using Internal
// as your registration system, then these variables are the same as the
// ones above.  If you are linking to a message board system,
// thse variables should be set to the database, user and password for that
// database.
$database_bb="MAMBO DATABASE";

// MySQL username and password to access user database
//
// These two variables are for the userid and password needed to access
// the PhotoPost or BB database.
$user_bb="gallery_user";
$password_bb="xxxxxx";

//
// VB3 License Number required for VB3 integration
// You can find this number by checking your index.php file in your vB3 directory
// The 4th line in the file looks like:
// || # vBulletin 3.0.0 - Licence Number ########
// It is the ######## number you need to place below.
$vblicense "12345678";

//**************** Application Configuration ****************//

// Default Language
// This needs to be set to the name of the directory used inside of the languages directory
$pplang "english";

//////////////////////// Application Configuration ////////////////////////////////
// These variables set the path to the UNZIP, MOGRIFY and JHEAD commands on your system
//
// This only needs to be set if you are allowing ZIP uploads. These are full paths,
// including the name of the executable (.exe extensions for windows)
// The -j option for Info-ZIP's UNZIP tells it to ignore paths in ZIP file
//
// This option is only used in the event the internal UNZIP does not work for you
//$zip_command = "/usr/bin/unzip -j";

// Path to MOGRIFY executable
// There should be no spaces in the directory names, use short names if necessary.
// Examples:
// $mogrify_command = "c:\progra~1\imagemagick\mogrify.exe";
// $mogrify_command = "c:\ImageMagick\mogrify.exe";
$mogrify_command "/usr/bin/mogrify";

?>
Regards
:)



Logged

Nibbler

  • Guest
Re: 2 different databases user & dump
« Reply #1 on: October 27, 2005, 06:52:39 pm »

What is your question exactly ? Coppermine can bridge to many forums and cmss
Logged

kegobeer

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 4637
  • Beer - it does a body good!
    • The Kazebeer Family Website
Re: 2 different databases user & dump
« Reply #2 on: October 27, 2005, 06:58:31 pm »

1.3.x has complete instructions on how to bridge with a bbs/cms, and 1.4.x has a bridge wizard that does everything for you.
Logged
Do not send me a private message unless I ask for one.  Make your post public so everyone can benefit.

There are no stupid questions
But there are a LOT of inquisitive idiots

CPG Guru

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Female
  • Posts: 40
  • Cool Buddy
Re: 2 different databases user & dump
« Reply #3 on: October 27, 2005, 10:50:35 pm »

I know that coppermine can bridge mambo, im having 2 coppermine on my site 1.3.4 & 1.4.1,

1.4.x is bridged with mambo & share same mambo database for both users & picures database.

in photopost we have an option of enter 2 different  databases to share one for datai.e. pics & other for users.

Hope u got it now my attached code is self explantory
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: 2 different databases user & dump
« Reply #4 on: October 28, 2005, 12:13:59 am »

we will definitely not "borrow" code from a commercial app. Not sure what you're trying to suggest.
Logged

CPG Guru

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Female
  • Posts: 40
  • Cool Buddy
Re: 2 different databases user & dump
« Reply #5 on: October 28, 2005, 02:57:05 am »

we will definitely not "borrow" code from a commercial app. Not sure what you're trying to suggest.

Ok i'll tell u  again

If we'vw to install coppermine with mambo cms the whole process is :

1) upload cpg on same site

2) To integrate (bridge) we use same sql database of mambo in cpg , with this automatically all the cpg_ tables are created in mambo database.

3) Now everything is clear if we want to get registered with cpg the user databse is same of mambo or its common database

 *** Now in this case in future if i want to delete this database of cpg or want to discontinue mambo cms & want to install any new cms i'll not able to use that immediatly because if i'll delete all the entries of mambo cms or cpg from same database & it can give errors.

   2nd Case  Now when we bridge Photopost with mambo

1) we upload photopost on same site ( like cpg)

2) IN integration process there are two options :-
   
    i) We can use same mambo sql database for sharing users & to install database of
       photopost

     ii) We can use same database for sharing users of mambo but can make new 
         sql database for photopost where al the gallery data will be installed (no users will
        be there in this database,obviously we will set instructions in config of photopost
        from where to get users)

*** Now what the benefit is photopost is only using users from mambo database & all its
      own data is installed in other database, in future if i want to change mambo cms to
      some other,then in photopost ive to change only  shared database name mean to
      say all the gallery database is secure only users will be changed

Sorry if i u cant understand !!!

Please for once read the config code above , there are options written which are self explanable


This is very good feature if u caught what i say



Thanks
Logged

Nibbler

  • Guest
Re: 2 different databases user & dump
« Reply #6 on: October 28, 2005, 03:02:08 am »

So this is a feature request ?
Logged

CPG Guru

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Female
  • Posts: 40
  • Cool Buddy
Re: 2 different databases user & dump
« Reply #7 on: October 28, 2005, 03:12:05 am »

Might be this is a feature request as in cpg forum & script ive not found any option to do this.
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: 2 different databases user & dump
« Reply #8 on: October 28, 2005, 07:15:05 am »

OK, now I understand. Moving this thread accordingly from "support" to "feature requests".
Logged
Pages: [1]   Go Up
 

Page created in 0.027 seconds with 21 queries.