Re: Username and password login!
Posted by
Verus Open Source Support on
Feb 22, 2012; 4:31am
URL: http://ngl.70.s1.nabble.com/Username-and-password-login-tp5558186p7307145.html
Hi,
Firstly please check the below:
1. Start->Programs->Postgresql8.X->Pgadmin3. Also connect
to the localhost database server.
2. Open
Databases->newgenlib->Schemas->public->Tables->patron->Columns
There must be a column called twitter_id. If this is not there then
Go to InstallNGL3.0/upgrade303 directory. In this you will find a
file named V303AddedScripts.sql. This must be executed against the
newgenlib database. To do that
1. Go to Command prompt
2. In command prompt go to the directory C:/Program
Files/Postgresql/8.X/bin directory. Type this command
psql -d newgenlib -U postgres
You may be prompted for the password. It is newgenlib. Then type
this command
\i C:/InstallNGL3.0/upgrade303/V303AddedScripts.sql
Now login. This must work
On 02/22/2012 04:14 AM, cbush06 [via NewGenLib] wrote:
It is my first installation. I installed version
3.0.3 U3. I read through all of the SQL scripts that came with it
and could not find an INSERT statement for a system user.
I am not sure if this could be the source of the problem. I have
tried everything including uninstalling and reinstalling
everything. Please advise.
Also, I work a regular job and cannot be available to chat until
5PM Eastern Time, US.
Thank you,
Clinton
NewGenLib Open Source Support
Verus Solutions Private Limited
www.verussolutions.biz