Re: [quadstor-vtl] Rocky 8 upgrade to 3.0.78-1 import DB error

2023-08-23 Thread Craig K 

That worked!   It installed without errors.  Thank you very much for 
helping me so quickly.

On Wednesday, August 23, 2023 at 1:19:50 PM UTC-5 quadstor wrote:

> Hi,
>
> Please uninstall the package
> rpm -e `rpm -qa | grep quadstor-vtl-ext`
>
> Then remove /quadstorvtl/pgsqlsys/ directory
> rm -rf /quadstorvtl/pgsqlsys/
> rm /tmp/qstor*.log
>
> Reinstall 3.0.78.1 and then send to us
> /tmp/qstor*.log files
> /var/log/audit.log
>
> Please then manually start the database
> /quadstorvtl/pgsqlsys/etc/pgsql start
>
> Then send to us the output of the following command
> ls -l /var/run/ | grep postgresql
> ls -l /var/run/postgresql/
>
> Also please send
> /quadstorvtl/pgsqlsys/pg.log if it exists
>
>
>
> On Wed, Aug 23, 2023 at 11:49 PM Craig K  wrote:
>
>> I was able to reinstall quadstor-vtl-ext-3.0.76.1-rhel.x86_64.rpm and get 
>> the system back up and running.  But I would still like to upgrade to the 
>> latest version.
>>
>> On Wednesday, August 23, 2023 at 12:57:54 PM UTC-5 Craig K wrote:
>>
>>> #cat /quadstorvtl/pgsqlsys/data/import.log
>>> psql: could not connect to server: No such file or directory
>>> Is the server running locally and accepting
>>> connections on Unix domain socket 
>>> "/var/run/postgresql/.s.PGSQL.9985"?
>>>
>>> On Wednesday, August 23, 2023 at 12:35:04 PM UTC-5 quadstor wrote:
>>>
 Hi,

 There would be a /quadstorvtl/pgsqlsys/data/import.log. Please send 
 that file.
 Please also send /tmp/qstorpgdb.log and qstorpgdbpatch.log



 On Wed, Aug 23, 2023 at 11:03 PM Craig K  wrote:

> uninstalled 3.0.76-1 and tried to install 3.0.78-1
>
> # rpm -ivh quadstor-vtl-ext-3.0.78.1-rhel.x86_64.rpm
> Verifying... 
>  # [100%]
> Preparing... 
>  # [100%]
> usermod -G vtprocgrp apache > /dev/null 2>&1
> Updating / installing...
>1:quadstor-vtl-ext-3.0.78.1-rhel   
> # [100%]
> Performing post install. Please wait...
> Reading old database from /quadstorvtl/pgsql/data
> pg_ctl: directory "/quadstorvtl/pgsqlsys/data" is not a database 
> cluster directory
> Importing old database to /quadstorvtl/pgsqlsys/data
> pg_ctl: directory "/quadstorvtl/pgsqlsys/data" is not a database 
> cluster directory
> ERROR: Cannot import old database!!!
> warning: %post(quadstor-vtl-ext-3.0.78.1-rhel.x86_64) scriptlet 
> failed, exit status 1
>
> -- 
> You received this message because you are subscribed to the Google 
> Groups "QUADStor VTL" group.
> To unsubscribe from this group and stop receiving emails from it, send 
> an email to quadstor-vtl...@googlegroups.com.
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/quadstor-vtl/02b0354b-6bf0-43f6-a1d4-cf9fa9e6e2b7n%40googlegroups.com
>  
> 
> .
>
 -- 
>> You received this message because you are subscribed to the Google Groups 
>> "QUADStor VTL" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to quadstor-vtl...@googlegroups.com.
>>
> To view this discussion on the web visit 
>> https://groups.google.com/d/msgid/quadstor-vtl/e98822d9-76ef-467b-bc61-d5a10a22acedn%40googlegroups.com
>>  
>> 
>> .
>>
>

-- 
You received this message because you are subscribed to the Google Groups 
"QUADStor VTL" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to quadstor-vtl+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/quadstor-vtl/d2729f4d-ae55-4198-8338-748e3430c6a2n%40googlegroups.com.

Re: [quadstor-vtl] Rocky 8 upgrade to 3.0.78-1 import DB error

2023-08-23 Thread QUADStor VTL Support 
Hi,

Please uninstall the package
rpm -e `rpm -qa | grep quadstor-vtl-ext`

Then remove /quadstorvtl/pgsqlsys/ directory
rm -rf /quadstorvtl/pgsqlsys/
rm /tmp/qstor*.log

Reinstall 3.0.78.1 and then send to us
/tmp/qstor*.log files
/var/log/audit.log

Please then manually start the database
/quadstorvtl/pgsqlsys/etc/pgsql start

Then send to us the output of the following command
ls -l /var/run/ | grep postgresql
ls -l /var/run/postgresql/

