Questions tagged [web-server]
The web-server tag has no usage guidance.
30 questions
0
votes
1
answer
710
views
IIS web application access SQL DB as service account
I've setup a new Python site on iis using FastCGI handler. The site has windows authentication enabled in iis and the app checks that the AD user belongs to an active directory group when they access ...
- 111
0
votes
1
answer
69
views
Different response time because it does not use the indexes created with the same query and same tables from the web server to the Oracle database
I have a database with Oracle 12c (12.1), where when making a query locally and even from TOAD or another remote tool, it returns the response in milliseconds, reviewing the execution plan I can see ...
- 169
-1
votes
2
answers
395
views
Creating Tables with the same table names from other databases doesn't have any bad effects?
I have a WordPress website and I cloned it to another website(domain) using a plugin called Duplicator. So in the backend, phpMyAdmin, I've two different databases but all the tables in both databases ...
0
votes
1
answer
125
views
Web server accessing the database server in Always on availability group
We have a web server that is on the DMZ but that will need to query a database that resides inside the network. Now the network team wont allow port 1433 from the web server to the Database server.
...
- 1,063
0
votes
2
answers
63
views
Does my database need to connect to a server? [closed]
I'm very new to SQL and databases. I'm currently following this tutorial for creating a Magento website: https://www.tutorialspoint.com/magento/magento_installation.htm
and I'm on Step 4. It says to ...
- 11
0
votes
1
answer
739
views
Cannot allocate memory for the buffer pool when using remote access MySQL
I tried to separate the webserver and mysql server.
MySQL server = 16GB RAM and the config of Innodb_buffer_pool_size = 10GB. And
my Web server = 4GB RAM
My website connect to my database server ...
0
votes
2
answers
228
views
WARN max_connections from pt-variable-advisor - what to configure for DBaaS?
Our VM configuration (hosted on Vmware)
# cat /proc/cpuinfo |grep "cpu cores" | awk -F: '{ num+=$2 } END{ print "cpu cores", num }'
cpu cores 32
# free -h
total used free ...
- 2,558
0
votes
1
answer
2k
views
Two Oracle ORDS on one web server accessing one database
Oracle ORDS 3.0
Oracle 12c database
Red Hat Linux 6.8
Tomcat 8.0.22
Can two ORDS be deployed to one web server (Tomcat) and access the same database?
If so, how is this accomplished?
That is, I ...
- 237
1
vote
2
answers
5k
views
What are possible ways of handling multiple users accessing the same database via custom web API? [closed]
I am very new to databases and Web design, but I understand enough to know that designing a good database is crucial, so I would like to prepare for that conceptually. However, I was unable to find ...
- 115
0
votes
1
answer
6k
views
Where is the data stored in MySQL databases?
I don't know much about RDBMS but I am interested, I am working on a project which requires a database, I am planning to use MySQL to maintain that database.
I have installed MySQL on macOS and I have ...
user120246
1
vote
1
answer
330
views
SQL Server Web Service in a web environment architecture
I am new at SQL Server web Service and not too knowledgeable in setting up a secure web environment...
From what I've read until now regarding SQL Web Service, I would need to:
1. create a stored ...
- 1,093
1
vote
0
answers
2k
views
SQL state S1000 in SQLConnect (but not all the time)
I have a CentOS6 webserver and a database server (MS SQL Server 2012). When I use the website everything is going fine except that once an hour or so I get a can't connect error in my php code. I ...
- 11
1
vote
1
answer
104
views
Sessionizing Web Log Data using MySQL (perhaps by simulating window functions)
I have a large MySQL Table containing about 15 Million rows of web log data. Depending on the IP, useragent and site_id (different sections on the website) I want to create user sessions. The session ...
- 55
6
votes
1
answer
2k
views
Do multiple SQL Server instances increase security?
Context
Let's assume you have a server which exposes a web server and one or more web services to store and manage sensible information about physical persons (assume, for this example, complete ...
- 163
0
votes
1
answer
63
views
Big Size Database and increasing number of users [closed]
Me and my colleagues are using quite big size normalized database.
Basically it's used for warehouse management and daily minimum 100 of the user perform data manipulation operations.
80% of the ...
- 101
2
votes
1
answer
7k
views
best way to store tags
I'm a university student building a web application for a project with three collegues , I took the database portion.
Our site is basically a link sharing site and supports tags, what is an efficient ...
- 121
3
votes
2
answers
23k
views
mysql connection timeout on small traffic server
How can I set up MySQL so that connections never time out? And how do I even check to see what the current settings for variables such as wait_timeout and interactive_timeout, etc. are? Given that ...
- 487
0
votes
1
answer
634
views
How to get mysql automatically running when I start tomcat apache on Windows?
When starting my Tomcat Apache Server, I've been having to start up mysql before than using the mysqld command. I was wondering if there was a work around this so that I could have mysql start up when ...
- 1
2
votes
1
answer
130
views
How dangerous is it to have a user's password in plaintext in a cgi script?
I am setting up a MySQL database and am providing a web interface for it. Now, the DB is extremely simple and the interface just runs certain SELECT statements.
I have created a user for my script to ...
- 123
1
vote
1
answer
893
views
Pl/SQL web application
I have a PL/SQL web application,got the entire DB dump from remote DB.
Its very old application, running on oracle 9i.
I basically want to get the application up and running on my laptop,but i am not ...
- 11
11
votes
3
answers
934
views
Is backing a website by a SQL Server 2012 OLAP cube considered reasonable?
I have been tasked with architecting a solution for a large retail chain. They want to allow each of its 1.2 million customers to log on to a web site to see the distribution of recent purchases (...
- 213
1
vote
1
answer
2k
views
MySQL Tables crashing randomly
This is one of the many random Tables that get corrupted. Any ideas why and what would be causing this?
How do I keep MySQL tables from crashing and MySQL from crashing?
Repairing USR_wp537
...
- 185
1
vote
1
answer
1k
views
Using multiple Active Directory accounts to connect to SQL Server
I have web applications (Classic ASP and .NET) that connect to SQL Server using SQL authentication. Each one has their own login. I want to convert these to Windows Authentication. The new AD users (1 ...
- 2,053
1
vote
1
answer
2k
views
SQL Server connection from iis website: "error: 26 - Error Locating Server/Instance Specified"
I've just moved all my databases from one server to another clustered server. The new SQL Server 2008 R2 (enterprise edition) install is using named instances on a non-standard port. SQL is running ...
- 1,620
4
votes
1
answer
3k
views
Good articles for SQL Server Health Check specifically for Web Applications
I am searching for Database Health check articles specifically for a web application back-end server and SQL Server 2005/2008.
My current checklist includes:
- Index Fragmentation
- SQL Server ...
- 1,507
3
votes
1
answer
713
views
Does MVC architecture design pattern effect MySQL database performance?
Our current site is entirely developed in the cakePHP framework with the MVC architecture. If we notice more than around 19-20 users viewing the site at once, it begins to crawl to a hault and begin ...
- 227
4
votes
2
answers
4k
views
Best way to build a server inventory db and web interface?
My team is looking to build a rich inventory of servers at our enterprise. We are trying to consolidate several different excel documents into one database.
I found a great utility called AppGini (...
- 515
2
votes
1
answer
176
views
Oracle Control and Webserver
How does the Database Control work, since Apache is not running on this computer? The Url says https://localhost:1158/em/console/logon/logon. I do have a WAMP apache server on here but I have to shut ...
- 171
2
votes
1
answer
1k
views
How to configure so the Oracle wallet password can be authenticated with a web based Oracle application?
Does anyone know how to configure it so that the Oracle wallet password can be authenticated with a web based Oracle application?
I’m trying to make secure LDAP connections with an Oracle web based ...
- 21
18
votes
3
answers
1k
views
How to store 'n' days of web server logs in Sql Server?
For faster reporting and performance analysis, we want to insert our web server logs into Sql Server. This will allow us to see traffic patterns, issues, slowdowns in near real-time.
We have a daemon ...
- 283