New 0.82 install problems

Frank · Post by **Frank** » Sat Jul 23, 2005 12:49 am

I'm new to blogs and chose S9y from online info.
Attempting a fresh install on FreeBSD server with shared webspace...
Near as I can tell all the mins are met.

blog is at www.catspeaker.com/blog/ (www.active-domain.com)
Database host: mysql.active-venture.com (SQL files reside outside webspace for catspeaker.com)
Database name: camtron_cats
(Had to manually forge database using phpMyAdmin tool after browsing the SQL update resource)

Problem is, while I get a Blog page with no entries, there appears to
be no way to add entries. The admin page prompts for user id and
password, but none work. I received the "Serendipity has been successfully installed" msg, but cannot do much more than that.

I reviewed the SQL update files to discover the file structures and
tables, which I had to manually forge. The install added entries to
the config table, but not others.

Please help me from losing all my hair... I suspect some link is wrong
( Yes, I have the trailing slash) but don;t know where to look. Any help
would be appreciated.

Thanks,

Frank

Particulars of install follow:

Serendipity v0.8.2 pre-installation report -

PHP installation
Operating system FreeBSD 4.11-RELEASE-p10, i386
Webserver SAPI apache
PHP version >= 4.1.2 Yes, 4.3.11
Database extensions MySQL, PostgreSQL
Session extension Yes
PCRE extension Yes
GDlib extension Yes
OpenSSL extension Yes
mbstring extension Yes
iconv extension Yes
zlib extension Yes
Imagemagick binary Not found

php.ini configuration
Recommended Actual
safe_mode OFF ON
register_globals OFF ON
magic_quotes_gpc OFF ON
magic_quotes_runtime OFF OFF
session.use_trans_sid OFF ON
allow_url_fopen ON ON
file_uploads ON ON
post_max_size 10M 15M
upload_max_filesize 10M 5M

Permissions
/hsphere/local/home/camtronix/catspeaker.com/blog/ Writable
/hsphere/local/home/camtronix/catspeaker.com/blog/templates_c Writable
Execute Imagemagick binary Not found

*SIMPLE INSTALL REPORT*
----------------------------------
Checking to see if the database and tables already exists... they do not
Creating default database setup... Done
Creating primary author 'camtron_admin'... Done
Setting default template... Done
Installing default plugins... Done
Attempting to write .htaccess file...... Done
Serendipity has been successfully installed

-----------------------------------

Post by **garvinhicking** » Sat Jul 23, 2005 4:10 pm

Check your DB table "camtron_authors", there should be a admin user created! It uses the username+password you enter in the install screen, so you must have recognized it.

The Default is "John Doe" with password "doe".

If no camtron_authors table or entries exist, there might be a problem with your MySQL version. Which version do you have?

Regards,
GArvin

Frank · Post by **Frank** » Sun Jul 24, 2005 4:35 am

Garvin,

Thanks for the quick reply. mySQL is a late version... I'll have to ask provider for specifics. Table serendipity_authors exists in the camtron_cats DB and the IDs/Passwords look in order. The index page only loads the non-existant entries, and the admin page won't allow access, so somehow
something is not finding the tables, but some apparently is, as entries
in the config table display properly.

In about 1/4 the time, I got phpBB2 up and running, and that also uses mySQL for DB info. So not sure what went wrong with s8y.

Frank

Post by **garvinhicking** » Sun Jul 24, 2005 4:34 pm

Hm, it is a strange thing that you cannot access the admin suite. Is your server properly configured to use PHP Session Cookies? Is your browser configured to accept Session Cookies?

Are you sure you enter the right username/password combination? Remember you have to login with the "username" and not the "Realname" you configured!

Regards,
Garvin

Frank · Post by **Frank** » Mon Jul 25, 2005 6:42 am

Thanks Garvin,

Using Firefox 1.0.4 and yes, I see the php session cookies.
Yes, using correct usedID and Password.
It is interesting to note that s9y would not create all the databases
tables during the install process. I review the SQL db update files
and had to forge the tables accordingly.

It has to be related to s9y not finding the SQL database.
Perhaps a timing issue with my particular server. The db may not
be on the same server as the php files.

Interesting to note that phpBB2 created all the SQL tables it needed
with no install problem whatsoever. I even moved it to a different
domain and it still works fine.

Perhaps you can point me to the app that checks, opens, manages the
SQL db tables.

Frank

Post by **garvinhicking** » Mon Jul 25, 2005 3:37 pm

If you send me a SQL dump of all your s9y-related tables (with data) I can check what is maybe missing.

That some tables are not created is unusual. I bet there are some problems with your database; did you install phpBB2 with the same privileges like s9y? Maybe the phpbb tables uses other types or Mysql escaping that we cannot use due to our Cross-DB (pgsql, sqlite) compatibility.

Regards,
Garvin

randulo · Post by **randulo** » Mon Jul 25, 2005 4:26 pm

Frank wrote:

Code: Select all

  			Recommended 	Actual
safe_mode 		OFF 		ON
register_globals 	OFF 		ON

Having safe mode ON may be a problem. If you can, get it removed.

Guest · Post by **Guest** » Fri Jul 29, 2005 5:14 am

Gavin, do you agree with randulo?

I cannot pm you as I cannot register due to email system being defunct.
How do you suggest I send the sql dump to you?

Frank

Post by **garvinhicking** » Fri Jul 29, 2005 11:41 am

I'm sorry : Send the dump to "mail (at) garv[dot}de".

Disabling SafeMode is always a good thing for full interaction, but in your system it should not affect anything. In your case I do think there are important tables missing because of your MySQL version.

BTW, which MySQL are you running?

Regards,
Garvin

francisco · Post by **francisco** » Mon Aug 01, 2005 3:49 pm

garvinhicking wrote:Disabling SafeMode is always a good thing for full interaction..

But will the program run with it enabled?
What are the benefits to the program on having SafeMode off?

Post by **garvinhicking** » Mon Aug 01, 2005 6:04 pm

Serendipity is not tested if it works with SafeMode. It may work, but it may not work. There are many things different when running in SafeMode.

The benefits from running in SafeMode off is that Serendipity guaranteedly works.

Regards,
Garvin

Guest · Post by **Guest** » Mon Aug 01, 2005 7:06 pm

Which I presume means everyone runs as USERLEVEL_CHIEF. No?

Garvin, did you receive my SQL dump file?
Comments?

Frank

Post by **garvinhicking** » Mon Aug 01, 2005 8:18 pm

The userlevels have nothing to do with SafeMode?!

Sorry I didn't receive the SQL dump file, but I saw I made an error. The address is "@ garv (dot) in" instead of de. I'm sorry!

Regards,
Garvin

francisco · Post by **francisco** » Tue Aug 02, 2005 4:13 am

garvinhicking wrote:Serendipity is not tested if it works with SafeMode. It may work, but it may not work. There are many things different when running in SafeMode.

I will try it in SafeMode since it's my web hosting companie's default and see what if anything needs to be changed..

A quick check in the PHP site it seems there is a set of subset permissions which can be set instead of safemode.
http://us3.php.net/features.safe-mode

Guest · Post by **Guest** » Tue Aug 02, 2005 8:18 pm

Garvin,

Check you email for the SQL file dump.

MySQL server version 4.0.24

Frank

New 0.82 install problems

New 0.82 install problems

Re: New 0.82 install problems

Re: New 0.82 install problems

Cannot register

Re: Cannot register

Re: Cannot register

Re: Cannot register

safe mode

Re: safe mode

Re: Cannot register

MySQL server version 4.0.24