Also please send
/quadstorvtl/pgsqlsys/pg.log if it exists



On Wed, Aug 23, 2023 at 11:49 PM Craig K  wrote:

> I was able to reinstall quadstor-vtl-ext-3.0.76.1-rhel.x86_64.rpm and get
> the system back up and running.  But I would still like to upgrade to the
> latest version.
>
> On Wednesday, August 23, 2023 at 12:57:54 PM UTC-5 Craig K wrote:
>
>> #cat /quadstorvtl/pgsqlsys/data/import.log
>> psql: could not connect to server: No such file or directory
>> Is the server running locally and accepting
>> connections on Unix domain socket
>> "/var/run/postgresql/.s.PGSQL.9985"?
>>
>> On Wednesday, August 23, 2023 at 12:35:04 PM UTC-5 quadstor wrote:
>>
>>> Hi,
>>>
>>> There would be a /quadstorvtl/pgsqlsys/data/import.log. Please send that
>>> file.
>>> Please also send /tmp/qstorpgdb.log and qstorpgdbpatch.log
>>>
>>>
>>>
>>> On Wed, Aug 23, 2023 at 11:03 PM Craig K  wrote:
>>>
 uninstalled 3.0.76-1 and tried to install 3.0.78-1

 # rpm -ivh quadstor-vtl-ext-3.0.78.1-rhel.x86_64.rpm
 Verifying...  #
 [100%]
 Preparing...  #
 [100%]
 usermod -G vtprocgrp apache > /dev/null 2>&1
 Updating / installing...
1:quadstor-vtl-ext-3.0.78.1-rhel   #
 [100%]
 Performing post install. Please wait...
 Reading old database from /quadstorvtl/pgsql/data
 pg_ctl: directory "/quadstorvtl/pgsqlsys/data" is not a database
 cluster directory
 Importing old database to /quadstorvtl/pgsqlsys/data
 pg_ctl: directory "/quadstorvtl/pgsqlsys/data" is not a database
 cluster directory
 ERROR: Cannot import old database!!!
 warning: %post(quadstor-vtl-ext-3.0.78.1-rhel.x86_64) scriptlet failed,
 exit status 1

 --
 You received this message because you are subscribed to the Google
 Groups "QUADStor VTL" group.
 To unsubscribe from this group and stop receiving emails from it, send
 an email to quadstor-vtl...@googlegroups.com.
 To view this discussion on the web visit
 https://groups.google.com/d/msgid/quadstor-vtl/02b0354b-6bf0-43f6-a1d4-cf9fa9e6e2b7n%40googlegroups.com
 
 .

>>> --
> You received this message because you are subscribed to the Google Groups
> "QUADStor VTL" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to quadstor-vtl+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/quadstor-vtl/e98822d9-76ef-467b-bc61-d5a10a22acedn%40googlegroups.com
> 
> .
>

-- 
You received this message because you are subscribed to the Google Groups 
"QUADStor VTL" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to quadstor-vtl+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/quadstor-vtl/CAPEgkt40%3DNj8fwjj1VA6M9x-oys1d56oWSfubUOP%3DL5H0SVHxQ%40mail.gmail.com.

Re: [quadstor-vtl] Rocky 8 upgrade to 3.0.78-1 import DB error

2023-08-23 Thread Craig K 
I was able to reinstall quadstor-vtl-ext-3.0.76.1-rhel.x86_64.rpm and get 
the system back up and running.  But I would still like to upgrade to the 
latest version.

On Wednesday, August 23, 2023 at 12:57:54 PM UTC-5 Craig K wrote:

> #cat /quadstorvtl/pgsqlsys/data/import.log
> psql: could not connect to server: No such file or directory
> Is the server running locally and accepting
> connections on Unix domain socket 
> "/var/run/postgresql/.s.PGSQL.9985"?
>
> On Wednesday, August 23, 2023 at 12:35:04 PM UTC-5 quadstor wrote:
>
>> Hi,
>>
>> There would be a /quadstorvtl/pgsqlsys/data/import.log. Please send that 
>> file.
>> Please also send /tmp/qstorpgdb.log and qstorpgdbpatch.log
>>
>>
>>
>> On Wed, Aug 23, 2023 at 11:03 PM Craig K  wrote:
>>
>>> uninstalled 3.0.76-1 and tried to install 3.0.78-1
>>>
>>> # rpm -ivh quadstor-vtl-ext-3.0.78.1-rhel.x86_64.rpm
>>> Verifying...  # 
>>> [100%]
>>> Preparing...  # 
>>> [100%]
>>> usermod -G vtprocgrp apache > /dev/null 2>&1
>>> Updating / installing...
>>>1:quadstor-vtl-ext-3.0.78.1-rhel   # 
>>> [100%]
>>> Performing post install. Please wait...
>>> Reading old database from /quadstorvtl/pgsql/data
>>> pg_ctl: directory "/quadstorvtl/pgsqlsys/data" is not a database cluster 
>>> directory
>>> Importing old database to /quadstorvtl/pgsqlsys/data
>>> pg_ctl: directory "/quadstorvtl/pgsqlsys/data" is not a database cluster 
>>> directory
>>> ERROR: Cannot import old database!!!
>>> warning: %post(quadstor-vtl-ext-3.0.78.1-rhel.x86_64) scriptlet failed, 
>>> exit status 1
>>>
>>> -- 
>>> You received this message because you are subscribed to the Google 
>>> Groups "QUADStor VTL" group.
>>> To unsubscribe from this group and stop receiving emails from it, send 
>>> an email to quadstor-vtl...@googlegroups.com.
>>> To view this discussion on the web visit 
>>> https://groups.google.com/d/msgid/quadstor-vtl/02b0354b-6bf0-43f6-a1d4-cf9fa9e6e2b7n%40googlegroups.com
>>>  
>>> 
>>> .
>>>
>>

