dil_bert

probably the paths are not correct... /** Absolute path to the WordPress directory. */ if ( ! defined( 'ABSPATH' ) ) { define( 'ABSPATH', dirname( _FILE_ ) . '/' ); } [/CODE] see here the errors [CODE]Warning: mysqli_connect(): (HY000/2002): No such file or directory in /sites/www.mysite.de/testconnection.php on line 2 Warning: mysqli_error() expects exactly 1 parameter, 0 given in /sites/www.mysite.de/testconnection.php on line 4 Could not connect: [/CODE] i think that i have to understand the errors...

hello again dear friends hello dear MaxDD and Barand first of all - many many thanks for the quick reply - great to hear from you. i will check the ressources that you adviced to have a closer look at. - the php-ressource - the wp-class.... besides that : my serveradmin told me that i have to be careful with the path / the pipe-path on the server.... well i think that it has to do with the pipe path to mysql .... i will digg deeper and i of course will keep you informed stay tuned and have a grat day btw: see the images ..that i have attached

hello dear experts, good day. one question regarding webmin: can we change the password in webmin - are we able to set a new pwd in the system!?

hello again - some updates - i will have a closer loook at all - and will re check all the configurations etc. etx. I also will check the paths - eg. the pipe-path to mysql... i come back and report all the findings. have a great day

Could not connect: **update:** i just use this... * @link https://codex.wordpress.org/Editing_wp-config.php * * @package WordPress */ // ** MySQL settings - You can get this info from your web host ** // /** The name of the database for WordPress */ define('DB_NAME', 'my_db_name'); /** MySQL database username */ define('DB_USER', 'my_user_name'); /** MySQL database password */ define('DB_PASSWORD', 'mypasswd'); /** MySQL hostname */ define('DB_HOST', 'localhost'); /** Database Charset to use in creating database tables. */ define('DB_CHARSET', 'utf8'); and yes:_ i also enabled the debugging mode define('WP_DEBUG', false); define('WP_ALLOW_REPAIR', true);

well should i change the code some how!? from $data = mysqli_query($link, $query)or die(mysqli_error()); to $data = mysqli_query($link, $query)or die(mysqli_error($link));

hello dear all , well i have still issues with the access of the db Warning: mysqli_connect(): php_network_getaddresses: getaddrinfo failed: Name or service not known in /sites/www.mysite.de/testconnection.php on line 3 Warning: mysqli_connect(): (HY000/2002): php_network_getaddresses: getaddrinfo failed: Name or service not known in /sites/www.mysite.de/testconnection.php on line 3 Warning: mysqli_error() expects parameter 1 to be mysqli, boolean given in /sites/www.mysite.de/testconnection.php on line 4 could not connect: <?php if(function_exists('mysqli_connect')){ if(!($link = mysqli_connect('localhost:8005','jobstarter','susi19','jobstarter'))){ die('could not connect: ' . mysqli_error($link)); } } else { die("don't have mysqli"); } echo 'connect successfully'; mysqli_close($link); and i get back the following

hello dear all , well i have still issues with the access of the db Warning: mysqli_connect(): php_network_getaddresses: getaddrinfo failed: Name or service not known in /sites/www.mysite.de/testconnection.php on line 3 Warning: mysqli_connect(): (HY000/2002): php_network_getaddresses: getaddrinfo failed: Name or service not known in /sites/www.mysite.de/testconnection.php on line 3 Warning: mysqli_error() expects parameter 1 to be mysqli, boolean given in /sites/www.mysite.de/testconnection.php on line 4 could not connect: <?php if(function_exists('mysqli_connect')){ if(!($link = mysqli_connect('localhost:8005','user','passwd','db-name'))){ die('could not connect: ' . mysqli_error($link)); } } else { die("don't have mysqli"); } echo 'connect successfully'; mysqli_close($link); and i get back the following <?php if(function_exists('mysqli_connect')){ if(!($link = mysqli_connect('localhost:8005','username','passwd','db_name'))){ die('could not connect: ' . mysqli_error($link)); } } else { die("don't have mysqli"); } echo 'connect successfully'; mysqli_close($link); Warning: mysqli_connect(): php_network_getaddresses: getaddrinfo failed: Name or service not known in /sites/www.mysite.de/testconnection.php on line 3 Warning: mysqli_connect(): (HY000/2002): php_network_getaddresses: getaddrinfo failed: Name or service not known in /sites/www.mysite.de/testconnection.php on line 3 Warning: mysqli_error() expects parameter 1 to be mysqli, boolean given in /sites/www.job-starter.de/testconnection.php on line 4 could not connect: well i wonder what is going on here

