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. Beginner's Corner 
  4.  / Moving xoops from local machine to Sourceforge.net
Register
1
Scionwest
Moving xoops from local machine to Sourceforge.net

  • 2007/1/6 16:58

  • Scionwest

  • Just popping in

  • Posts: 14

  • Since: 2007/1/6 1


I am wanting to move my project website off of my local machine and onto my sourceforge.net project site. When I copy all of the files onto the sourceforge site I get the following errors.

Quote:
Error [Xoops]: Unable to connect to database in file /home/groups/t/tb/tbgengine-suite/htdocs/class/database/databasefactory.php line 34


If anyone could help out with what all I need to do\fix the get a XOOPS site moved over to sourceforge I would appreciate the help!

Thanks,
Scionwest
2
wodnick
Re: Moving xoops from local machine to Sourceforge.net

  • 2007/1/6 19:57

  • wodnick

  • Just popping in

  • Posts: 32

  • Since: 2006/12/30


Hi there!

Did You also copy database content?
Database name, user and password are the same?

If no, change it in mainfile.php to sourceforge setting and lock this file back for writing.

Also look for these records and change it to new values:
define('XOOPS_ROOT_PATH', 'd:/yourcomputer/apache/www');
define('XOOPS_URL', 'http://localhost');

regards,
wodnick
========
Pozycjonowanie
3
Scionwest
Re: Moving xoops from local machine to Sourceforge.net

  • 2007/1/6 21:24

  • Scionwest

  • Just popping in

  • Posts: 14

  • Since: 2007/1/6 1


Quote:

Did You also copy database content?
Database name, user and password are the same?

My layout is Root\Xoops and Root\usr
Root\usr\mysql\xoops2 is where my database is at.
As far as the everything being the same I assume you mean matching in the mainfile.php as to what the actuall database name is along with user name and password. if so then yes I have, though I have not really used php or databases very much and this is my first online website so I'm new and might have overlooked something.

Quote:

Also look for these records and change it to new values:
define('XOOPS_ROOT_PATH', 'd:/yourcomputer/apache/www');
define('XOOPS_URL', 'http://localhost');

Yes I have done this.

Any other suggestions would be great!

Thanks for the answers,
Scionwest
4
wodnick
Re: Moving xoops from local machine to Sourceforge.net

  • 2007/1/6 22:50

  • wodnick

  • Just popping in

  • Posts: 32

  • Since: 2006/12/30


Hi there!

I'm not quite sure, what is Your knowledge about databases...

How to create and configure database in sourceforge environment, You can find right here:
https://sourceforge.net/docs/E07/en/#mysql

As You see, creation and maintenance is made by special tools, not by simply copying database files.
I assume that Yours project is "tbgengine-suite", so probably:
Database host: mysql4-t
Database name: t[projectID]_[name_given_by_U]
Database_user: t[projectID]admin
Database User Password: "specified by the project administrator on the database admin page, must be initially set here and can be changed at any time"

What You have to do, is create database in sourceforge, export data from existing databases environment and import to the new one, setting these parameters to mainfile.

define('XOOPS_DB_HOST', 'mysql4-t');
define('XOOPS_DB_USER', 't[projectID]admin');
define('XOOPS_DB_PASS', 'WinniThePooch');
define('XOOPS_DB_NAME', 't[projectID]_[name_given_by_U]');

regards,
wodnick
========
Pozycjonowanie
5
Scionwest
Re: Moving xoops from local machine to Sourceforge.net

  • 2007/1/7 1:09

  • Scionwest

  • Just popping in

  • Posts: 14

  • Since: 2007/1/6 1


My knowledge on databases is pretty much none. I got my project ID and got logged into phpMyAdmin and created a database called Xoops. Once I created a database I tried to import my XOOPS database that I had exported out using phpMyAdmin and following one of the FAQ's on this site. When I try to import it into the database created on sourceforge I get the following error.

Error
SQL query:

-- phpMyAdmin SQL Dump
-- version 2.6.0-beta3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 06, 2007 at 11:05 AM
-- Server version: 4.1.1
-- PHP Version: 4.3.6
--
-- Database: `xoops2`
--
CREATE DATABASE `xoops2` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;