-- 
You received this message because you are subscribed to the Google Groups 
"QUADStor VTL" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to quadstor-vtl+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/quadstor-vtl/e98822d9-76ef-467b-bc61-d5a10a22acedn%40googlegroups.com.

Re: [quadstor-vtl] Rocky 8 upgrade to 3.0.78-1 import DB error

2023-08-23 Thread Craig K 
#cat /quadstorvtl/pgsqlsys/data/import.log
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket 
"/var/run/postgresql/.s.PGSQL.9985"?

On Wednesday, August 23, 2023 at 12:35:04 PM UTC-5 quadstor wrote:

> Hi,
>
> There would be a /quadstorvtl/pgsqlsys/data/import.log. Please send that 
> file.
> Please also send /tmp/qstorpgdb.log and qstorpgdbpatch.log
>
>
>
> On Wed, Aug 23, 2023 at 11:03 PM Craig K  wrote:
>
>> uninstalled 3.0.76-1 and tried to install 3.0.78-1
>>
>> # rpm -ivh quadstor-vtl-ext-3.0.78.1-rhel.x86_64.rpm
>> Verifying...  # 
>> [100%]
>> Preparing...  # 
>> [100%]
>> usermod -G vtprocgrp apache > /dev/null 2>&1
>> Updating / installing...
>>1:quadstor-vtl-ext-3.0.78.1-rhel   # 
>> [100%]
>> Performing post install. Please wait...
>> Reading old database from /quadstorvtl/pgsql/data
>> pg_ctl: directory "/quadstorvtl/pgsqlsys/data" is not a database cluster 
>> directory
>> Importing old database to /quadstorvtl/pgsqlsys/data
>> pg_ctl: directory "/quadstorvtl/pgsqlsys/data" is not a database cluster 
>> directory
>> ERROR: Cannot import old database!!!
>> warning: %post(quadstor-vtl-ext-3.0.78.1-rhel.x86_64) scriptlet failed, 
>> exit status 1
>>
>> -- 
>> You received this message because you are subscribed to the Google Groups 
>> "QUADStor VTL" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to quadstor-vtl...@googlegroups.com.
>> To view this discussion on the web visit 
>> https://groups.google.com/d/msgid/quadstor-vtl/02b0354b-6bf0-43f6-a1d4-cf9fa9e6e2b7n%40googlegroups.com
>>  
>> 
>> .
>>
>

-- 
You received this message because you are subscribed to the Google Groups 
"QUADStor VTL" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to quadstor-vtl+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/quadstor-vtl/106c31b3-f3ff-4e1c-b89d-1b68a9e07378n%40googlegroups.com.
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.9985"?
The files belonging to this database system will be owned by user "vtdbuser".
This user must also own the server process.

The database cluster will be initialized with locale en_US.UTF-8.
The default database encoding has accordingly been set to UTF8.
The default text search configuration will be set to "english".

fixing permissions on existing directory /quadstorvtl/pgsql/data ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 32MB
creating configuration files ... ok
creating template1 database in /quadstorvtl/pgsql/data/base/1 ... ok
initializing pg_authid ... ok
initializing dependencies ... ok
creating system views ... ok
loading system objects' descriptions ... ok
creating conversions ... ok
creating dictionaries ... ok
setting privileges on built-in objects ... ok
creating information schema ... ok
vacuuming database template1 ... ok
copying template1 to template0 ... ok
copying template1 to postgres ... ok

WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the -A option the
next time you run initdb.

Success. You can now start the database server using:

bin/postgres -D /quadstorvtl/pgsql/data
or
bin/pg_ctl -D /quadstorvtl/pgsql/data -l logfile start

