Questions tagged [database-administration]

Questions about how to install, configure or tune the configuration of any database package.

Filter by
Sorted by
Tagged with
0
votes
0answers
48 views

mariaDB service no longer works after upgrading from SuSE Linux Enterprise 12.1 to 12.3

I recently did an upgrade on a virtual machine running SuSE Linux Enterprise 12SP1 to SuSE Linux Enterprise 12SP3. On this server, I run an Apache server serving a Drupal Site, as well as a MariaDB ...
1
vote
3answers
3k views

How to downgrade MS SQL Server 2019 Enterprise (evaluation) to Standard (purchased)?

SQL Server 2019 was installed in evaluation edition. When entering the activation code for a purchased copy of Standard edition I received the following message: I entered the activation code that is ...
0
votes
1answer
246 views

Physical to Virtual Migration using Disk2vhd utility

We are currently in plan of migrating physical to virtual servers for both DB & App servers. Currently we are with SQL Server 2014 AOAG System. Databases are FileStream enabled. Currently we have ...
0
votes
1answer
53 views

MDSplus configuration: How to Change the Start Shot Number in an MDSplus tree?

When creating a new MDSplus tree, it's possible (or perhaps even required) to specify the smallest shot number for which data can be stored in the tree. Shot numbers are just index values identifying ...
1
vote
1answer
113 views

Database Reverse engineering wizard Fails

I am using Visio 2019, trying to reverse engineer a Azure SQL server. I have successfully created multiple User data sources to use in the wizard using both our DB-admin user and my admin azure ...
0
votes
1answer
103 views

SQL Server file is in Is_media_read_only mode and can't apply TDE as a result

We have a database that we restored to a server and have been read/writing to that database for quite some time. We are now trying to apply TDE to that database and it will not allow us because it ...
0
votes
1answer
262 views

MariaDB slave replication stopped after slave upgrade to 10.1.41

After the recent MariaDB 10.1.41 update which happened on 01/Aug/2019, few of our slaves have stopped syncing relay logs from master which is on 10.1.40. Slaves which got automatically updated to 10.1....
0
votes
1answer
27 views

Link two fields in one table to one field in a second table, and create qry in Access

I am not sure if this is possible to do in Access; I have been googling forums and have not found a solution yet that works... Essentially there are a list of patients who provide multiple blood ...
0
votes
1answer
371 views

MS Access form doesn't reflect recent data updates in Split Database's FrontEnd Forms

I have a front end and a backend to my access database. The VBA code, forms, queries etc are on the frontend and tables on the backend. The backend is on a server, about 5 different users are using ...
1
vote
1answer
3k views

PostgreSQL getting error during pg_restore using pgadmin pg_restore: [archiver (db)] could not execute query: ERROR: role does not exist

I am trying to restore a database from one schema to another schema in PostgreSQL using pgadmin backup and restore utility. The backup is successful for the database A but when I try to do the restore ...
0
votes
0answers
80 views

Can you store encrypted passwords in ConnectWise Manage or will they always be plain text?

Title pretty much says it all. I need to store passwords for devices and configurations but I want them to be stored securely and encrypted. Can this be done with ConnectWise Manage?
1
vote
0answers
72 views

How to connect to a PostgreSQL database?

