Recover mysql root password on a Mac OS

I start my MAMP, and try to connect to my mysql server via localhost or 127.0.0.1, I tried all the possible password that I thing it is correct, but for some reasons it still didn't like it, so I think I forgot it some how. I need help. Try #1 En...
more »

2017-10-04 14:10 (1) Answers

Reading Oracle htp.p output into Java app

We have built a dynamic stored proc reader due to the nature of our system. The only issue I have left is I am unable to read the htp.p output back into my application after calling the proc. Due to the reader building the proc dynamical from a requ...
more »

2017-10-04 11:10 (0) Answers

Holding sensitive data in database

I need to hold some sensitive passwords in my database that I will have to later use to access another application for my user. How can I do this safely? I'm using Django but any method in general would be hugely appreciated. Thanks for any advice...
more »

2017-10-04 00:10 (0) Answers

Compare multiple values in a single column oracle

I want to compare multiple values of a column with a single value of another column.I had tried a lot but it gives me "No row selected" here's my scenario... I have a table Bus_stop_table: Bus_ID(FK) ------STOP_ID 201 -------------------401 201...
more »

2017-10-03 05:10 (1) Answers

Grouping data by name and date ranges

I have data in my oracle table where I have names and date rages as following: Name From To Lopes, Janine 07-Jun-17 16-Jul-17 Lopes, Janine 17-Jul-17 23-Jul-17 Lopes, Janine 24-Jul-17 31-Aug-17 Baptista,...
more »

2017-10-02 17:10 (2) Answers

php database limit amount of request per minute

So i have this situation where i need to access a database, but this database is actualy used for another app. And the owner has said that i can only have 100 requests to this database per 15 seconds. So i tought of make a rest service which my app c...
more »

2017-09-30 10:09 (0) Answers

Cassandra row cache not reducing query latency

I have a table with partition key + clustering column, and I enabled row caching = 2000. I gave row caching 20GB by changing the yaml file. I can see that my hit rate is ~90% (which is good enough for me), but monitoring shows no latency reduction a...
more »

2017-09-30 09:09 (0) Answers

logging link clicks in WordPress not working

I'm using wordpress functions to add url re-writing rules to my website. someone clicks on a link (such as example.com/flowers) and gets sent to a file on my website which then logs that click in a database and then re-directs them to the site i want...
more »

2017-09-28 15:09 (0) Answers

Issues while fetching from Core Data

I'm facing this really weird issue for the first time in swift. i have 8 values in json. through service i'm parsing that json and saving those values in coreData. all of the 8 values are being saved. but when i fetch the value from that table. it so...
more »

2017-09-25 13:09 (1) Answers

How to create init<dbName>.ora file?

I wanted to create data base. I downloaded Oracle Database 12c and Oracel SQL Devloper. I set environment variable ORACLE_SID using CMD (as administrator). I did the same actions with ORACLE_HOME. Another step was create Windows service. After this s...
more »

2017-09-24 20:09 (1) Answers

Pseudonymization, HMAC & SSN

We've a tiny database that needs to be changed to conform to the new GDPR rules. But I have a few questions surrounding it that I'm hoping to get some clarity on. I'm thinking about separating the data in the existing database into 3 databases, in t...
more »

2017-09-21 11:09 (0) Answers

Separate email messages are being combined

I am trying to send emails using PHP using data from a database. The issue I am having is that the emails are being combined for each subsequent result match. So if I have 3 users that have the same match criteria, Yes/Yes for example, the first emai...
more »

2017-09-20 18:09 (2) Answers