hello again - did not help so far... as all the trials failed - i tried the following: https://www.wpbeginner.com/wp-tutorials/how-to-fix-the-error-establishing-a-database-connection-in-wordpress/ <?php $link = mysqli_connect('localhost', 'username', 'password'); if (!$link) { die('Could not connect: ' . mysqli_error()); } echo 'Connected successfully'; mysqli_close($link); ?> Make sure to replace the username and password. If the script connected successfully, then it means that your user has sufficient permission, and there is something else that is wrong. Go back to your wp-config file to make sure that everything there is correct (re-scan for typos). well see what i get back here: Warning: mysqli_connect(): (HY000/2002): No such file or directory in /sites/www.job-starter.de/testconnection.php on line 2 Warning: mysqli_error() expects exactly 1 parameter, 0 given in /sites/www.job-starter.de/testconnection.php on line 4 Could not connect: well i have to muse _ what goes on here.. something goes wrong... i will digg deeper - and come back again and report all the findings.

hello dear phpexperts, i thought that during the installation process the file wp-config-sample.php gets to wp-config.php - but this is not happening. i want to edit the file now and i will afterwards store it as wp_config.php on the server ab. Btw: i am still wondering why this was not happening so far additionally - i will do the following gem. https://www.wpbeginner.com/wp-tutorials/how-to-fix-the-error-establishing-a-database-connection-in-wordpress/ define('WP_ALLOW_REPAIR', true); [/CODE] [QUOTE] once you have done that, you can see the settings by visiting this page: [/QUOTE] see here http://www.yoursite.com/wp-admin/maint/repair.php i come back and report all the findings

good day dear experts, I am new to PHP's SimpleXML. - i have issues wiht it - and with the process of filter to get the nodes with special category :: PHP SimpleXML I want to filter the data to get the nodes with special category. Here is sample of the OSM data I want to get the whole schools within an area. The first script runs well - but now I want to refine the search and add more tags. I want to store all into MySQL. So we need to make some XML parsing with PHP: The following is a little OSM Overpass API example with PHP SimpleXML <?php /** * OSM Overpass API with PHP SimpleXML / XPath * * PHP Version: 5.4 - Can be back-ported to 5.3 by using 5.3 Array-Syntax (not PHP 5.4's square brackets) */ // // 1.) Something is wrong an OSM Overpass API Endpoint // $Something is wrong = 'node ["addr:postcode"~"RM12"] (51.5557914,0.2118915,51.5673083,0.2369398)->.point; ( node (around.point:100000) ["amenity"~"school"]; way (around.point:100000) ["amenity"~"school"]; ); out;'; $context = stream_context_create(['http' => [ 'method' => 'POST', 'header' => ['Content-Type: application/x-www-form-urlencoded'], 'content' => 'data=' . urlencode($Something is wrong), ]]); # please do not stress this service, this example is for demonstration purposes only. $endpoint = 'http://overpass-api.de/api/interpreter'; libxml_set_streams_context($context); $start = microtime(true); $result = simplexml_load_file($endpoint); printf("Something is wrong returned %2\$d node(s) and took %1\$.5f seconds.\n\n", microtime(true) - $start, count($result->node)); // // 2.) Work with the XML Result // # get all school nodes with xpath $xpath = '//node[tag[@k = "amenity" and @v = "school"]]'; $schools = $result->xpath($xpath); printf("%d School(s) found:\n", count($schools)); foreach ($schools as $index => $school) { # Get the name of the school (if any), again with xpath list($name) = $school->xpath('tag[@k = "name"]/@v') + ['(unnamed)']; printf("#%02d: ID:%' -10s [%s,%s] %s\n", $index, $school['id'], $school['lat'], $school['lon'], $name); } well i get back an issue-report;: FATAL ERROR syntax error, unexpected 'is' (T_STRING) on line number 11 well at the moment i try to make up my mind what is going on here