I have a website written in Python / Django, and it is functioning well on a CentOS server (I wasn't one who set it up though). Now I want to set this website up locally on my Mac OS X or Linux system ...
0
votes
1answer
189 views

postgresql does no restart after changing postgres.conf or pg_hba.conf. This incident happened while i was trying to setup the postgresql BDR

I am not able to login to postgresql after restarting postgresql DB after configuring pg_hba.conf and postgresql.conf file. The snapshot of the error is attached for referral postgresql.conf / pg_hba....
0
votes
1answer
260 views

Removing cluster node from always on cluster

I have an alwaysOn configuration for SqlServer 2012 that is installed in two node windows cluster. We had a disk failure on the second node, and there is no way to recover it, so I should run a new ...
0
votes
1answer
589 views

PostgreSQL 10 does not start after something

I'm handling a strange problem with one installation of PostgreSQL 10.4. One of the databases instances of PostgreSQL have stopped working after 7 months without issues. When this guy saw that the ...
1
vote
0answers
55 views

Talend ETL tutorial [closed]

I need a good tutorial on how to use Talend ETL tool to automatically apply ETL process once new files are added to the directory. eg. (using file watcher). Any useful tutorial on talend is also ...
1
vote
1answer
41 views

What kind of tables would I need for the following person database made in MS Access 2003?

It's a database about actors and movies. I want fill it with their age too, so I can answer the queries: at what age they made their last movie. what is the average age when they made their movies? ...
2
votes
1answer
287 views

Database server for web browser [closed]

What is the most used database server for web browsers such as Chrome, Firefox, Opera, or Safari? Maybe I don't understand web browsers, but I am assuming they must have a database server the same way ...
0
votes
0answers
20 views

Is there a way to Store a Query in View/Procedures?

I wrote an Oracle query and I run it manually from SQL Plus or SQL Developer. It has 2 parameters; start and end date/time. Is there a way to store this query in a view or procedures and run it ...
0
votes
0answers
34 views

Why is the database tab not functional in Crystal Reports 9?

I have a particular report that I can run, it prompts for an Oracle username and password and then generates the report. The Database tab is not fully available. I cannot select Database Expert or set ...
0
votes
1answer
137 views

Automatic update of cells on a second tab when they are merely a copy of the previous tab

I have 2 tabs in excel, part of the information on tab one is to be copied into tab 2. It works ok until I insert a new row into the tab 1 spreadsheet. That change to the cells does not reflect in the ...
1
vote
0answers
56 views

Data security in server at home

I am a beginner linux user, and am planning on provisionally opening a game server on a machine I have at home. In addition to the possible DDoS attacks that may occur on this server (the server will ...
2
votes
1answer
2k views

MySQL: creating a user that can connect from multiple hosts

I'm using MySQL and I need to create an account that can connect from either the localhost or from another server, i.e. 10.1.1.1. So I am doing: CREATE USER 'bob'@'localhost' IDENTIFIED BY '...
2
votes
1answer
267 views

Simulating file corruption on Linux programmatically? (for DB durability testing)

Basically, I want to fwrite() n bytes and have < n bytes be written on the actual disk, or whatever other inconsistency artifacts could arise (like sectors being written out-of-order). I know I ...
0
votes
1answer
2k views

What is the difference between DELTA & TOTAL columns in dba_hist_sqlstat Oracle?

I am using the following query to measure the performance improvement between two views SELECT PARSING_SCHEMA_NAME, SQL_TEXT, OPTIMIZER_COST, FETCHES_TOTAL, FETCHES_DELTA, ...
0
votes
0answers
265 views

Odoo 10 stock transfer under wrong company

The Scenario I am running Odoo 10 Community on a postgresql 9.4 database. I have multiple companies setup, including a parent company and two child companies. A PO was setup incorrectly in the ...
3
votes
4answers
823 views

Why is Hadoop not a Data Warehouse?

What are functional reasons why Hadoop cannot be a Data Warehouse On several sites one can see statements that a Hadoop cluster is not a replacement of a traditional data warehouse. However, I can't ...
0
votes
0answers
51 views

What are the steps involved to share the credentials with multiple applications?

I have 2 scenarios here. app1 and app2 both belong to the same domain app1 and app2 both do not belong to the same domain. For both scenarios, I require the responsibilities of frontend and backend ...
2
votes
2answers
3k views

Horrendous decrease in MySQL Performance after upgrade to Ubuntu 16.04 MySQL 5.7.12

I have a development server that I recently upgraded from 14.04 to 16.04. I have a database 'algebra', which hosts data for my website algebra.com. It is a Q&A website that has Questions and ...
2
votes
2answers
396 views

Which wildcards can I use for a Microsoft Access form asking for month and year?

I made an Access Database that includes dates. I have a Report connected to a query that, when opened, prompts the user for a month in numbers (1-12) in order to produce the report for that months. ...
0
votes
1answer
992 views

how to find out session id of executing ssis package through SP_target

I am executing a ssis Package which contains only one data flow task. Simply SELECT statement in source and Table in destination. I want to find out session id of this running Package in SP_TARGET. I ...
0
votes
1answer
155 views

Back end already in use

We are using an Access Database divided in front end and back end (in a shared folder). I distributed copies of the front end to every user. All users have the shared folder and subfolders added to ...
1
vote
0answers
48 views

Is there any way(e.g. software etc.) where data can be matched visually

I have two columns in excel(see N.B.) that contain as below Column1 Column2 ------- -------- USA India Serbia United States of America Bharat China ...
1
vote
2answers
11k views

Postgres restoring replication, timeline conflict

I have a postgres database (version 9.4) with streaming replication (master, slave configuration). Lets call master db A and slave db B. The server running A failed and we had to do a switchover, ...
0
votes
1answer
244 views

How to give DBA Rights to Domain User Account

How can we give rights / permission to domain managed user account, to manage SQL Databases, typically a DBA Rights? I am on Windows OS.
0
votes
1answer
36 views

SQL 2014 adds null transaction log entries every time a custom service wakes up to look at the database.

SQL2014 on Server2012 (12.0.2000) versus SQL2008R2 (10.50.6000) on Server 2008R2. In SQL2014 but not in SQL2008 .... Both examples add the noted entries to the transaction log once a second (every ...
0
votes
1answer
268 views

Find riak node's listening HTTP and Protobuf port

I recently followed and scripted the Riak 5 minute install, successfully getting 4 nodes running on a Ubuntu 14.04 VM. Currently the nodes are running and are joined / clustered successfully. ...
0
votes
1answer
160 views

MySQL Cluster ndb_restore fails with no error

I have been working to migrate our current single instance database to a new clustered database running MySQL cluster. It is a large database (several billion records) and, while it seems to be ...
-1
votes
1answer
5k views

OSX: Postgresql port 5432 is closed. How to open?

Mac OS X Yosemite (10.10.2) Postgresql 9.4.1 (installed with Homebrew) Snort 2.9.7.0 (installed with Homebrew) I can't connect to psql - port 5432 seem to be closed: $ psql postgres psql: could ...
0
votes
1answer
709 views

Postgresql: can't rename the database

PostgreSQL 9.4.1 (installed with homebrew) I want to rename a database. I'm doing this: $ psql postgres postgres=# ALTER DATABASE snot RENAME TO snortdb postgres-# \l ...
1
vote
2answers
3k views

Is there a tool to put a phone number into E.164 format?

I'm looking for both a quick and dirty, as well as easily repeatable, solution to strip non-numeric data from a column in a spreadsheet for import to a MySQL database. Example: (123)456-7890 fred ...
1
vote
0answers
646 views

check_oracle_health with OPS$Nagios account

I can login to my database via sqlplus with the OPS$ account, but i cannt seem to get it to work in with the nagios check_oracle_health. Im testing from the command line. nagios@servername:/usr/local/...
0
votes
1answer
45 views

Reads vs Writes

Consider a Database which is being constantly accessed (read,write,update,deletions etc) , for instance the Database for some particular airlines. I can understand simultaneous writes/updates can ...
2
votes
1answer
293 views

Microsoft SQL Server Management Studio sometimes Sees but other times Fails to See

My computer has the following Software involved. Microsoft Windows 7 Microsoft SQL Server 2008 R2 Microsoft SQL Server Management Studio Moreover, I have the following Drive partitions: C: drive ...
0
votes
0answers
217 views

importing issue with mysql version to another

I have got an issue with mysql import, I have taken a backup of the mysql version 5.1.32 with the help of command mysqldump -u root -p --routines oneclicksite > oneclick.sql and importing it with ...
0
votes
2answers
2k views

Adminer error (No PHP extension supported (SQLSRV, MSSQL) available

Adminer is a db management tool made in php (http://www.adminer.org/) I've installed it in Linux LAMP but I get the same error I've written in the Question Title. Did anybody solve this? How? I am ...
4
votes
2answers
1k views

Will a query which may take hours to execute keep executing on remote server if I close the connection after executing the command?

If I connect to a remote database server via ssh, start mysql client and execute a query which may take a couple of hours to execute, then close the connection, will the query continue to execute ...
-1
votes
1answer
1k views

Do oracle database servers use a license key?

I installed oracle Linux and oracle database on a test server using the media on the OTN. I noticed that no key was required. My question is this: On a production environment at some point do I have ...
0
votes
2answers
5k views

How do I connect to some local DB server in MS SQL Server 2012? [closed]

I installed MS SQL Server and now want to create some tables and do some queries ... I need to have some local DB Server running to do that right? When I installed SQL Server there was no option to ...
1
vote
1answer
3k views

how do I alter the structure of a table in SugarCRM CE?

How do I add fields to the opportunities table so that they propagate? From within Studio > Opportunities > Fields I added fields. Pardon, I don't understand the next step to effect a change ...