[Dspace-tech] Can't log onto admin - follow up
Thanks for the support, I didn't realize that the proper url was .../dspace/dspace-admin. I'm still having connection issues, but I've played around with it a bit and think I've found the problem: DSpace isn't recognizing the Admin users I'm creating. As per the install instructions, I'm using the command prompt C:\dspace\bin\dsrun org.dspace.administer.CreateAdministrator to try and create an admin account. I get prompted for name, email, and password, then get a bunch of scrolling code that I can't decipher but which makes it look like it works. I then restart (just in case something needs to reset), but DSpace still tells me it doesn't recognize the email address or account. I've tried with multiple names and email addresses, but get the same result. Any ideas? Many thanks for all your patience as I wrestle with DSpace, Sincerely, Paul Jordan Digital Archivist Occidental College - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Can't log onto admin - follow up
Paul, Can you post some of the scrolling code that you see when trying to create the administrator? I think this will help us to figure out what the problem is - the CreateAdministrator command is somewhat quiet when it runs normally. -- Keith Paul Jordan wrote: Thanks for the support, I didn't realize that the proper url was .../dspace/dspace-admin. I'm still having connection issues, but I've played around with it a bit and think I've found the problem: DSpace isn't recognizing the Admin users I'm creating. As per the install instructions, I'm using the command prompt C:\dspace\bin\dsrun org.dspace.administer.CreateAdministrator to try and create an admin account. I get prompted for name, email, and password, then get a bunch of scrolling code that I can't decipher but which makes it look like it works. I then restart (just in case something needs to reset), but DSpace still tells me it doesn't recognize the email address or account. I've tried with multiple names and email addresses, but get the same result. Any ideas? Many thanks for all your patience as I wrestle with DSpace, Sincerely, Paul Jordan Digital Archivist Occidental College - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Can't log onto Admin - Follow Up
You are using PostgreSQL 8.3 which introduces a more rigid type casting between characters and integers. I suggest you install PostgreSQL 8.2 ! Have a nice day! Christophe Paul Jordan a écrit : Certainly. Here is the complete sequence. Sincerely, Paul Jordan C:\Program Files\PostgreSQL\8.3\binc:\dspace\bin\dsrun org.dspace.administer.Cr eateAdministrator Using DSpace installation in: C:\dspace Creating an initial administrator account E-mail address: [EMAIL PROTECTED] First name: Paul Last name: Jordan WARNING: Password will appear on-screen. Password: dspace Again to confirm: dspace Is the above data correct? (y or n): y Exception occurred:org.postgresql.util.PSQLException: ERROR: operator does not e xist: integer = character varying org.postgresql.util.PSQLException: ERROR: operator does not exist: integer = cha racter varying at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx ecutorImpl.java:1592) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor Impl.java:1327) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja va:192) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat ement.java:451) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract Jdbc2Statement.java:350) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc 2Statement.java:254) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Dele gatingPreparedStatement.java:92) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Dele gatingPreparedStatement.java:92) at org.dspace.storage.rdbms.DatabaseManager.queryTable(DatabaseManager.j ava:159) at org.dspace.storage.rdbms.DatabaseManager.querySingleTable(DatabaseMan ager.java:447) at org.dspace.storage.rdbms.DatabaseManager.querySingleTable(DatabaseMan ager.java:465) at org.dspace.storage.rdbms.DatabaseManager.findByUnique(DatabaseManager .java:647) at org.dspace.storage.rdbms.DatabaseManager.find(DatabaseManager.java:61 2) at org.dspace.eperson.Group.find(Group.java:635) at org.dspace.administer.CreateAdministrator.main(CreateAdministrator.ja va:142) -- Message: 5 Date: Tue, 03 Jun 2008 11:41:45 -0400 From: Keith Gilbertson [EMAIL PROTECTED] Subject: Re: [Dspace-tech] Can't log onto admin - follow up To: Paul Jordan [EMAIL PROTECTED] Cc: dspace-tech@lists.sourceforge.net Message-ID: [EMAIL PROTECTED] Content-Type: text/plain; charset=UTF-8; format=flowed Paul, Can you post some of the scrolling code that you see when trying to create the administrator? I think this will help us to figure out what the problem is - the CreateAdministrator command is somewhat quiet when it runs normally. begin:vcard fn:Christophe Dupriez n:Dupriez;Christophe org:DESTIN inc. SSEB adr;quoted-printable:;;rue des Palais 44, bo=C3=AEte 1;Bruxelles;;B-1030;Belgique email;internet:[EMAIL PROTECTED] title:Informaticien tel;work:+32/2/216.66.15 tel;fax:+32/2/242.97.25 tel;cell:+32/475.77.62.11 note;quoted-printable:D=C3=A9veloppement de Syst=C3=A8mes de Traitement de l'Information x-mozilla-html:TRUE url:http://www.destin.be version:2.1 end:vcard - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Can't log onto Admin - Follow Up
Ah, I see. Yep, that's the same problem I've been encountering. Good to know it's not unique. Regarding DSpace 1.5, the install directions I've been able to find (from the DSpace website) are for 1.4.2 and include things that aren't in 1.5, specifically some of the file paths are differen't/aren't there. Would any of that make a difference? If not, I'll install DSpace 1.5. Otherwise, I'll pull postgres down to 8.2. Thanks, Paul -Original Message- From: Keith Gilbertson [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2008 9:25 AM To: Paul Jordan Cc: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Can't log onto Admin - Follow Up Paul, There are some problems with DSpace 1.4.2 and Postgres 8.3. There are threads about that here: http://www.nabble.com/Error-with-DSpace-administrator%27s-account-td1599 4473.html#a16005789 and here: http://www.nabble.com/-Fwd%3A-Re%3A-Error-with-DSpace-administrator%27s- account--td16008564.html#a16008564 Does anyone out there know if this has been fixed with DSpace 1.5? Paul, if that's the case, would you be able to use DSpace 1.5? Paul Jordan wrote: Certainly. Here is the complete sequence. Sincerely, Paul Jordan C:\Program Files\PostgreSQL\8.3\binc:\dspace\bin\dsrun org.dspace.administer.Cr eateAdministrator Using DSpace installation in: C:\dspace Creating an initial administrator account E-mail address: [EMAIL PROTECTED] First name: Paul Last name: Jordan WARNING: Password will appear on-screen. Password: dspace Again to confirm: dspace Is the above data correct? (y or n): y Exception occurred:org.postgresql.util.PSQLException: ERROR: operator does not e xist: integer = character varying org.postgresql.util.PSQLException: ERROR: operator does not exist: integer = cha racter varying at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx ecutorImpl.java:1592) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor Impl.java:1327) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja va:192) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat ement.java:451) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract Jdbc2Statement.java:350) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc 2Statement.java:254) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Dele gatingPreparedStatement.java:92) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Dele gatingPreparedStatement.java:92) at org.dspace.storage.rdbms.DatabaseManager.queryTable(DatabaseManager.j ava:159) at org.dspace.storage.rdbms.DatabaseManager.querySingleTable(DatabaseMan ager.java:447) at org.dspace.storage.rdbms.DatabaseManager.querySingleTable(DatabaseMan ager.java:465) at org.dspace.storage.rdbms.DatabaseManager.findByUnique(DatabaseManager .java:647) at org.dspace.storage.rdbms.DatabaseManager.find(DatabaseManager.java:61 2) at org.dspace.eperson.Group.find(Group.java:635) at org.dspace.administer.CreateAdministrator.main(CreateAdministrator.ja va:142) -- Message: 5 Date: Tue, 03 Jun 2008 11:41:45 -0400 From: Keith Gilbertson [EMAIL PROTECTED] Subject: Re: [Dspace-tech] Can't log onto admin - follow up To: Paul Jordan [EMAIL PROTECTED] Cc: dspace-tech@lists.sourceforge.net Message-ID: [EMAIL PROTECTED] Content-Type: text/plain; charset=UTF-8; format=flowed Paul, Can you post some of the scrolling code that you see when trying to create the administrator? I think this will help us to figure out what the problem is - the CreateAdministrator command is somewhat quiet when it runs normally. - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Can't log onto Admin - Follow Up
Paul, There are some problems with DSpace 1.4.2 and Postgres 8.3. There are threads about that here: http://www.nabble.com/Error-with-DSpace-administrator%27s-account-td15994473.html#a16005789 and here: http://www.nabble.com/-Fwd%3A-Re%3A-Error-with-DSpace-administrator%27s-account--td16008564.html#a16008564 Does anyone out there know if this has been fixed with DSpace 1.5? Paul, if that's the case, would you be able to use DSpace 1.5? Paul Jordan wrote: Certainly. Here is the complete sequence. Sincerely, Paul Jordan C:\Program Files\PostgreSQL\8.3\binc:\dspace\bin\dsrun org.dspace.administer.Cr eateAdministrator Using DSpace installation in: C:\dspace Creating an initial administrator account E-mail address: [EMAIL PROTECTED] First name: Paul Last name: Jordan WARNING: Password will appear on-screen. Password: dspace Again to confirm: dspace Is the above data correct? (y or n): y Exception occurred:org.postgresql.util.PSQLException: ERROR: operator does not e xist: integer = character varying org.postgresql.util.PSQLException: ERROR: operator does not exist: integer = cha racter varying at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx ecutorImpl.java:1592) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor Impl.java:1327) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja va:192) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat ement.java:451) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract Jdbc2Statement.java:350) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc 2Statement.java:254) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Dele gatingPreparedStatement.java:92) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Dele gatingPreparedStatement.java:92) at org.dspace.storage.rdbms.DatabaseManager.queryTable(DatabaseManager.j ava:159) at org.dspace.storage.rdbms.DatabaseManager.querySingleTable(DatabaseMan ager.java:447) at org.dspace.storage.rdbms.DatabaseManager.querySingleTable(DatabaseMan ager.java:465) at org.dspace.storage.rdbms.DatabaseManager.findByUnique(DatabaseManager .java:647) at org.dspace.storage.rdbms.DatabaseManager.find(DatabaseManager.java:61 2) at org.dspace.eperson.Group.find(Group.java:635) at org.dspace.administer.CreateAdministrator.main(CreateAdministrator.ja va:142) -- Message: 5 Date: Tue, 03 Jun 2008 11:41:45 -0400 From: Keith Gilbertson [EMAIL PROTECTED] Subject: Re: [Dspace-tech] Can't log onto admin - follow up To: Paul Jordan [EMAIL PROTECTED] Cc: dspace-tech@lists.sourceforge.net Message-ID: [EMAIL PROTECTED] Content-Type: text/plain; charset=UTF-8; format=flowed Paul, Can you post some of the scrolling code that you see when trying to create the administrator? I think this will help us to figure out what the problem is - the CreateAdministrator command is somewhat quiet when it runs normally. - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Can't log onto Admin - Follow Up
The install instructions for 1.5 are quite different from the instructions from 1.4.2. The DSpace website may not have been updated yet, but the new install directions are included with the 1.5 download. I can't see if this problem has been fixed with the 1.5 version of DSpace, so you might have the right idea in pulling postgres down to 8.2 until we know. -- keith Paul Jordan wrote: Ah, I see. Yep, that's the same problem I've been encountering. Good to know it's not unique. Regarding DSpace 1.5, the install directions I've been able to find (from the DSpace website) are for 1.4.2 and include things that aren't in 1.5, specifically some of the file paths are differen't/aren't there. Would any of that make a difference? If not, I'll install DSpace 1.5. Otherwise, I'll pull postgres down to 8.2. Thanks, Paul -Original Message- From: Keith Gilbertson [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2008 9:25 AM To: Paul Jordan Cc: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Can't log onto Admin - Follow Up Paul, There are some problems with DSpace 1.4.2 and Postgres 8.3. There are threads about that here: http://www.nabble.com/Error-with-DSpace-administrator%27s-account-td1599 4473.html#a16005789 and here: http://www.nabble.com/-Fwd%3A-Re%3A-Error-with-DSpace-administrator%27s- account--td16008564.html#a16008564 Does anyone out there know if this has been fixed with DSpace 1.5? Paul, if that's the case, would you be able to use DSpace 1.5? Paul Jordan wrote: Certainly. Here is the complete sequence. Sincerely, Paul Jordan C:\Program Files\PostgreSQL\8.3\binc:\dspace\bin\dsrun org.dspace.administer.Cr eateAdministrator Using DSpace installation in: C:\dspace Creating an initial administrator account E-mail address: [EMAIL PROTECTED] First name: Paul Last name: Jordan WARNING: Password will appear on-screen. Password: dspace Again to confirm: dspace Is the above data correct? (y or n): y Exception occurred:org.postgresql.util.PSQLException: ERROR: operator does not e xist: integer = character varying org.postgresql.util.PSQLException: ERROR: operator does not exist: integer = cha racter varying at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx ecutorImpl.java:1592) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor Impl.java:1327) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja va:192) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat ement.java:451) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract Jdbc2Statement.java:350) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc 2Statement.java:254) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Dele gatingPreparedStatement.java:92) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Dele gatingPreparedStatement.java:92) at org.dspace.storage.rdbms.DatabaseManager.queryTable(DatabaseManager.j ava:159) at org.dspace.storage.rdbms.DatabaseManager.querySingleTable(DatabaseMan ager.java:447) at org.dspace.storage.rdbms.DatabaseManager.querySingleTable(DatabaseMan ager.java:465) at org.dspace.storage.rdbms.DatabaseManager.findByUnique(DatabaseManager .java:647) at org.dspace.storage.rdbms.DatabaseManager.find(DatabaseManager.java:61 2) at org.dspace.eperson.Group.find(Group.java:635) at org.dspace.administer.CreateAdministrator.main(CreateAdministrator.ja va:142) -- Message: 5 Date: Tue, 03 Jun 2008 11:41:45 -0400 From: Keith Gilbertson [EMAIL PROTECTED] Subject: Re: [Dspace-tech] Can't log onto admin - follow up To: Paul Jordan [EMAIL PROTECTED] Cc: dspace-tech@lists.sourceforge.net Message-ID: [EMAIL PROTECTED] Content-Type: text/plain; charset=UTF-8; format=flowed Paul, Can you post some of the scrolling code that you see when trying to create the administrator? I think this will help us to figure out what the problem is - the CreateAdministrator command is somewhat quiet when it runs normally. - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