waiting for server to start done
server started
psql:/quadstorvtl/pgsql/share/qsdb.sql:11: NOTICE:  CREATE TABLE / PRIMARY KEY 
will create implicit index "vtls_pkey" for table "vtls"
CREATE TABLE
psql:/quadstorvtl/pgsql/share/qsdb.sql:27: NOTICE:  CREATE TABLE will create 
implicit sequence "physstor_bid_seq" for serial column "physstor.bid"
psql:/quadstorvtl/pgsql/share/qsdb.sql:27: NOTICE:  CREATE TABLE / PRIMARY KEY 
will create implicit index "physstor_pkey" for table "physstor"
CREATE TABLE
ALTER SEQUENCE
psql:/quadstorvtl/pgsql/share/qsdb.sql:42: NOTICE:  CREATE TABLE will create 
implicit sequence "vcartridge_tapeid_seq" for serial column "vcartridge.tapeid"
psql:/quadstorvtl/pgsql/share/qsdb.sql:42: NOTICE:  CREATE TABLE / UNIQUE will 
create implicit index "vcartridge_tapeid_key" for table "vcartridge"
CREATE TABLE
ALTER SEQUENCE
CREATE TABLE
CREATE TABLE
CREATE TABLE
psql:/quadstorvtl/pgsql/share/qsdb.sql:80: NOTICE:  CREATE TABLE will create 
implicit sequence "storagegroup_groupid_seq" for serial column 
"storagegroup.groupid"
psql:/quadstorvtl/pgsql/share/qsdb.sql:80: NOTICE:  CREATE TABLE / UNIQUE will

Re: [quadstor-vtl] Rocky 8 upgrade to 3.0.78-1 import DB error

2023-08-23 Thread QUADStor VTL Support 
Hi,

There would be a /quadstorvtl/pgsqlsys/data/import.log. Please send that
file.
Please also send /tmp/qstorpgdb.log and qstorpgdbpatch.log



On Wed, Aug 23, 2023 at 11:03 PM Craig K  wrote:

> uninstalled 3.0.76-1 and tried to install 3.0.78-1
>
> # rpm -ivh quadstor-vtl-ext-3.0.78.1-rhel.x86_64.rpm
> Verifying...  #
> [100%]
> Preparing...  #
> [100%]
> usermod -G vtprocgrp apache > /dev/null 2>&1
> Updating / installing...
>1:quadstor-vtl-ext-3.0.78.1-rhel   #
> [100%]
> Performing post install. Please wait...
> Reading old database from /quadstorvtl/pgsql/data
> pg_ctl: directory "/quadstorvtl/pgsqlsys/data" is not a database cluster
> directory
> Importing old database to /quadstorvtl/pgsqlsys/data
> pg_ctl: directory "/quadstorvtl/pgsqlsys/data" is not a database cluster
> directory
> ERROR: Cannot import old database!!!
> warning: %post(quadstor-vtl-ext-3.0.78.1-rhel.x86_64) scriptlet failed,
> exit status 1
>
> --
> You received this message because you are subscribed to the Google Groups
> "QUADStor VTL" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to quadstor-vtl+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/quadstor-vtl/02b0354b-6bf0-43f6-a1d4-cf9fa9e6e2b7n%40googlegroups.com
> 
> .
>

-- 
You received this message because you are subscribed to the Google Groups 
"QUADStor VTL" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to quadstor-vtl+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/quadstor-vtl/CAPEgkt5og8LdkWyJecMSt%3DNf_kAOWw1skTxYbgEkGsnUH47Y3A%40mail.gmail.com.

[quadstor-vtl] Rocky 8 upgrade to 3.0.78-1 import DB error

2023-08-23 Thread Craig K 
uninstalled 3.0.76-1 and tried to install 3.0.78-1

# rpm -ivh quadstor-vtl-ext-3.0.78.1-rhel.x86_64.rpm
Verifying...  # 
[100%]
Preparing...  # 
[100%]
usermod -G vtprocgrp apache > /dev/null 2>&1
Updating / installing...
   1:quadstor-vtl-ext-3.0.78.1-rhel   # 
[100%]
Performing post install. Please wait...
Reading old database from /quadstorvtl/pgsql/data
pg_ctl: directory "/quadstorvtl/pgsqlsys/data" is not a database cluster 
directory
Importing old database to /quadstorvtl/pgsqlsys/data
pg_ctl: directory "/quadstorvtl/pgsqlsys/data" is not a database cluster 
directory
ERROR: Cannot import old database!!!
warning: %post(quadstor-vtl-ext-3.0.78.1-rhel.x86_64) scriptlet failed, 
exit status 1

-- 
You received this message because you are subscribed to the Google Groups 
"QUADStor VTL" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to quadstor-vtl+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/quadstor-vtl/02b0354b-6bf0-43f6-a1d4-cf9fa9e6e2b7n%40googlegroups.com.