Pixelpost

shimp999 · #1 11-12-2004, 04:14 AM

Hi,
I followed the installation steps. Got to the point where I go to http://myhost/pixelpost/admin/.

I get a "PIXELPOST ADMIN" login screen and above the login box, there's this:

Code:

Warning: Cannot modify header information - headers already sent by (output started at /home/shimp/public_html/pixelpost/admin/pixelpost.php:20) in /home/shimp/public_html/pixelpost/admin/index.php on line 20

I try to login with my username and password and get invalid user/pw. Any help on this?

pixelpunk · #2 11-12-2004, 05:31 AM

Php can be mistaken in line numbers when throwing errors. That error would only occur if pixelpost can connect to the database but can't find the tables.

Let's try to eliminate it anyway. Open up /admin/index.php and look at line 20:
header("Location: install.php");

Put two slashes in front of it so that it looks like this:
// header("Location: install.php");

Let me know how it goes,

// punk

Anonymous · #3 11-12-2004, 06:22 AM

I commented out the line and I no longer get the warning. Now I get the admin login screen but how do I log in, I haven't created an account yet.

pixelpunk · #4 11-12-2004, 06:31 AM

Are you sure you have not?
You should have done that while installing, on the first screen:

You need to choose a username and password. This will be what you use in order to login and publish images to your photoblog.
Both username and password can be altered later.

If you somehow didn't install it correctly, the first error makes much more sense btw.

Have a look at your mysql-tables to verify that pixelpost has indeed been installed. If it have and there are no admin user inside the pixelpost_config table you need to edit the table and insert a username there (admin field). After that you can login.

// punk

Anonymous · #5 11-12-2004, 06:42 AM

Looks like no tables were not created during the install. I may have the database names or something wrong. I create the database on my host through cpanel. When I created the database, "pixdb", cpanel shows me "username_pixdb". In my pixelpost.php file, under database, is the database name "pixdb" or "username_pixdb". Also, the username I created for my mysql database is username. But its listed as username_

Not sure which i'm suppose to use...

pixelpunk · #6 11-12-2004, 07:42 AM

I've got cpanel installed aswell and when I create a new db I need to manually assign a user to that db. It might be different for you, but make sure that a user is assigned to the db.

Under the database listing it should read something like this:

myaccountusername_pixelpost
Users in pixelpost
myusername_db (Privileges: ALL PRIVILEGES)

shimp999 · #7 11-12-2004, 02:19 PM

Yeah, I made sure to assign a user to my db. I dont think thats the problem though, I'm trying to understand the naming scheme. When I tell cpanel to create a db, for the name of the db, I type "pixdb". A new database is created *BUT* I see that its listed as "username_pixdb". So in the pixelpost.php file, for the database, do I use "pixdb" or "username_pixdb"?

Also, in pixelpost.php, should the user be "username" or "username_"?

I tried deleting my database and starting from scratch. I created a database called "pixdb". Cpanel shows a "username_pixdb". I add a user to that database by clicking on add user. Cpanel shows a new user added called "username_".

In pixelpost.php, I have this:

Code:

$pixelpost_db_host      = "localhost"; // database host, often "localhost"
$pixelpost_db_user      = "username_"; // database user
$pixelpost_db_pass      = "mypassword"; // database user password
$pixelpost_db_pixelpost = "username_pixdb"; // database

I get this error now:

Code:

Warning: mysql_connect(): Access denied for user: 'username_@localhost' (Using password: YES) in /home/username/public_html/pixelpost/admin/index.php on line 12
Error: Access denied for user: 'username_@localhost' (Using password: YES)

If I change the user is pixelpost.php to "username" (drop the underscore), I get the same problem I had originally--a login screen and it just bypasses the rest of the installation. No tables are ever created and it never asks me to make a login.

Really dont understand what the problem is. I set up Movable Type previous to this and it went fine.

shimp999 · #8 11-12-2004, 02:36 PM

I got it!

I deleted everything, and uploaded the files again. Editted the necessary info and the install worked. All the tables were created and I made my login info.

I guess what went wrong for me was that if you mistype the info for your database in pixelpost.php and run the admin, I should have deleted everything and started fresh again.

Thanks for the help though

pixelpunk · #9 11-12-2004, 02:37 PM

Oh, great!

// punk

Pixelpost

Authentic Photoblog Flavour