No Aliasdomain & Subdomains listed??

Hi,


I have an ISPConfig 3.1 server, clean installation on Ubuntu 18.04.2. Everything seems to be running fine, but creating my subdomains and aliasdomains I ran into trouble. Non of the created subdomains and aliasdomains where are listed. Trying to create these again, the systems tells me that these are allready in place. And thats trur, they work! But I cant see them which is a big issue...

KR
Dan

 

Hi Till

Logged in as admin. Didn't change admin account yet. Waiting till its all in place and working.

Filter? Come again, Till ???

What are the DB fields/dropdown boxes on the page for adding new subdomains and aliasdomains? I would have showed you a screendump here, but I can't FTP to my server.
It says:
"Active", "Server", "Website"
and whats in those boxes changes. Right now it says:
The FQDM, one of my clients shop.s domain, and under website this https://192.168.1.101:8080/# , the servers ip. On the old server, I can sort the long lists using these boxes. I guess these are still used for this, but why does this information appear here? Is this a database issue? I installed this ISPconfig server a lot of times. Had some issues a few weeks back, but now in the end it worked out perfectly. PhpMyAdmin works too.

 

Hi,

Apparently all you need is to delete the content of the fields/boxes and then hit enter, then the subdomains and aliasdomains are listed again. Problem solved. But a weird one...

 

Di you still want a screenshot? I've got access to FTP now So if you want it, to see how it looked, let me know...

A question on the fly... my last issue is the DB's... I've been reading about how you import these DB's using PhpMyAdmin, but it will still not work. I downloaded a SQL backup from ISPconfig31 CP, and tried to import it to the new ISPConfig server. I did of course, create the user, and the site first. I've got the database created on the new server, same name. But fields empty, no records. Do you know if you are suppose to import the records into an existing DB or import the entire DB to without a DB being created on the new server?

 

Hi Till,


Regarding the DB import, I think its the size. My DB is 24.000Kb and the limit is 2048Kb ?????

Import to server
File to import:
Filen kan være komprimeret (gzip, bzip2, zip) eller ukomprimeret.
En komprimeret fil skal slutte med .[format].[compression]. Eksempel: .sql.zip
Gennemse din computer:(Maksimum size: 2,048KiB)
Du kan også trække og slippe en fil på hvilken som helst side.
Tegnsæt for filen:

-----

"....You said it works now, so I don't need a screenshot, especially as the solution you described shows that you had a filter applied, which was the guess in my first answer..."

It was a line in the last field, which said "https://192.168.1.100:8080/#" - when I "cleaned" this/deleted this fields, it appeared. I don't know why this appeared. It was there automatically
The filter values was a test I did, during the issue and after. I didn't know what the function was for, so I tried my way. This was what made me delete all fields, the ipnummer, port and # shown above too, which made it work in the end. And yes, you where right, again

KR
Dan

 

Import database from command line. For example https://www.digitalocean.com/commun...port-and-export-databases-in-mysql-or-mariadb

 

Hi Till & Taleman,


Thanks, but I'm still having issues exporting and then importing the database. I have read, that there's several flags which has to be set during export or "Export Method".

----------------------------------------------------------------------------------
Exporting tables from "c1ildershop" database
Export Method:

• Quick
• User defined

Table(s):
Select all / Deselect all
Output:

• Save output to a file
  • File name template: brug dette til fremtidige eksports
  • Tegnsæt for filen:

Compression:

• View output as text

Format:

Format-specific options:

• Vis kommentarer (inkluderer info som eksport tidsstempel, PHP version og serverversion)
• • Additional custom header comment (\n splits lines):
  • Inkluder et tidsstempel for hvornår databaser blev oprettet, sidst opdateret og sidst checket
• Inkludér eksport i en transaktion
• Slå fremmednøgle-checks fra
• Databasesystem eller ældre MYSQL server til maksimering af kompatibiltet af output:

• 
• Dump table
  
  
• • struktur
  • data
  • structure and data

Object creation options

• Add statements:
  
  
• • Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT statement
  • Add CREATE PROCEDURE / FUNCTION / EVENT statement
  • Muligheder for CREATE TABLE:
  • • IF NOT EXISTS
    • AUTO_INCREMENT
