--- Michael Bell <[EMAIL PROTECTED]>
escribi�: > Hi Johnny,
>
> the used database module can be checked in the
> configuration. There is a
> switch DBmodule. DB means DBM files. DBI means SQL
> database.
>
> The tables are:
>
> certificate
> ca_certificate
> request
> crl
> crr
> log (I think this table is present in 0.9.1 but I'm
> not sure)
>
> select * from ca_certificate;
>
> Michael
> --
Hello Michael.
It's a reality that my OpenCA isn't using postgres as
a database, because after executing the postgres
commando to show tables, shows me that my database
hasn't tables. Then my question is: Why My OpenCA
isn't using postgres as I tell it to use in the
configuration? Maybe I did something wrong? Can Anyone
help me on this?
I'm appending (again) all I did to get OpenCA
installed in my machine.
Next it is my first message asking about My problem
with database:
I have OpenCA-0.9.1.8, both interfaces (offline and
online) in the same machine, I installed OpenCA using
this configure command:
./configure --with-openca-user=openca
--with-openca-group=openca
--with-htdocs-fs-prefix=/var/www/html
--with-openssl-prefix=/usr --with-web-host=localhost
--with-cgi-fs-prefix=/var/www/cgi-bin
--with-httpd-user=48 --with-httpd-group=48
--with-hierarchy-level=ra
--with-ca-organization=Ubiquando --with-ca-country=co
[EMAIL PROTECTED]
--enable-send-mail-automatic --disable-db --enable-dbi
--with-db-type=Pg --with-db-name=openca
--with-db-port=localhost --with-db-port=5432
--with-db-user=openca --with-db-passwd=ubiquando
then I installed using the normal commands:
make
make install-ra
make install-node
make install-pub
make install-ldap
then I did this:
make clean
./configure --with-openca-user=openca
--with-openca-group=openca
--with-htdocs-fs-prefix=/var/www/html
--with-openssl-prefix=/usr --with-web-host=localhost
--with-cgi-fs-prefix=/var/www/cgi-bin
--with-httpd-user=48 --with-httpd-group=48
--with-hierarchy-level=ca
--with-ca-organization=Ubiquando --with-ca-country=co
[EMAIL PROTECTED]
--enable-send-mail-automatic --disable-db --enable-dbi
--with-db-type=Pg --with-db-name=openca
--with-db-port=localhost --with-db-port=5432
--with-db-user=openca --with-db-passwd=ubiquando
make install-ca
make install-node
After all this stuff, I went to the CA interface and I
initialised perfectly my CA, the I went to RA
interface and did.
Server Management -> Server Init -> Initialize
Database
and everything good.
I can Request certificates, Sign requests, Issue
Certificates, But I wanted to see the data in my
database making a connection to the OpenCA database
using these commands since a terminal:
# su - openca
$ psql openca
Welcome to psql 7.4.3, the PostgreSQL interactive
terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit
openca=> \dt
and the output for the last command (\dt) is this one:
No relations found.
This is the commando for show tables in a database.
But it tells me there aren't tables in the database.
Maybe should I use different names for the database in
RA and in CA. As you can see in my configuration, I
used the same name for both interfaces.
______________________________________________
Renovamos el Correo Yahoo!: �100 MB GRATIS!
Nuevos servicios, m�s seguridad
http://correo.yahoo.es
-------------------------------------------------------
This SF.Net email sponsored by Black Hat Briefings & Training.
Attend Black Hat Briefings & Training, Las Vegas July 24-29 -
digital self defense, top technical experts, no vendor pitches,
unmatched networking opportunities. Visit www.blackhat.com
_______________________________________________
Openca-Users mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/openca-users
