Posted on: 10/26/05 02:02pm
By: Anonymous (loloviolo)
I just intalled GeekLog but cannot access Admin.
Default Admin login and password
Posted on: 10/26/05 02:16pm
By: Dirk
Try reading the first story on your new site ...
Default Admin login and password
Posted on: 11/05/05 02:56pm
By: Anonymous (Johannes)
I have the same problem.
Something is going wrong with my installation - it displays the success page and advises me to read the first story - except that there is no story.
Is there a default admin usr/pwd combination - or is it installation specific?
Default Admin login and password
Posted on: 11/05/05 03:06pm
By: Dirk
[QUOTE BY= Johannes] it displays the success page and advises me to read the first story - except that there is no story.[/QUOTE]
If there is no story when you go to your site's front page (following the "click here" link from the success page), then something went wrong with the install and you should attempt it again.
[QUOTE BY= Johannes] Is there a default admin usr/pwd combination - or is it installation specific?[/QUOTE]
Username: Admin, password: password
bye, Dirk
Default Admin login and password
Posted on: 11/05/05 04:28pm
By: Anonymous (Johannes)
Thanks for your swift reply Dirk!
Just to rule out some oversight on my part, here is what I'm doing:
1. Unpack the files, put on webserver. (Apache2 on WinXP, no issues with access rights).
2. Edit config.php and lib-common.php.
3. Create DB and user with all privileges on it.
4. go to public_html/admin/install/install.php
5. Choose "New database" installation, enter correct path to config.php
6. Proceed to step 2, do not select InnoDB.
7. Click on next. At this point browser shows it's waiting on webserver, then page turns blank.
8. I can see that 41 tables have been created in my database - but I'm wondering whether all the necessary values have been entered. The sum total of records is 168 - is this normal?
The only way for me to get to the success.php page is if I go through the installation process and (incorrectly) select the upgrade process.
Nevertheless, and without doing the upgrade installation, I can get to the Geeklog basic root page - but no user actions work.
Can't log in as admin (with Admin/password), can't create new users:
Fatal error: Account creation for user 'NewUser' failed. Please contact the site admin.
All of the above makes me think I have a MySQL issue, any thoughts on this?
Default Admin login and password
Posted on: 11/05/05 04:36pm
By: Dirk
[QUOTE BY= Johannes] 7. Click on next. At this point browser shows it's waiting on webserver, then page turns blank.[/QUOTE]
Blank page[*1]
Default Admin login and password
Posted on: 11/05/05 04:59pm
By: Anonymous (Johannes)
(I'm running Apache/2.0.55 (Win32) PHP/5.0.5, MySQL 5.0.15)
Thanks again Dirk for the swift reply.
I should have mentioned that I had already made the necessary changes to my php.ini file. No errors are reported in the browser, nor do they appear in my error.logs.
Do you know if there is a documented and fixed number of entries that should exist in the database for a fresh installation?
My main concern is that since there is at least 1 default user (namely "Admin") he should have some entries in the table "gl_users" - which contains no record in my case.
How could I try to test where in the installation I'm having trouble?
Default Admin login and password
Posted on: 11/05/05 05:37pm
By: Anonymous (Johannes)
...to follow up on my own post - and provide more info for the gurus out there:
The tables should be created and filled by mysql_tableanddata.php. When able to run properly, this file should creat 41 tables and fill those tables with 248 records (or I would think so, by counting "CREATE TABLE" AND "INSERT INTO").
In my case, I have 41 tables and 168 records only. It looks like all the records for tables including gl_statuscodes are entered correctly, but from gl_stories and no records are entered.
Any thoughts on why these remaining tables are not filled correctly?
Default Admin login and password
Posted on: 11/05/05 05:42pm
By: Dirk
3 accounts are created by default: Anonymous, Admin, and Moderator. Each of the users tables should therefore have 3 entries. If they don't, then something went wrong.
It may very well be a problem with MySQL 5 - not sure if anyone has tested Geeklog with MySQL 5 yet.
Compare the contents of the tables with sql/mysql_tableanddata.php. That file is processed pretty much from top to bottom. First it creates the tables (41 of them), then it fills them with data (and lastly adds some indexes, but it probably didn't even make it to that stage in your case).
Since you seem to have full control over your setup, please try to switch on all debugging / error reporting options you can think of. There must be an error - and therefore an error message - somewhere ...
bye, Dirk
Default Admin login and password
Posted on: 11/05/05 08:59pm
By: Anonymous (Johannes)
Problem solved!
The problem was in fact SQL related. The table gl_stories has no default values for date - setting a default value solved my problem.
Here is the original code, mysql_tableanddata.php starting at line 372:
$_SQL[28] = "
CREATE TABLE {$_TABLES['stories']} (
sid varchar(40) NOT NULL default '',
...
expire DATETIME NOT NULL,
...
PRIMARY KEY (sid)
) TYPE=MyISAM
";
I simply added a default value, resulting in:
$_SQL[28] = "
CREATE TABLE {$_TABLES['stories']} (
sid varchar(40) NOT NULL default '',
...
expire DATETIME NOT NULL default '0000-00-00 00:00:00',
...
PRIMARY KEY (sid)
) TYPE=MyISAM
";
This solved the installation problem, I now have 41 tables filled with 248 records (as the original count for insert statements suggested).
Thanks for all your help - something tells me I might need it sometime soon
Default Admin login and password
Posted on: 11/06/05 04:44am
By: Dirk
[QUOTE BY= Johannes] I simply added a default value[/QUOTE]
Makes sense. Will fix that in CVS.
Thanks!
bye, Dirk
Default Admin login and password
Posted on: 01/14/06 09:39pm
By: Anonymous (Sammo)
Hi, im having this problem - but not with mysql etc (my tables are populated) - so it would seem a cookie problem. Everything on install went well so not a problem!
the problem i recon is because im using a sub domain - and not a second level domain. i have added into the config.php file the following information:
$_CONF['cookie_path'] = '/';
$_CONF['cookiedomain'] = 'mysub.mydomain.biz'; // e.g. '.example.com'
$_CONF['cookiesecure'] = 0;
Is this ok, or am i going wrong here?
If not other than the reasons listed on this stie - could there be any other reasons why i cant log in?
Thanks in advance,
Sam.
Default Admin login and password
Posted on: 01/14/06 10:01pm
By: Anonymous (Sammo)
checking the access log shows it as if no one has tried to log in - getting 'dummy entry'.
I checked permissions - all fine.
The site is running off my own linux box - so any server admin questions let me know
Default Admin login and password
Posted on: 01/14/06 10:03pm
By: Anonymous (Sammo)
one more thing - it identifies me as a guest though! So it knows im here (maybe by ip i donno)
Default Admin login and password
Posted on: 01/15/06 03:40am
By: Dirk
Default Admin login and password
Posted on: 01/15/06 06:39am
By: Anonymous (Sammo)
Thanks for your reply...
yep thanks for that, but already read and tried (sorry if i dint make that clear) - so what next?
Default Admin login and password
Posted on: 01/15/06 07:07am
By: Anonymous (Sammo)
i just tried setting my cookiedomain to the following:
$_CONF['cookiedomain'] = '.127.0.0.1';
I have had no luck with that. What is interesting is no cookie attempt has been made, as my browser(s) dont report saving it. Im confused!
Default Admin login and password
Posted on: 01/19/06 09:07am
By: Anonymous (Rider)
try to remove the first dot, I mean 127.0.0.1 not .127.0.0.1 ...
cheers