good day dear Barand many many thanks for the quick reply. Youre right - and i am glad that you pointed it out - the GRANT is not for standard users. Besides this: well i have been enabling my home computer IP address to access a online (remote) database. question: is there a quick way I can connect to the database from the command prompt of my laptop to make sure its allowing access from my IP address - and furthermore to test if the db is up and running!? well i guess that i can do it like so: use mysql client, if we allready have it installed _ to be frank it's quite easy to access a remote host mysql -hyour_ddbb_server_ip -uyour_user -pyour_password your_database_name or mysql -h your_ddbb_server_ip -u your_user -p your_database_name * idea and note that in the first option in the code does not mean that they are no blank spaces between parameter option and its value *idea and note: the _database_name is optional - that said it is not 100 % necessary to give this dbname! what do you say - does this work propperly? greetings

hello and good day I want to make a test of the mysql-server connection remotelywell - i need to do a testdrive of the connection remotely, therefore i need to get access to the MySQL-server (that stands remote) from my linux-notebook. The procedure: i first of all need to have the ip of the server: i can use for example this one 64.45.36.17 as the IP address of the remote MySQL server: # mysql -u fooUser -p -h 64.45.36.17 and then i am asked for a password i have to add or enter a password: then the machine says Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 17 Server version: 5.0.45 Source distribution some additional commands we can type 'help;' or '\h' for help. Type '\c' to clear the buffer . that might be sometimes very very helpful. mysql> _ Considerations When we wanna set up a remote user, we have to do some considerations: we have to consider the following information: well a local user is different from a remote user. This may sound trivial but it is pretty important: For example, foo_bar@localhost is not the same as fooUser@1.2.3.4.5.6.7.8.9 - here you see that this is a whole other thing. If we want both users to have the same permissions, then we have to take care for a smart setup: We need sometimes to do a little extra work:; we sometimes have to meet the need to duplicate permissions. Belive it or not - it is true. well - to be honest - i really do not want to do any harm - so i don’t recommend granting ALL permissions. For standard users, i now do recommend granting GRANT SELECT,INSERT,UPDATE,DELETE permissions. this is what i tell everybody... some extra infos: To grant access to only a specific table, we can use the database.table command. this is a top notch command. For example, in the preceding step, you could use fooDatabase.fooTable instead of fooDatabase. If you’re using iptables, you need to add an entry to your firewall rule for Transmission Control Protocol (TCP) port 3306. love to hear from you

have reworked the dataset - well it does not work at the moment - i have no glue at the moment

Libreoffice is not workin propperly - i have only grey scaled areas - see the image guess i do a upgrade

good day dear freaks well my friends recommended me to run a short and a long test weekly or on all my hdd-drives. To run a long test, the command is this here: sudo smartctl -t long -a /dev/sdX One of the first things we should see is the results of the SMART overall-health self-assessment test. In short - the test should say (and give back) PASSED. Danger: If it does not, we know, right away, there's obviousliy something wrong with the drive. well we can have a short and a long test: i will show how we do these tests: The short test will examine the following: - all the included hw (hardware) things in the drive will be tested; - the electrical properties of the drive: well here we talk about the controller tests its own electronics, which in generall all that is very different for each manufacturer; - the mechanical properties of the drive: well here we talk about the servos and positioning mechanisms are tested ( in generall all that is very specific to each manufacturer); - the read/verify-processes and procedures: well - alot of amount will certainly go into these parts of the test: we sure can say that certain area of the disk will be; read to verify very very certain data and bits and bytes (especially we can say that the size and position of the region read is in general very unique to each manufacturer); lets have a quick look at the long test too; we can say that the long test runs everything included with the short test, while adding: - here we have a global test and in general no time restriction and in the Read/Verify segment. - here we have a great test regarding the whole disk - the whole disc is is checked (as opposed to just a section in the quick-test). - in opposite to the quick and short-time-test which takes approximately two minutes to complete, the long (andoverall) test will require between 20-60 minutes ( which of course is depending upon the specs of the hardware). here the command to have a view on the the results of the test, issue the command sudo smartctl -a /dev/sdX (and in this command the term sdX is the name of the drive - that we want to test). The good thing: this command will do a print out of the results of the test, i am glad that i run the test on a regular base! just wanted to share this with you. - it has helped me alot. greetings

