Initail UniAdmin Login/Password

Support and feedback for UniAdmin

Initail UniAdmin Login/Password

Postby Rusky » Fri Aug 25, 2006 5:28 pm

From what I understand the initial login is Default and password is changeme?

I get the error

DEBUG: ERROR: Table 'efaeguil_roster.uniadmin_users' doesn't exist
select * from `uniadmin_users` where `name` like 'Default'

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/efaeguil/public_html/uniadmin/login.php on line 33
Rusky
WR.net Apprentice
WR.net Apprentice
 
Posts: 15
Joined: Thu Aug 24, 2006 1:38 am

Initail UniAdmin Login/Password

Postby zanix » Sat Aug 26, 2006 12:30 am

Make sure you have the "table prefix" set correctly in uniadmin/config.php
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Re: Initail UniAdmin Login/Password

Postby Rusky » Mon Aug 28, 2006 6:23 am

The prefix is correct still get the error.

Here are the steps I took.

1. I had the WoWRoster up and going well before getting the UniAdmin, if that matters.

2. I uploaded all the UniAdmin files

3. I created a DB called UniAdmin and ran the .sql file that came with the UniAdmin download.

4. Possible error: when configuring the config.php file am I using the DB info for WoWRoster or should I make a new user for UniAdmin and use that info?
Rusky
WR.net Apprentice
WR.net Apprentice
 
Posts: 15
Joined: Thu Aug 24, 2006 1:38 am

Initail UniAdmin Login/Password

Postby zanix » Mon Aug 28, 2006 7:09 am

The make sure yo have the correct info for db_name

Looks like it may be
Code: Select all
efaeguil_UniAdmin
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Re: Initail UniAdmin Login/Password

Postby Rusky » Mon Aug 28, 2006 7:16 am

What about the DB prefix/username/password
Should if be the info for the DB that I made for the WoWRoster?

Or should I create a username for the UniAdmin DB and use that?
Rusky
WR.net Apprentice
WR.net Apprentice
 
Posts: 15
Joined: Thu Aug 24, 2006 1:38 am

Initail UniAdmin Login/Password

Postby zanix » Mon Aug 28, 2006 8:37 am

Rusky wrote:What about the DB prefix/username/password
Should if be the info for the DB that I made for the WoWRoster?

The user name needs access to the new db you created
Rusky wrote:Or should I create a username for the UniAdmin DB and use that?

You could do this as well
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Re: Initail UniAdmin Login/Password

Postby Rusky » Mon Aug 28, 2006 6:37 pm

Ugg still no luck

Error:

DEBUG: ERROR: Table 'efaeguil_UniAdmin.roster_users' doesn't exist
select * from `roster_users` where `name` like 'efaeguil_roster'

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/efaeguil/public_html/UniAdmin/login.php on line 33


Here is my config file with a few things editted out:
For the username/password I added the the user from WoWRoster DB to the UniAdmin DB.

Code: Select all
<?php
$config['host'] =       'localhost';         // dbase host
$config['username'] =    '<Same username as WoWRoster DB>';   // dbase username
$config['password'] =    '<Same password as WoWRoster DB>';   // dbase password
$config['database'] =    'efaeguil_UniAdmin';      // dbase name

//////////////// DO NOT TOUCH ANYTHING AFTER THIS LINE ////////////
ini_set('display_errors','1');
error_reporting(E_WARNING);
///////////////////////// DATABASE ////////////////////////////////
$config['db_prefix'] =          'roster_';
$config['db_tables_addons'] =    $config['db_prefix'].'addons';
$config['db_tables_files'] =       $config['db_prefix'].'files';
$config['db_tables_logos'] =       $config['db_prefix'].'logos';
$config['db_tables_settings'] =    $config['db_prefix'].'settings';
$config['db_tables_stats'] =       $config['db_prefix'].'stats';
$config['db_tables_users'] =       $config['db_prefix'].'users';
$config['db_tables_svlist'] =    $config['db_prefix'].'svlist';
//////////////////////// FOLDER SETTINGS //////////////////////////
$config['addon_folder'] =       'addon_zips';
$config['temp_analyze_folder'] =    'addon_temp';
$config['logo_folder'] =       'logos';
////////////////////////// OTHER STUFF ////////////////////////////
$config['ziplibsupport'] =      false;
$config['UAVer'] =          'Beta 0.6.1';
$config['debugSetting'] =      true;
$url = explode('/','http://'.$_SERVER['HTTP_HOST'].$_SERVER['PHP_SELF']);
array_pop($url);
$url = implode('/',$url).'/';
$config['URL'] =               $url;
$config['IntLocation'] =          $config['URL'].'interface.php';
$dblink=mysql_connect($config['host'],$config['username'],$config['password']);
mysql_select_db($config['database'],$dblink);
include('debug.php');
include('MySqlCheck.php');
include('css.php');
include('cookieFunctions.php');

if (!$interface){
   include('login.php');
   include('header.php');
   include('EchoPage.php');
}
?>
Rusky
WR.net Apprentice
WR.net Apprentice
 
Posts: 15
Joined: Thu Aug 24, 2006 1:38 am

Initail UniAdmin Login/Password

Postby Rihlsul » Mon Aug 28, 2006 6:48 pm

Woah, hey:
Code: Select all
///////////////////////// DATABASE ////////////////////////////////
$config['db_prefix'] =          'roster_';


Um, for uniadmin, you'd want that to be "uniadmin_". Your uniadmin right now is trying to look for a table called roster_users, but such does not exist. I bet uniadmin_users does, though.
Rihlsul,
Guild Leader of The Dirty Hordes
User avatar
Rihlsul
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 125
Joined: Tue Jul 04, 2006 8:27 pm

Re: Initail UniAdmin Login/Password

Postby Rusky » Mon Aug 28, 2006 7:04 pm

Rihlsul wrote:Woah, hey:
Code: Select all
///////////////////////// DATABASE ////////////////////////////////
$config['db_prefix'] =          'roster_';


Um, for uniadmin, you'd want that to be "uniadmin_". Your uniadmin right now is trying to look for a table called roster_users, but such does not exist. I bet uniadmin_users does, though.


The reason I have it set to roster_ is because that is the prefix to my WoWRoster DB. But I'll give uniadmin_ a try though.

EDIT:

It worked!!!
Thanks very much to zanix and for the finishing blow to Rihlsul.

You guys rock!
Last edited by Rusky on Mon Aug 28, 2006 7:08 pm, edited 1 time in total.
Rusky
WR.net Apprentice
WR.net Apprentice
 
Posts: 15
Joined: Thu Aug 24, 2006 1:38 am


Return to UniAdmin

Who is online

Users browsing this forum: No registered users and 0 guests

cron