-4
votes
1answer
30 views

Does Nginx support ssh connections? [closed]

I want to build a site with nginx as HTTP server and MariaDB as SQL server. I'm searching in Google if nginx support (or its included) the ssh support to execute ssh_connect thru PHP files, but I ...
1
vote
1answer
295 views

DBLIB PDO driver keeps failing when trying to connect/query Microsoft Azure SQL database

So I'm using Linux (ubuntu) and I'm trying to connect to a Microsoft Azure SQL database. Server information: The server address is a1a1a1a1a1.database.windows.net (a1a1a1a1a1 is a placeholder for ...
0
votes
2answers
51 views

Ubuntu 10.04 database connection problems

I'm having some problems with a legacy program I'm starting back up. We had an image of this server, and the setup is Ubuntu 10.04, 5gb partition for mysql database, and 100gb filesystem. My issue ...
1
vote
1answer
764 views

Enable MySQL to use more than 1 core (multicore)

I am running a very intensive MySQL query and noticed that only 1 core is being used to 100% while the other cores are idle. The system is running Ubuntu 12.04 and MySQL 5.5.28 Is there a way to ...
0
votes
3answers
24 views

Apache / PHP Begins to Deny SQL Requests after about 2000

We have a web page on our server that we use to run administrative scripts. For example, we might run the script "unenrolStudents()" which runs 5,000 SQL SET commands one after another and sets 5000 ...
1
vote
3answers
269 views

Sending an email via cron

I'd like some advice on how best to send an email after running a SQL query. Every day, I would like to run a PHP/SQL script to identify users who should be emailed. After this runs, I would like to ...
0
votes
3answers
137 views

How to link mysql query to a php process?

I noticed I have an abnormally large amount of mysqld processes which have various mysql queries; I've restarted mysqld and all of these processes come back within 10 seconds. I know the processes ...
0
votes
2answers
134 views

Ideas for SVN/SQL/PHP/Linux Dev Enviroment Supporting Multiple Isolated Environments?

I am trying to create a "dev" for my users. In that environment they would access to their own account of PHPMyAdmin, SQL, Subversion and FTP which is not a big problem, but I would like to emulate ...
0
votes
5answers
697 views

Move MySQL DB to another server

I have server with very big mysql database (160GB). How easy way to move this DB to another server?
0
votes
1answer
52 views

Open Apache connections

Client/Serrver application -- we are having a problem with records failing to upload. It appears that the method I am using in my communication plug-in is that it is trying to open too many ...
0
votes
1answer
191 views

Running indexhibit with a non-MySQL backend — can it be done?

The version of the Indexhibit PHP-based CMS that's available for public download has been 0.70 (or thereabouts) for around four years, and as far as I know, it's been a MySQL-only app for the entirety ...
1
vote
2answers
317 views

Can't login to phpMyAdmin

I am unable to log into phpMyAdmin after installation. Here is my config.inc.php file. Am I doing something obviously wrong? I'm sorry, this is the first time I'm dealing with PHP, MySQL, etc. Thanks ...
1
vote
3answers
96 views

how to set up SQL server

I am very new to SQL server ( 2005 to be exact ) but have been given a backup of a database (in .bak format) which i need to query. My issue lies with this as I have no idea how to set it up so I can ...
0
votes
1answer
138 views

Database event trigger by timer

Suppose I have a table with the current users logged in on my website. And if I there isn't any "activity" from one of his/her username in a time interval it would be deleted from the table. What ...
0
votes
5answers
258 views

Is blocking all traffic to MySql port, EXCEPT from own server IP, a good security measure?

As the title says, would this help? Imagine a classifieds website, where users simply login, logout, post classifieds, delete classifieds etc... All with PHP and mysql. I have my own server, with ...
1
vote
4answers
262 views

How to know if I have/need Linux server or Windows server?

I am creating a classifieds website with PHP and MYSQL. How would I know if I need windows server or Linux? I am about to pick a host. Any other suggestions are also appreciated... Thanks
0
votes
2answers
252 views

Microsoft SQL for PHP driver

I am running a W2K3 x64 server with IIS 7 + FastCGI + PHP 5.3 (x64) I have trouble geting the SQL for php driver to work. It seems it doesn't get loaded, but no error is thrown. I've doublechedked ...