hello dear all - well the question is - How to check the health of a HDD We all know that HDD sometimes may have a limited (probably predetermined) life span. So the question for me is how do I check in (Manjaro) Linux what the current health status of my HD is? And maybe an estimation how long it will take? Well a gGraphical tool is preferred, but command line tool would also be fine. i heard that i can go the GNOME way like Install Gnome Disk Utility and then i could do the check SMART Data and do some tests : eg the tests for wear-leveling-count or similar. Some of the test may include the following: The higher that number (%, from 1 to 100), the more "used up" of our HDD is, which means we are more likely to have problems. But if we have a recent HDD, we need not worry about it. Installed via sudo apt-get install gnome-disk-utility start it via either menu->Settings->Disk utility or via command line sudo gnome-disks But - the question is - how to run the SMART-Teswts on KDE - generally spoken; How to check the health of a HDD For Ubuntu, Mint, ARCH [like Manjaro], OpenSuse or Debian based distributions heard about doing it like so: # apt-get install smartmontools The Media_Wearout_Indicator is what we may have a closer look for. Some extra data: For 100 means the HDD has got an approximatley 100% lifespan, And besides that the lower number means less life left. # smartctl -a /dev/sda | grep Media_Wearout_Indicator To show your HDD information # smartctl -a /dev/sda Well - i will try it out on my Manjaro-Linux-System - with KDE .... Will come back and report all the findings. Untill soon

good day dear all, i guess that i need to make sure that the Start Date column is formatted MM/dd/yyyy. Since i only need all day events i guess that i'll just need a, Start Date column, not the End Date or Time columns. I'm not sure if i need to work over the multiple "Description" columns though... guess that i have to merge them into a single column I suppose.

hello dear freaks - well to explain it a bit futher.. what is aimed: well i need a import of data into google-calendar via the API - an automation that is triggered by my calc shee and sends data to the Google Calendar, sending each one item i add to Excel and adding a new row to any spreadsheet we want with ... - Sync Google Calendar and a Calc or Excel sheet - Integrate Google Calendar and Libreoffice Calc or Microsoft Excel the way i want and need. well i need to create new rows in spreadsheets automatically. question: how to connect Google Calendar and Libreoffice Calc or MS Excel!?. btw - see the above mentioned and attached data - to see which data i need to import i look forward to hear from you

hello dear benanamen many thanks for your quick answer and the hints. Very good idea. Greetings

hello dear all - we ve got two options "CSV to Calendar": https://github.com/egeldenhuys/csv-to-calendar see here also https://support.google.com/calendar/answer/37118?hl=de

hello and good day dear experts i am a long time user of FileZilla. one Question - can Keepass support me in storing data and credentials for FileZilla!? love to hear from you

good day dear php-freaks i want to do a import of data from calc via Google-API to google-Calendar!? see the differnt formats - in calc- and in a printed sheme.... or in other words - ready to print. question how to arrange to port to the google-calendar!?

hello dear all, wanna run windows and linux side by side on s notebook - is this doable !? eg with manjaro linux - and windows 10

hello dear all - found out more infos - i have seen a how-to: that guides through the process of setting up the db and the user: Create and Manage MySQL Users in Webmin https://admin-ahead.com/forum/webminvirtualmin/create-and-manage-mysql-users-in-webmin/ well now i try to find out why it does not work with the installation of a wordpress-site.. note#: the wqeustion is: should i use a. localhost or b. any host love to hear from you