Portal Home > Knowledgebase > Articles Database > Postgre phpbb3 install problem
Postgre phpbb3 install problem
| Posted by sachadmin, 09-03-2007, 11:02 AM |
| Hello,
One of our domain is getting problem while installing Postgress phpbb3.
I got the following error while creating it on my phpbb3 installation.
"The database you have selected was not created in UNICODE or UTF8 encoding. Try installing with a database in UNICODE or UTF8 encoding."
When we try to login using "psql -U postgres -W" it doesn't work.
Please let us know what should we do to fix this issue.
Thank You
|
| Posted by mwatkins, 09-03-2007, 12:18 PM |
| Create your database with a UTF8 encoding, either from the command line:
man createdb
Or from psql / via a sql script:
http://www.postgresql.org/docs/8.2/s...edatabase.html
|
| Posted by sachadmin, 09-05-2007, 07:27 AM |
| Hello,
Thank you for your reply but
First we are not able to login by
"psql -U postgres -W"
we get "psql: FATAL: IDENT authentication failed for user "postgres""
this message
~ Sachin
|
| Posted by mwatkins, 09-05-2007, 10:28 AM |
| Your login issue could be a number of things; perhaps you should speak to your provider if checking the following gets you no where.
1. Are you sure you have the right id/password? Error message suggests not.
2. Are you sure the Postgresql user on your system is named "postgres"? On my systems (FreeBSD) by default it is "pgsql". Check /etc/passwd and see.
A permitted user (a Postgresql 'superuser') on my systems can issue:
% psql -U pgsql postgres
And access using that ID. If you've not created roles for the user id you are logging in as, you'll need to do that.
3. man createuser
Your ID must at least have createdb privileges.
If you have root access to the box, use that to create a role for your application to use.
|
Add to Favourites 
Print this Article
Also Read
