import phpBB2phpBBmodule problem.

WnJBirds · **import phpBB2phpBBmodule problem. -** 01-18-2003, 05:03 PM

having a rough time importing my SQL dbase.
Got the importer file, and adjusted settings.
Here I have a problem..
[code] Software error:
Can't connect(DBI:mysql01.powweb.com:xxxx xxxx xxxx HASH(0x8138a94)), no database driver specified and DBI_DSN env var not set at /www/w/w_n_jb/cgi-bin/importer/phpBBusers2nukeusers.pl line 28

MySQL is not located at 'localhost' but at a different machine.
[code]
Line 28 :my $dbhnuke = DBI->connect("DBI:mysql01.host_name.com:$conf->{nuke_database}","$conf->{nuke_username}","$conf->{nuke_password}",{RaiseError => 1})
[/code]
How can I enter in my SQL servername, dbase name, uname, and pass and have it access the dbase and import old files?

mikem · 01-18-2003, 05:47 PM

Are you installing the phpBB ported Forums into your Nuke site or trying to setup PHP-Nuke?

mikem

IACOJ · 01-18-2003, 08:55 PM

Mikem,

That is an error from the importer script.

WnJBirds

From first glance your script is in the wrong place, UNLESS you manually went in and changed, where it is supposed to look for the next portion of script, in each file.

How old is the script, and did you get it from the downloads section or the forums of bbtonuke ? There are three different versions.

Are you using Nuke 6/phpbbport 2.0.6 or a previous vs?

I'm guessing that you are using your own server So you just change the name 'localhost' to your server name

As far as entering the other information it tells you where to do that in the read me files. IF your prefix is NOT nuke. you will have to go through the other 6 files and check them.

I would suggest that you do a search in the bbtonuke forums, and IF you are using Nuke 6/phpbb 2.0.6 you get the importer that is available through the forums. There are pages of questions about the importer, how it works, errors etc.

mikem · 01-18-2003, 09:09 PM

Quote:

powweb.com

I see that in his post, so I would guess he is on powweb.com servers.

He is trying to use the importer file that chatserv made to import the nuke.sql database tables.

Make sure you set in the config.php file that you upload from the html folder in the PHP-Nuke package you extracted has the correct settings for
$dbname
$dbuname
$dbpass
$dbhost

mikem

WnJBirds · 01-18-2003, 09:34 PM

Quote:

Originally Posted by mikem

Are you installing the phpBB ported Forums into your Nuke site or trying to setup PHP-Nuke?

mikem

Already installed, trying to import dbase from existing phpBB..

WnJBirds · 01-18-2003, 09:37 PM

Quote:

Originally Posted by mikem

Quote:

powweb.com

I see that in his post, so I would guess he is on powweb.com servers.

He is trying to use the importer file that chatserv made to import the nuke.sql database tables.

Make sure you set in the config.php file that you upload from the html folder in the PHP-Nuke package you extracted has the correct settings for
$dbname
$dbuname
$dbpass
$dbhost

mikem

the one I have doesn't have $dbhost, nut has the other three.

IACOJ · 01-18-2003, 09:49 PM

Does your common.pl have these?

Code:

#######################################################################
###### Configuration variables.  Change these settings           ######
#######################################################################
sub config {
	my %conf = ( nuke_database  => '',  # phpNuke database name
		     nuke_username  => '',       # phpNuke database uname
		     nuke_password  => '',       # phpNuke database password
		     nuke_prefix    => '',      # phpNuke table prefix

		     phpbb_database => '',       # phpBB database name
		     phpbb_username => '',      # phpBB database uname
		     phpbb_password => '',      # phpBB database password
		     phpbb_prefix   => ''           # phpBB table prefix
		   );
	return \%conf;
}

WnJBirds · 01-18-2003, 09:56 PM

It looks identical...
But it will not connect to a different mysql server than localhost for some reason.

WnJBirds · 01-18-2003, 09:58 PM

xxxxxxxxxx
link showing the error I'm getting.

IACOJ · 01-18-2003, 10:20 PM

Are you using the same database for both phpbb and for nuke? Just with different prefixes?

example nuke database php
nuke user YOUR log in name to the database
nuke password your password
Nuke prefix nuke

phpbb database php
phpbb uname Same as above if same database
phpbb password same password if same database
phpbb prefix phpbb

Did you configure it that way?

Or do you have completely seperate databases for the two?