Welcome to Geeklog, Anonymous Saturday, August 31 2024 @ 11:02 pm EDT
Geeklog Forums
Default Admin login and password
loloviolo
Anonymous
I just intalled GeekLog but cannot access Admin.
11
7
Quote
Johannes
Anonymous
![confused confused](https://www.geeklog.net/forum/image_set/moods/confused.gif)
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?
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?
8
12
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Quote by Johannes: it displays the success page and advises me to read the first story - except that there is no story.
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?
Username: Admin, password: password
bye, Dirk
5
10
Quote
Johannes
Anonymous
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:
All of the above makes me think I have a MySQL issue, any thoughts on this?
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?
9
7
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Quote by Johannes: 7. Click on next. At this point browser shows it's waiting on webserver, then page turns blank.
![Read the FAQ Read the FAQ](http://www.geeklog.net/images/smiles/rtfm.gif)
8
6
Quote
Johannes
Anonymous
(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?
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?
7
14
Quote
Johannes
Anonymous
...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?
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?
9
5
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
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
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
6
6
Quote
Johannes
Anonymous
![caffeinated caffeinated](https://www.geeklog.net/forum/image_set/moods/caffeinated.gif)
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
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:
Text Formatted Code
$_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:
Text Formatted Code
$_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
![Wink Wink](http://www.geeklog.net/images/smiles/icon_wink.gif)
9
5
Quote
Sammo
Anonymous
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.
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.
8
6
Quote
Sammo
Anonymous
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
I checked permissions - all fine.
The site is running off my own linux box - so any server admin questions let me know
![Wink Wink](http://www.geeklog.net/images/smiles/icon_wink.gif)
10
8
Quote
Sammo
Anonymous
one more thing - it identifies me as a guest though! So it knows im here (maybe by ip i donno)
12
9
Quote
Sammo
Anonymous
Thanks for your reply...
yep thanks for that, but already read and tried (sorry if i dint make that clear) - so what next?
yep thanks for that, but already read and tried (sorry if i dint make that clear) - so what next?
5
8
Quote
Sammo
Anonymous
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!
$_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!
![Can someone help me Can someone help me](http://www.geeklog.net/images/smiles/help.gif)
10
8
Quote
Rider
Anonymous
try to remove the first dot, I mean 127.0.0.1 not .127.0.0.1 ...
cheers
cheers
8
11
Quote
All times are EDT. The time is now 11:02 pm.
- Normal Topic
- Sticky Topic
- Locked Topic
- New Post
- Sticky Topic W/ New Post
- Locked Topic W/ New Post
- View Anonymous Posts
- Able to post
- Filtered HTML Allowed
- Censored Content