I failed installation of SIDB, after this point :
"A new database for SIDB is about to be created. Please review the following parameters carefully
Database name
Database user (valid postgresql user)
Database user password (only needed when you
want to secure postgresQL access later on)
Sysadmin password (for SIDB access), change this
Path to postgresql binaries"
It returns me :
"Failed to make a new database.
Maybe bottar19 is not a valid postgresql user?
Otherwise, you might have to temporarily disable password protection of your postgresql set-up and try again"
but passwords are disabled !
I have a PostGreSQL 6.5. do you think PGSQL 7 is required ?
I have seen nothing wrong in the includes/config.inc.php file.
What can I do ?
Thierry Bottaro
(bottar19)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Is bottar19 a valid postgresql user? That is, can you create new databases, like:
createdb -U bottar19 test
which should produce a database 'test'.
If this fails, simply add a user bottar19 by typing
createuser
and make sure that this new user is allowed to create new databases.
If all of this does not help, or was done already, it is likely that postgres 6.5 does not like the database we are creating. Try upgrading to 7 or higher and let us know the solution to the problem.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
first, thank you for responding.
but I tried what you tell me to test , see :
bottar19@pacaya:/usr/lib/postgresql/bin$ createdb -U bottar19 test
createdb: unrecognized parameter -U
Usage: createdb -a <authtype> -h <server> -p <portnumber> -D <location> -E <encoding> [dbname]
bottar19@pacaya:/usr/lib/postgresql/bin$ createdb test
bottar19@pacaya:/usr/lib/postgresql/bin$ psql -l
datname |datdba|encoding|datpath
---------+------+--------+---------
template1| 31| 7|template1
test | 1003| 7|test
(2 rows)
as you can see, when I do that in my name it is working but the parameter "-U" seems to be unrecognized ....
I guess it means that I must update postgresql to 7 or higher.
Now I have a another question: how can I do to upgrade. in fact, I already tried but it's seems very dificult for me to install a "unstable" package.....
Thank you, again.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
OK, Postgres 6.5 does not like the -U. If you feel adventurous you could try deleting "-U $db_user" on line 880 of "install.php". That should solve this problem, but... there are likely to be more problems with 6.5.
I don't really understand what you mean with an "unstable" package. Postgres 7 has been part of major distributions for a year or so. It comes standard with current RedHat, Suse etc.. If I am not mistaken, the current stable version is 7.1. Find an rpm that fits your distribution or compile your own.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
It remains classified as "unstable" for debian, and debian does not accept .rpm ....
I tried deleting "-U $db_user" at line 836 (and not 880 ...) but it gaves me the same error.
So I will concentrate my efforts in upgrading my postgresql. Does the option "postgresql upgrade" exists ?
Just for information : does your PHP program can give errors generated by Postgres ?
Thank you for your help
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have now install Red Hat 7, so previous problems are solved
I succeed in installing SIDB19
but now when I click on the "Globals" link which is linked to install.php, I have a error message :
Illegal operation performed!
Reported error:
Could not execute query SELECT * FROM users WHERE login='sysadmin'!
Errormessage reported from database:
Warning: 1 is not a valid PostgreSQL link resource in /var/www/sidb/includes/functions_inc.php on line 75
But I have 2 other questions which are quite more important:
can we upload a entire directory of images ?
Can we make backups of the database ? and is the database in the databasefile.pql or in the /var/lib/pgsql/data/base/my_sidb_base ?
Thank you
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Regarding the error message: I have note seen that one before. Since you just got started it is a good idea to drop the database (dropdb sidb) and create it again (createdb sidb) and try the install.php script again.
>Can we upload an anitre directory: Yes, but only through the 'move file from your images directory' mechanism. This might be quite complicated to setup since the entity running your webserver must be able to move images owned by your users to a special directory and then have all rights on those files. I solved it ACL, but not too many filesystems have that. You can probably do the same thing by tweeking the permissions, but it all depends on your system. Once you have that going, you can select as many images in that directory as you wish.
>Can we make backups of the database ?
Yes, postgres has a nice utility called 'pg_dump'. Call it as follows: pg_dump sidb >sidb_backup_today.txt. You can compress this file and store it somewhere safe. Also a great way to move your database to another box.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I tried to re-install (I made dropdb sidb; createdb sidb then I tryed "localhost/sidb/install.php")
Then I click the Submit button and it gave me the same error message as I describe earlier.
but if I log normally, it seems to work as before.
===> I'm lost!
Thank you for answering me.
Thierry
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
>but if I log normally, it seems to work as before.
I do not understand what you mean. If you can log in using another user name, your original database was not destroyed.
Are you first being asked for a database name, user, etc...? If not, please look in the file includes/config_inc.php and find the name of the database you are using....
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Arghhh. I goofed. You should NOT do the createdb sidb. The php script will create the database itself, and takes its existence as a trigger to not make the tables, so creating it yourself will cause problems.
Sorry, I simply confused two different projects...
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Arghhh. I goofed. You should NOT do the createdb sidb. The php script will create the database itself, and takes its existence as a trigger to not make the tables, so creating it yourself will cause problems.
Sorry, I simply confused two different projects...
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
You're right, I think teh right way to install sidb is without creating a base.
So I re-tried, and just after cliking the "create DB" button it showed me the login page, I entered the "sysadim" passwd, and it gave the same error. So I called "login.php", the syadmin login worked, but when I click in the "globals" link, it remains the error ....
I think, I would keep this work like this.
I have another question: I can't see the 'move file from your images directory' button. It should appear in the "upload" page, isn't it ?
Thierry
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
>You're right, I think teh right way to install >sidb is without creating a base.
>So I re-tried, and just after cliking the "create DB" button it showed me the
login page, I entered the "sysadim" passwd, and it gave the same error.
Which error???
The 'move file from your images directory' will only be active when there is a user name that matches a user name on your system, and there is a readable directory with a name as set in the user's prefs.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Welcome to Help
I failed installation of SIDB, after this point :
"A new database for SIDB is about to be created. Please review the following parameters carefully
Database name
Database user (valid postgresql user)
Database user password (only needed when you
want to secure postgresQL access later on)
Sysadmin password (for SIDB access), change this
Path to postgresql binaries"
It returns me :
"Failed to make a new database.
Maybe bottar19 is not a valid postgresql user?
Otherwise, you might have to temporarily disable password protection of your postgresql set-up and try again"
but passwords are disabled !
I have a PostGreSQL 6.5. do you think PGSQL 7 is required ?
I have seen nothing wrong in the includes/config.inc.php file.
What can I do ?
Thierry Bottaro
(bottar19)
Is bottar19 a valid postgresql user? That is, can you create new databases, like:
createdb -U bottar19 test
which should produce a database 'test'.
If this fails, simply add a user bottar19 by typing
createuser
and make sure that this new user is allowed to create new databases.
If all of this does not help, or was done already, it is likely that postgres 6.5 does not like the database we are creating. Try upgrading to 7 or higher and let us know the solution to the problem.
first, thank you for responding.
but I tried what you tell me to test , see :
bottar19@pacaya:/usr/lib/postgresql/bin$ createdb -U bottar19 test
createdb: unrecognized parameter -U
Usage: createdb -a <authtype> -h <server> -p <portnumber> -D <location> -E <encoding> [dbname]
bottar19@pacaya:/usr/lib/postgresql/bin$ createdb test
bottar19@pacaya:/usr/lib/postgresql/bin$ psql -l
datname |datdba|encoding|datpath
---------+------+--------+---------
template1| 31| 7|template1
test | 1003| 7|test
(2 rows)
as you can see, when I do that in my name it is working but the parameter "-U" seems to be unrecognized ....
I guess it means that I must update postgresql to 7 or higher.
Now I have a another question: how can I do to upgrade. in fact, I already tried but it's seems very dificult for me to install a "unstable" package.....
Thank you, again.
OK, Postgres 6.5 does not like the -U. If you feel adventurous you could try deleting "-U $db_user" on line 880 of "install.php". That should solve this problem, but... there are likely to be more problems with 6.5.
I don't really understand what you mean with an "unstable" package. Postgres 7 has been part of major distributions for a year or so. It comes standard with current RedHat, Suse etc.. If I am not mistaken, the current stable version is 7.1. Find an rpm that fits your distribution or compile your own.
It remains classified as "unstable" for debian, and debian does not accept .rpm ....
I tried deleting "-U $db_user" at line 836 (and not 880 ...) but it gaves me the same error.
So I will concentrate my efforts in upgrading my postgresql. Does the option "postgresql upgrade" exists ?
Just for information : does your PHP program can give errors generated by Postgres ?
Thank you for your help
I have now install Red Hat 7, so previous problems are solved
I succeed in installing SIDB19
but now when I click on the "Globals" link which is linked to install.php, I have a error message :
Illegal operation performed!
Reported error:
Could not execute query SELECT * FROM users WHERE login='sysadmin'!
Errormessage reported from database:
Warning: 1 is not a valid PostgreSQL link resource in /var/www/sidb/includes/functions_inc.php on line 75
But I have 2 other questions which are quite more important:
can we upload a entire directory of images ?
Can we make backups of the database ? and is the database in the databasefile.pql or in the /var/lib/pgsql/data/base/my_sidb_base ?
Thank you
Regarding the error message: I have note seen that one before. Since you just got started it is a good idea to drop the database (dropdb sidb) and create it again (createdb sidb) and try the install.php script again.
>Can we upload an anitre directory: Yes, but only through the 'move file from your images directory' mechanism. This might be quite complicated to setup since the entity running your webserver must be able to move images owned by your users to a special directory and then have all rights on those files. I solved it ACL, but not too many filesystems have that. You can probably do the same thing by tweeking the permissions, but it all depends on your system. Once you have that going, you can select as many images in that directory as you wish.
>Can we make backups of the database ?
Yes, postgres has a nice utility called 'pg_dump'. Call it as follows: pg_dump sidb >sidb_backup_today.txt. You can compress this file and store it somewhere safe. Also a great way to move your database to another box.
I tried to re-install (I made dropdb sidb; createdb sidb then I tryed "localhost/sidb/install.php")
Then I click the Submit button and it gave me the same error message as I describe earlier.
but if I log normally, it seems to work as before.
===> I'm lost!
Thank you for answering me.
Thierry
>but if I log normally, it seems to work as before.
I do not understand what you mean. If you can log in using another user name, your original database was not destroyed.
Are you first being asked for a database name, user, etc...? If not, please look in the file includes/config_inc.php and find the name of the database you are using....
Arghhh. I goofed. You should NOT do the createdb sidb. The php script will create the database itself, and takes its existence as a trigger to not make the tables, so creating it yourself will cause problems.
Sorry, I simply confused two different projects...
Arghhh. I goofed. You should NOT do the createdb sidb. The php script will create the database itself, and takes its existence as a trigger to not make the tables, so creating it yourself will cause problems.
Sorry, I simply confused two different projects...
You're right, I think teh right way to install sidb is without creating a base.
So I re-tried, and just after cliking the "create DB" button it showed me the login page, I entered the "sysadim" passwd, and it gave the same error. So I called "login.php", the syadmin login worked, but when I click in the "globals" link, it remains the error ....
I think, I would keep this work like this.
I have another question: I can't see the 'move file from your images directory' button. It should appear in the "upload" page, isn't it ?
Thierry
>You're right, I think teh right way to install >sidb is without creating a base.
>So I re-tried, and just after cliking the "create DB" button it showed me the
login page, I entered the "sysadim" passwd, and it gave the same error.
Which error???
The 'move file from your images directory' will only be active when there is a user name that matches a user name on your system, and there is a readable directory with a name as set in the user's prefs.