Install Steps #5 Database Setup
|
3dogs
Joined: 2005-12-27
Posts: 28 |
Posted: Tue, 2005-12-27 05:41
|
|
I'm having a lot of trouble understanding postgresql installation instructions. Today is my first day at this and I have no prior experience. I may have installed postgresql, but have no idea how to test it. I created "postgres" dB, but am unable to create a second db called "gallery". Very Kafkaeque. Instuctions do not seemed to be designed so that anyone can use it unless they already know what they are doing, but as far as I can tell postgres is the only "free" DB. I note that the Gallery2 installer does not have a choice for postgresql v8. Is that a problem? I assume not, but worth asking. All I want to do is show a few photos to my friends. Thank you for reading this. I hope someone can help. Gallery version: 2.0.2 |
|
Posts: 28
I take back some of what I said about usability of postgresql. I was able to create a gallery2 db using the admin until which now works after a restart. However, I still can't get past step 5. I am on the console of the web server. I double checked the db names, password and username.
Posts: 32509
pg = postgres = postgresql
@no pg8 choice in the installer:
yep, just choose the postgres7 option
right now, i'm running my test system (linux, pg 8) with the pg7 option of the installer and everything is fine.
@postgres as the only choice
there's also mysql and there's more docs and mysql was at least until now easier to install on windows. pg added a windows installer a while ago, so this might have changed.
g2 is primarily developed for mysql, but we test it regularely with pg too.
what's your current problem at step 5?
do you get any errors / warnings / messages?
Posts: 28
I'll look at mysql again. There is no error. Press save. Computer thinks for a second, then I am back to step 5 with the input data still in place but with no error messages. Thanks again.
Posts: 28
I'll look at mysql again. There is no error. Press save. Computer thinks for a second, then I am back to step 5 with the input data still in place but with no error messages. Thanks again.
Posts: 28
When I first went to Mysql, I only saw the $600 Network edition, not the free Community edition. I have had so much trouble with the instructions of postgres that even though I put 8 hours into it, I am going to scrap it and try Myaql instead.
Posts: 32509
maybe you'll run into this problem though, so here's the description + solution:
FAQ: MySQL "Client does not support authentication protocol" error
Posts: 28
I have installed and am running Mysql and have created a db called gallery2. I created a username for myself and gave myself privileges over gallery2. I am still stuck at step 5 in the gallery2 installer. No error message, just press save and nothing happens.
Posts: 32509
change your php error_reporting level to E_ALL (2047).
also create a screenshot of your step 5 when you hit save.
Posts: 28
I don't know how to change my php error reporting level. I would assume that is a function of PHP. I don't see how to do that and I don't see a GUI. I went back to my web server to make sure PHP was installed correctly. As far as I can tell it is, but I really have no way of testing that. Here is the screenshot after hitting save. Thanks again.
Posts: 32509
it's there in red font!
"You must have the PHP MySQL module installed"
is that no feedback??
in your php.ini file (PHP configuration file), uncomment the mysql extension .dll line and restart the webserver.
Posts: 28
I see that, but that was there when I first encountered the screen.
Posts: 28
I found the php.ini file in Windows. I updated it to the newest file on the php web site. Neither file had any reference to a mysql extension. I saw the mysql section. I did a serch for dll and found nothing. I assume uncomment means to delete default text. Is there any way you could tell me the text I am looking for and how I should alter it? Thanks.
Posts: 28
Now I am getting this error on step 1:
Warning: session_start() [function.session-start]: open(/tmp\sess_50b2cf8ff5ffccf45c12e566977d7971, O_RDWR) failed: No such file or directory (2) in D:\gallery2\install\index.php on line 77
I tried deleting and re copying the gallery2 files to my root but no luck. It looks like it thinks php is messed up, but I am able to open .php files in FireFox.
Posts: 28
I replaced the new .ini file with the original and the error went away. Btw, Safemode is off.
Posts: 28
I got to step 12 by installing v4 which supported mysql. I tried for several hours to get v5 to work, but it would not. I got to step 12 and it said the installation was successful, but not I got the following error message:
Error
An error has occurred.
Back to the Gallery
Error Detail -
Error (ERROR_MISSING_OBJECT) :
* in D:\gallery2\modules\core\classes\GalleryStorage\DatabaseStorage.class at line 2264 (gallerystatus::error)
* in D:\gallery2\modules\core\classes\GalleryStorage\DatabaseStorage.class at line 329 (mysqldatabasestorage::_describeentitymembers)
* in D:\gallery2\modules\core\classes\GalleryStorage.class at line 118 (mysqldatabasestorage::loadentities)
* in D:\gallery2\modules\core\classes\helpers\GalleryEntityHelper_simple.class at line 82 (gallerystorage::loadentities)
* in D:\gallery2\modules\core\classes\GalleryCoreApi.class at line 2186 (galleryentityhelper_simple::loadentitiesbyid)
* in D:\gallery2\init.inc at line 165 (gallerycoreapi::loadentitiesbyid)
* in D:\gallery2\main.php at line 156
* in D:\gallery2\main.php at line 87
* in D:\gallery2\main.php at line 80
Posts: 32509
please delete g2data, drop the database and try a clean install.
check:
FAQ: How can I make sure that my installation files are all intact?
and if it times out durint the install core module step (step 8) or if there's a warning / notice / error, don't ignore it, don't hit refresh etc. instead, report the problem such that we can help you.
Posts: 28
I am re-installing. From Continue to Step 8» I get "Error 500
Internal Server Error
Powered by Abyss Web Server X1
© Aprelium Technologies - 2001-2005".
Posts: 32509
maybe the conclusion of all this is:
g2 may work on the abyss webserver, but only with some luck?
all i can say is: try it again or use apache. g2 hasn't been tested with the abyss webserver and the abyss webserver is sure not as mature as apache.
Posts: 28
ok thank for all the help.
Posts: 28
I wanted to try abyss again but I got this:
Error
Error (ERROR_STORAGE_FAILURE) :
* in D:\gallery2\modules\core\classes\GalleryStorage\DatabaseStorage.class at line 1166 (gallerystatus::error)
* in D:\gallery2\modules\core\classes\GalleryStorage.class at line 245 (mysqldatabasestorage::search)
* in D:\gallery2\modules\core\classes\Gallery.class at line 223 (gallerystorage::search)
* in D:\gallery2\modules\core\classes\helpers\GalleryPluginHelper_simple.class at line 300 (gallery::search)
* in D:\gallery2\modules\core\classes\helpers\GalleryPluginHelper_simple.class at line 241 (gallerypluginhelper_simple::fetchallparameters)
* in D:\gallery2\modules\core\classes\GalleryCoreApi.class at line 216 (gallerypluginhelper_simple::getparameter)
* in D:\gallery2\modules\core\classes\GallerySession.class at line 246 (gallerycoreapi::getpluginparameter)
* in D:\gallery2\modules\core\classes\Gallery.class at line 323 (gallerysession::init)
* in D:\gallery2\init.inc at line 116 (gallery::initsession)
* in D:\gallery2\main.php at line 73
Posts: 32509
if you get storage errors, then it's a mysql problem.
you can enable buffered debug mode to see the actual mysql error:
FAQ: How to set/use Gallery in debug mode?
Posts: 28
I got Apache running, but as I said in my first post, this is all new to me. I really can't figure out what step 2 is on apache, which is why I began using abyss since it had a GUI, not command line. Can you recommend a GUI program that will get me from where I am to a place where I can change the root, set passwords and get php, mysql running as I did on abyss? Thanks.
Posts: 32509
ok, so you're using windows.
i'd recommend that you use a package that is well documented and comes with an installer.
e.g.
http://www.wampserver.com/en/download.php
Posts: 28
I made it to this stage:
Finished!
Congratulations! Your Gallery 2 install is complete! See... that wasn't so hard, was it? Now it's time to upload some photos!
But when I press "Go to my Gallery!:", I get:
Error
Error (ERROR_BAD_PARAMETER) :
* in D:\gallery2\modules\core\classes\helpers\GalleryEntityHelper_simple.class at line 50 (gallerystatus::error)
* in D:\gallery2\modules\core\classes\GalleryCoreApi.class at line 2186 (galleryentityhelper_simple::loadentitiesbyid)
* in D:\gallery2\init.inc at line 155 (gallerycoreapi::loadentitiesbyid)
* in D:\gallery2\main.php at line 156
* in D:\gallery2\main.php at line 87
* in D:\gallery2\main.php at line 80
I tried using the debug line command, but I did not get the massive number of results described in the FAQs.
Posts: 32509
with abyss or apache?
Posts: 28
With both. I'm testing everything on both since I have not mastered security on Apache yet. So far the errors have been the same, so I don't think Abyss is the problem.
Btw, in mysql, the only thing I am doing is creating a db called gallery2. Do I need to configure that db in any further way in preparation for use by Gallery2?
Posts: 32509
sounds like it doesn't get the anonymous user id wasn't properly stored in the database.
are you using mysql 5? a few users already tried it. and some reported issues.
we've tested g2 with mysql 4.x but not yet with mysql 5.
Posts: 28
I'm using 5.
Posts: 28
I was able to install Coppermine which has the similar requirements as Gallery2:
* Good webserver (Apache recommended);
* PHP (4.1.0 or better);
* MySQL (3.23.23 or better; 4.x recommended);
* either GD or ImageMagick (any version)
Perhaps I should downgrade to MySQL 4, what do you think?
Posts: 32509
with some debugging one could find out what exactly goes wrong. it's definitely database<->php related since your error clearly shows that a value that was supposed to be inserted into the db during installation isn't what we expect it to be when we retrieve it during normal operation from the database.
i'd suggest you try mysql 4.
or if you're happy with coppermine, you could spare you some headache and go with coppermine instead. your experience with g2 has been far from optimal and you've spent already too much time getting it to work. so it would be reasonable to use something that just works for you. your choice.
Posts: 28
Some of the time was me just getting up to speed on PHP/MySQL which I would have had to do with any similar program. So far I don't think I want to stick with Coppermine. I already knew that and reinstalled it just for troubleshooting. I will downgrade to MySQL4 and reinstall Gallery2 when I get back into town in two weeks. Have a happy new year.
Posts: 28
I'm now using MySQL 4.1 and getting this error message:
Error (ERROR_BAD_PLUGIN) : Unknown module version 1.0.0.2
* in D:\gallery2\modules\core\CoreModuleExtras.inc at line 1224 (gallerystatus::error)
* in D:\gallery2\modules\core\module.inc at line 490 (coremoduleextras::upgrade)
* in D:\gallery2\modules\core\classes\GalleryModule.class at line 158 (coremodule::upgrade)
* in D:\gallery2\install\steps\InstallCoreModuleStep.class at line 125 (coremodule::installorupgrade)
* in D:\gallery2\install\index.php at line 167 (installcoremodulestep::loadtemplatedata)
Posts: 32509
this error doesn't make a lot of sense.
please delete g2data/ / drop the database, optionally also restart the webserver and install g2 again.
Posts: 28
Now I'm getting this error:
Error (ERROR_MISSING_OBJECT) :
* in D:\gallery2\modules\core\classes\GalleryStorage\DatabaseStorage.class at line 2264 (GalleryStatus::error)
* in D:\gallery2\modules\core\classes\GalleryStorage\DatabaseStorage.class at line 329 (DatabaseStorage::_describeEntityMembers)
* in D:\gallery2\modules\core\classes\GalleryStorage.class at line 118 (DatabaseStorage::loadEntities)
* in D:\gallery2\modules\core\classes\helpers\GalleryEntityHelper_simple.class at line 82 (GalleryStorage::loadEntities)
* in D:\gallery2\modules\core\classes\GalleryCoreApi.class at line 2186 (GalleryEntityHelper_simple::loadEntitiesById)
* in D:\gallery2\init.inc at line 165 (GalleryCoreApi::loadEntitiesById)
* in D:\gallery2\main.php at line 156
* in D:\gallery2\main.php at line 87
* in D:\gallery2\main.php at line 80
Same as before. I'm back to using the newest versions of PHP and SQL, so that may expain it.
Posts: 32509
please try the latest nightly snapshot of g2.
no idea if it will work. we changed a lot, so if you're lucky...
Posts: 28
Better, but still problems. I got an error during installation. screen shot attached.
I got a server error at step 8, but then was able to get to the Main Page , screenshot attached. It seems that some of the core did not get installed because I can't get to a configuration page.
Any ideas? This is on Abyss. I will try again on Apache.
Posts: 32509
- systemchecks: gettext is ok, missing files: these 2 files are not in the zip, only in the tar.gz, that is fine, output buffering is not good. you should disable it
- did you get an error during the install core or install other modules step? if so, reinstall. not acceptable
- main page looks good.
Posts: 28
I tried to change outputbuffering, but when I set it to "on", it appears that the value goes to 1. I set it to 46960 for the time being. Although I can see the main page, I cannot navigate anywhere other than the cart and the main page, so I assume the install is corrupt. I tried reinsatlling, but same result. I am getting the same internal server error, so it may be a problem with Abyss, but I until I master Apache, I may be out of luck. Thanks.
Posts: 32509
set it to
output_buffering = Off
you can't login? in the right upper corner is the login link. once logged in, you'll see all the option.
Posts: 28
I don't see any place to log in. I'm including the screenshot of the top of the page to show that there is nothing in the right upper corner.
I'll change PHP. Thanks.
Posts: 32509
maybe try another browser. firefox or so.
but there should be a login link in the upper right corner.
Posts: 28
I only use FF. I'll try IE.
Posts: 32509
can't explain why there's no login link.
but so much went wrong on this server, so it's "normal" for your server.
can't help you...
Posts: 28
thanks.