• Omgiv tabel- og feltnavne med backquotes (Beskytter felt- og tabelnavne indeholdende specielle tegn og nøgleord)

Data dump options

• I stedet for INSERT forespørgsler, brug:
  
  
• • INSERT DELAYED forespørgsler
  • INSERT IGNORE forspørgsler
• Funktioner der bruges, når data udtrækkes:

• Syntaks der bruges, når data indsættes:
  
  
• • inkluder kolonnenavne i hver INSERT forespørgsel
    Eksempel: INSERT INTO tbl_name (col_A,col_B,col_C) VALUES (1,2,3)
  • indsæt flere rækker i hver INSERT forespørgsel
    Eksempel: INSERT INTO tbl_name VALUES (1,2,3), (4,5,6), (7,8,9)
  • begge af ovenstående
    Eksempel: INSERT INTO tbl_name (col_A,col_B) VALUES (1,2,3), (4,5,6), (7,8,9)
  • ingen af ovenstående
    Eksempel: INSERT INTO tbl_name VALUES (1,2,3)
• Maksimal længde på oprettet forespørgsel
• Udtræk binære kolonner i hexadecimal notation (fx, "abc" becomes 0x616263)
• Udtræk TIMESTAMP kolonner i UTC (gør at TIMESTAMP kolonner kan udtrækkes og indsættes i servere på tværs af tidszoner)

----------------------------------------------------------------------------------

Sorry for the danish frases, the headlines is in English, so that you can see what I mean.
And, when hitting "Import" in the new database, errors occur instantly.

----------------------------------------------------------------------------------
Warning in ./libraries/plugin_interface.lib.php#551
count(): Parameter must be an array or an object that implements Countable

Backtrace

./libraries/display_import.lib.php#371: PMA_pluginGetOptions(
string 'Import',
array,
)
./libraries/display_import.lib.php#456: PMA_getHtmlForImportOptionsFormat(array)
./libraries/display_import.lib.php#691: PMA_getHtmlForImport(
string '5cd63945dd367',
string 'database',
string 'c1ildershop',
string '',
integer 2097152,
array,
NULL,
NULL,
string '',
)
./db_import.php#43: PMA_getImportDisplay(
string 'database',
string 'c1ildershop',
string '',
integer 2097152,
)
----------------------------------------------------------------------------------

 

Hi Till,


I'll try that, but is it ok to fiddl with this file. Some ini files isn't suppose to be edited in ubuntu I believe...

# nano /etc/php/7.2/apache2/php.ini

[...]
;;;;;;;;;;;;;;;;
; File Uploads ;
;;;;;;;;;;;;;;;;

; Whether to allow HTTP file uploads.
; http://php.net/file-uploads
file_uploads = On

; Temporary directory for HTTP uploaded files (will use system default if not
; specified).
; http://php.net/upload-tmp-dir
;upload_tmp_dir =

; Maximum allowed size for uploaded files.
; http://php.net/upload-max-filesize
upload_max_filesize = 2M <------------------------ THIS ONE?

; Maximum number of files that can be uploaded via a single request
max_file_uploads = 20
[...]


If, I lost, because it's the import that goes wrong...
Cliking import in PhpMyAdmin, on the new server:


Warning in ./libraries/plugin_interface.lib.php#551
count(): Parameter must be an array or an object that implements Countable

Backtrace

./libraries/display_import.lib.php#371: PMA_pluginGetOptions(
string 'Import',
array,
)
./libraries/display_import.lib.php#456: PMA_getHtmlForImportOptionsFormat(array)
./libraries/display_import.lib.php#691: PMA_getHtmlForImport(
string '5cd6b6033e27d',
string 'database',
string 'c1ildershop',
string '',
integer 8388608,
array,
NULL,
NULL,
string '',
)
./db_import.php#43: PMA_getImportDisplay(
string 'database',
string 'c1ildershop',
string '',
integer 8388608,
)


But! The db I'm trying to move from the old server to the new server is 24.340Kb large....