installing...

[momax]

hi,

i have installed cpg1.2 firsttime, i have created a user cpgadmin in the mysql.user table with this command:

INSERT INTO user VALUES('localhost','cpgadmin', PASSWORD('myPASSWORD'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');flush privileges;

created with this new user a database called: cpgfoto;

after that i unzipped cpg1.2 to the htdoc root directory, renamed it to cpq.

From the browser, i was running the install.php, well it finished witout any problem,
i logged in with the cpgadmin user, but there is no link or button for administer the Albums.......

Please could somebody help me
THX
MOMAX

[Casper]

I don't understand why you created a user using the database tool.  When you ran the install.php, you should have been asked to supply a username and password.  This is the one you should use to logon as admin.
Then you can create new users from within the cpg users admin page.

[momax]

because if i do not create a database, an error with the install script occurs:

the following errors were encountered and need to be corrected first:
"mySQL could not locate a database called 'gallery_db' please check the value entered for this",

i checked then value; gallery_db,

Therefore i created the db by hand with the an mysqladmin user;

after that the install seems to work, but after logon, i couldnt administer , neither create an album, i have no link,no button , no checkbutton for logon as Admin


for the  admin account:          
(This section requires information to create your administration account. Use only alphanumeric characters. Enter the data carefully !)        
Username                  
Password
                 
i took a new username: cbgadmin with  pw called test01pw
i thought this user will be entered to the mysql.user  table;

in the MySql Section i took the Adminuser for changing Databases on my MySql Host

"Your MySQL configuration: This section requires information on how to access your MySQL database. If you don't know how to fill them, check with your webhost support.
i thought this user will, connect to the MySql Database, will create the user and the database.

MySQL Host : localhost
(localhost is usually OK)                  
MySQL Database Name: gallery_db                  
MySQL Username                  sqladmin
MySQL Password                  xxxxxxxxx
MySQL table prefix                  cdg_

is there something i missunderstood?  should i create an user in the mysql.user table or not, or should the install script do all teh work....

many thanks, if  i get an answer

nye
MoMax

[Casper]

If the install completed ok, then you should login using the name/password you gave during install;

i took a new username: cbgadmin with pw called test01pw

If you still have problems, please give a link to your gallery.

[momax]

i will send you the link in the evening,  i have installed it twice, i have used version 1.2 and 1.3beta, same problem.....

i have wrote some php scripts  for creating, dropping the database

if i use the install.php. no database will be created.

i have read the Readme.html, chmod -R 777 for albums and include

filled form:
adminuser: cpg
pw: test01pw

MySql User  : phpadmin
pw: xxxxxxxx
db : cpg_gallery_db
host: localhost
table: cpg_

imagemagick path: /usr/bin/

submit...

error could not find database cpg_gallery_db

if i use my own script (/test/createdb.php) for creatig a db,
and rerun the install.php, the cpg_gallery_db will be filled with tables
cpg_albums,..........

an i could also logon with the adminuser "cpg"
" Wecome cpg"

but thats all.....

config.inc.php will be created , with all needed features

and if i make a mysqlquery by hand

i can see the cpg user with uid 1 , group 1 and the username, date_registered; date_lastvisit

if i find no further failure of mine, i will send you a pm

best regards
Mo Max

[Joachim Müller]

expected behaviour: coppermine installer doesn't create databases for you (since most users who are webhosted are only allowed to have one database anyway).
Recommended method: create a database, set up a mySQl user account if necessary, use a tool like phpMyAdmin to check if the user has the required privileges for the database, then run the coppermine installer.

Do not post admin account usernames and passwords here - this is an open board!

GauGau

[momax]

you need the link to use this pw......

but ok ....... you're right......

2.2 Getting started
Log in with the admin username and password you set up during install, click on the "admin mode" link if it is visible

Thats my Problem.... , i have no Admin Mode Link.... i am not blind, and the install.php said installing successfull , i logged in, get an "welcome AdminUser", which i have used with the install script....... no link

Any Ideas!! What does it mean "if link is visible" , is there something, what  i could do to get adminrights? i have also checked the cpgdb userid 1 groupid 1, i should be the Admin, whats going wrong here , i have also installed the phpBB2 Board... wothout any problems....

and what does that mean
error.log
PHP Fatal error:  Call to undefined function:  imagecreate() in /usr/local/apache2.0/htdocs/cpg/install.php on line 504
PHP Fatal error:  Call to undefined function:  imagecreatetruecolor() in /usr/local/apache2.0/htdocs/cpg/install.php on line 510
PHP Fatal error:  Call to undefined function:  imagecreate() in /usr/local/apache2.0/htdocs/cpg/install.php on line 504
PHP Fatal error:  Call to undefined function:  imagecreatetruecolor() in /usr/local/apache2.0/htdocs/cpg/install.php on line 510

is that a problem "PHP Version 4.2.0RC3", MySql 3.23.58, Apache 2.0.35,ImageMagick 5.3.8, the sys is only a testsys, on other servers i use newer ones.....

best regards
Mo Max

[Joachim Müller]

if you get a message like "welcome admin" and don't see the admin mode in the next screen, there's a cookie issue, so you're not logged in. Take a look at http://forum.coppermine-gallery.net/index.php?topic=3642 http://forum.coppermine-gallery.net/index.php?topic=4217 http://forum.coppermine-gallery.net/index.php?topic=3884 etc.

GauGau

P.S. Security by obscurity won't work in your case, I have the url:

you need the link to use this pw......

http://nuloki.ath.cx/cpg/

[momax]

you are right again.... lol.........

but what does the Slash in Variable cookie_path mean / ....  does that mean DocumentRoot ??

or what??

ciao
Mo Max

[momax]

could anybody explain me this select statement:

SELECT * FROM cpg_users, cpg_usergroups WHERE user_group = group_id AND user_id='0' AND user_active = 'YES' AND user_password != '' AND BINARY MD5(user_password) = '*'

why is the script searching for uid 0, there is no uid null;
uids beginning with 1

best regards
Mo Max