MySQL said:

#1044 - Access denied for user 't[ProjectID]admin'@'%' to database 'xoops2'

I actually have a projectID, I just removed it incase it shouldn't be shown in a public forum I don't know what kind of security issue it is displaying projectID's or not.

Do you have any idea what I might have done wrong?

Again, Thanks for the help! It's a miracle I've gotten this far .

Scionwest
6
skenow
Re: Moving xoops from local machine to Sourceforge.net

  • 2007/1/7 1:33

  • skenow

  • Home away from home

  • Posts: 993

  • Since: 2004/11/17


Your sql dump from phpMyAdmin included creating the database you were using (xoops2). You will need to remove this (it is just a text file), and since you have named your database differently, you will need to search/replace (xoops2 with xoops) in that sql file with your new db name. Be careful, because there will probably be other occurances of XOOPS in your sql dump you don't want to remove.

Save a copy of your original dump before editing it!
7
Scionwest
Re: Moving xoops from local machine to Sourceforge.net

  • 2007/1/7 2:18

  • Scionwest

  • Just popping in

  • Posts: 14

  • Since: 2007/1/6 1


Awesome! After reading your post I went and re-exported and it fixed it! Now that I have the database imported into sourceforge all I need to do is modify the mainfile.php to reflect the changes correct?

I changed the following values to what they should be but I still get a database connection error.

define('XOOPS_DB_HOST', 'mysql4-t');
define('XOOPS_DB_USER', 't[projectID]admin');
define('XOOPS_DB_PASS', 'WinniThePooch');
define('XOOPS_DB_NAME', 't[projectID]_[name_given_by_U]');

The password was set to the password I assigned the database at sourceforge. You can see the error at http://tbgengine-suite.sourceforge.net/tbg

Thanks!

Scionwest
8
wodnick
Re: Moving xoops from local machine to Sourceforge.net

  • 2007/1/7 10:22

  • wodnick

  • Just popping in

  • Posts: 32

  • Since: 2006/12/30


Hi there.

Now can You see bright light at the end of the tunnel.:)

Check twice if You wrote right data to mainfile.

define('XOOPS_DB_HOST', 'mysql4-t');
define('XOOPS_DB_USER', 't186249admin');
define('XOOPS_DB_PASS', 'your_password_to_database'); (not to Xoops!!!)
define('XOOPS_DB_NAME', 't186249_xoops2');

After You run this XOOPS installation, please, change the database name and reflect this in mainfile.

You just exposed Your site to hacker by publishing this - project name and letter are public, so only wall to hackers is Your database password.

regards,
wodnick
========
Pozycjonowanie
9
Scionwest
Re: Moving xoops from local machine to Sourceforge.net

  • 2007/1/7 18:10

  • Scionwest

  • Just popping in

  • Posts: 14

  • Since: 2007/1/6 1


Yes I can see the light! Thanks for the help, I renamed my database like you said (didn't realize that would be an issue) and modified my mainfile.php to reflect the changes. Now the site actually loads (I think), I don't get any errors but the webpage is blank.

Is this something else that I have done wrong?

Thanks!
Scionwest
http://tbgengine-suite.sourceforge.net
10
wodnick
Re: Moving xoops from local machine to Sourceforge.net

  • 2007/1/7 18:51

  • wodnick

  • Just popping in

  • Posts: 32

  • Since: 2006/12/30


Hi Scionwest!

Quote:
Now the site actually loads (I think), I don't get any errors but the webpage is blank.

Is this something else that I have done wrong?


Page works well, look at:
http://tbgengine-suite.sourceforge.net/tbg/admin.php

But something is wrong with displaying it.
Empty all content of templates_c folder.

Did You set all files / folders permission according to XOOPS needs?
World writeable: uploads/, cache/ and templates_c/ and the file mainfile.php locked to write.

regards,
wodnick
========
Pozycjonowanie
(1) 2 »

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

398 user(s) are online (321 user(s) are browsing Support Forums)

Members: 0

Guests: 398

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